RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA853194" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA853194 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
840927 840927 PRJNA853194_S_NODE_69401_length_264_cov_0.790576_g68310_i0 PRJNA853194 69401 264 0.790576 2.08712064 Hirudo verbana 311461 Annelida Annelida 99 3.05e-16   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g68310 i0 88.235 0.685606060606061 85 7 32 2 114 197 8243960 8244042 Hirudo verbana genome assembly, chromosome: 3 blastn 181 99 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
5944336 5944336 PRJNA853194_S_NODE_82385_length_244_cov_2.187135_g81294_i0 PRJNA853194 82385 244 2.187135 5.3366094 Hirudo verbana 311461 Annelida Annelida 52.8 0.022   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g81294 i0 100 0.114754098360656 28 0 11 0 206 233 1633851 1633878 Hirudo verbana genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
9767776 9767776 PRJNA853194_S_NODE_11448_length_563_cov_2.544898_g10389_i0 PRJNA853194 11448 563 2.544898 14.32777574 Hirudo verbana 311461 Annelida Annelida 54.7 0.015   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g10389 i0 100 0.0515097690941385 29 0 5 0 101 129 5592519 5592547 Hirudo verbana genome assembly, chromosome: 11 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
9768663 9768663 PRJNA853194_S_NODE_5328_length_784_cov_1.696203_g4477_i0 PRJNA853194 5328 784 1.696203 13.29823152 Ailoscolex lacteospumosus 1046305 Annelida Annelida 540 1.3799999999999996e-148   NTclustered gi|2920003636|emb|OZ238874.1| 1046305 g4477 i0 81.14 0.872448979591837 684 120 87 8 1 679 3981748 3981069 Ailoscolex lacteospumosus genome assembly, chromosome: 15 blastn 684 540 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
9768932 9768932 PRJNA853194_S_NODE_67148_length_268_cov_1.235897_g66057_i0 PRJNA853194 67148 268 1.235897 3.31220396 Dendrobaena succinta 3157997 Annelida Annelida 56.5 0.002   NTclustered gi|2898690909|gb|PP922155.1| 3157997 g66057 i0 89.362 0.175373134328358 47 2 17 3 207 251 6524 6479 Dendrobaena succinta mitochondrion, partial genome blastn 47 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Dendrobaena Dendrobaena succinta
11044726 11044726 PRJNA853194_S_NODE_77949_length_249_cov_2.051136_g76858_i0 PRJNA853194 77949 249 2.051136 5.10732864 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.006   NTclustered gi|2920003484|emb|OZ238865.1| 1046305 g76858 i0 88.636 0.357429718875502 44 5 18 0 4 47 19627831 19627874 Ailoscolex lacteospumosus genome assembly, chromosome: 6 blastn 89 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
12320013 12320013 PRJNA853194_S_NODE_61270_length_280_cov_1.381643_g60179_i0 PRJNA853194 61270 280 1.381643 3.8686004 Hirudo verbana 311461 Annelida Annelida 52.8 0.026   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g60179 i0 100 0.1 28 0 10 0 243 270 1941153 1941180 Hirudo verbana genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
18691802 18691802 PRJNA853194_S_NODE_46835_length_316_cov_3.600823_g45744_i0 PRJNA853194 46835 316 3.600823 11.37860068 Hirudo verbana 311461 Annelida Annelida 54.7 0.008   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g45744 i0 96.875 0.392405063291139 32 1 10 0 117 148 8776774 8776743 Hirudo verbana genome assembly, chromosome: 9 blastn 124 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
18692213 18692213 PRJNA853194_S_NODE_675_length_1642_cov_7.334608_g477_i0 PRJNA853194 675 1642 7.334608 120.43426336 Helobdella robusta 6412 Annelida Annelida 54.7 0.047   NTclustered gi|675884701|ref|XM_009029605.1| 6412 g477 i0 100 0.0176613885505481 29 0 2 0 957 985 321 293 Helobdella robusta hypothetical protein mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
19967386 19967386 PRJNA853194_S_NODE_66176_length_270_cov_1.172589_g65085_i0 PRJNA853194 66176 270 1.172589 3.1659903 Hirudo verbana 311461 Annelida Annelida 58.4 5.32e-4   NTclustered gi|2918369693|emb|OZ237785.1| 311461 g65085 i0 97.143 7.91851851851852 35 0 13 1 196 229 182129 182095 Hirudo verbana genome assembly, chromosome: 7 blastn 2138 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
22517403 22517403 PRJNA853194_S_NODE_56698_length_290_cov_1.718894_g55607_i0 PRJNA853194 56698 290 1.718894 4.9847926 Hirudo verbana 311461 Annelida Annelida 52.8 0.027   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g55607 i0 94.286 0.120689655172414 35 1 12 1 249 283 13509543 13509510 Hirudo verbana genome assembly, chromosome: 3 blastn 35 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
25067222 25067222 PRJNA853194_S_NODE_77740_length_250_cov_0.870056_g76649_i0 PRJNA853194 77740 250 0.870056 2.17514 Hirudo verbana 311461 Annelida Annelida 52.8 0.023   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g76649 i0 100 0.112 28 0 11 0 12 39 3203813 3203840 Hirudo verbana genome assembly, chromosome: 13 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana

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);;