RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1065838" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1065838 · 6 ✖

analysis 1

  • blastn · 6 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
180174 180174 PRJNA1065838_S_NODE_5561_length_312_cov_3.121673_g5459_i0 PRJNA1065838 5561 312 3.121673 9.73961976 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.029   NTclustered gi|2919610158|emb|OZ238415.1| 2546182 g5459 i0 100 0.0897435897435897 28 0 9 0 284 311 2961648 2961675 Chelidura thaleri genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
6558043 6558043 PRJNA1065838_S_NODE_33886_length_165_cov_6.241379_g33784_i0 PRJNA1065838 33886 165 6.241379 10.29827535 Artemia franciscana 6661 Arthropoda Arthropoda 139 1.03e-28   NTclustered gi|2743069157|ref|XR_010617433.1| 6661 g33784 i0 95.402 4.56363636363636 87 4 82 0 1 87 3143 3229 PREDICTED: Artemia franciscana E3 ubiquitin-protein ligase COP1-like (LOC136026874), transcript variant X2, misc_RNA blastn 753 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10383281 10383281 PRJNA1065838_S_NODE_22789_length_194_cov_1.075862_g22687_i0 PRJNA1065838 22789 194 1.075862 2.08717228 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 172 1.23e-38   NTclustered gi|1325255695|ref|XM_023464585.1| 1294199 g22687 i0 83.422 43.1494845360825 187 29 96 2 9 194 939 1124 PREDICTED: Eurytemora carolleeae actin-5C (LOC111695310), mRNA blastn 8371 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
12933704 12933704 PRJNA1065838_S_NODE_17651_length_209_cov_4.187500_g17549_i0 PRJNA1065838 17651 209 4.1875 8.751875 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g17549 i0 100 0.138755980861244 29 0 14 0 148 176 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
12933872 12933872 PRJNA1065838_S_NODE_35851_length_162_cov_16.353982_g35749_i0 PRJNA1065838 35851 162 16.353982 26.49345084 Artemia franciscana 6661 Arthropoda Arthropoda 261 2.06e-65   NTclustered gi|2743025003|ref|XR_010621486.1| 6661 g35749 i0 95.679 23.5617283950617 162 7 100 0 1 162 551 712 PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA blastn 3817 261 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
12933893 12933893 PRJNA1065838_S_NODE_6351_length_296_cov_1.327935_g6249_i0 PRJNA1065838 6351 296 1.327935 3.9306876 Calliphora vicina 7373 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2736825126|ref|XM_065502654.1| 7373 g6249 i0 97.059 0.114864864864865 34 0 11 1 139 172 442 410 PREDICTED: Calliphora vicina acanthoscurrin-1-like (LOC135952640), mRNA blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;