contig_metadata
14 rows where bioproject = "PRJNA1195551", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322634 | 322634 | PRJNA1195551_S_NODE_7701_length_324_cov_6.549091_g7348_i0 | PRJNA1195551 | 7701 | 324 | 6.549091 | 21.21905484 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 126 | 1.7699999999999998e-24 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g7348 | i0 | 83.217 | 0.441358024691358 | 143 | 19 | 44 | 4 | 6 | 147 | 8520530 | 8520668 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 143 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 1043079 | 1043079 | PRJNA1195551_S_NODE_25381_length_200_cov_4.788079_g25028_i0 | PRJNA1195551 | 25381 | 200 | 4.788079 | 9.576158 | Clitellata | 42113 | Annelida | Annelida | 370 | 4.22e-98 | NTclustered | gi|2703725018|gb|PP534975.1| | 35632 | g25028 | i0 | 100 | 100 | 200 | 0 | 100 | 0 | 1 | 200 | 116 | 315 | Lumbricus rubellus isolate E62 small subunit ribosomal RNA gene, partial sequence | blastn | 20000 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus rubellus | |
| 1597238 | 1597238 | PRJNA1195551_S_NODE_6522_length_344_cov_5.667797_g6169_i0 | PRJNA1195551 | 6522 | 344 | 5.667797 | 19.49722168 | Lumbricus terrestris | 6398 | Annelida | Annelida | 566 | 9.399999999999999e-157 | NTclustered | gi|1770648313|gb|MK730713.1| | 6398 | g6169 | i0 | 98.16 | 93.6831395348837 | 326 | 2 | 94 | 2 | 22 | 344 | 1 | 325 | Lumbricus terrestris voucher LT_D_IV_A_2 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 32227 | 566 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 6700448 | 6700448 | PRJNA1195551_S_NODE_21346_length_217_cov_3.404762_g20993_i0 | PRJNA1195551 | 21346 | 217 | 3.404762 | 7.38833354 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.019 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g20993 | i0 | 100 | 0.129032258064516 | 28 | 0 | 13 | 0 | 135 | 162 | 2520575 | 2520602 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6700496 | 6700496 | PRJNA1195551_S_NODE_34946_length_172_cov_3.804878_g34593_i0 | PRJNA1195551 | 34946 | 172 | 3.804878 | 6.54439016 | Octodrilus complanatus | 1046380 | Annelida | Annelida | 318 | 1.2899999999999999e-82 | NTclustered | gi|341833250|gb|HQ728941.1| | 1046380 | g34593 | i0 | 100 | 103.389534883721 | 172 | 0 | 100 | 0 | 1 | 172 | 2276 | 2105 | Octodrilus complanatus 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17783 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Octodrilus | Octodrilus complanatus | |
| 9250443 | 9250443 | PRJNA1195551_S_NODE_18288_length_232_cov_7.557377_g17935_i0 | PRJNA1195551 | 18288 | 232 | 7.557377 | 17.53311464 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g17935 | i0 | 100 | 1.19396551724138 | 30 | 0 | 13 | 0 | 203 | 232 | 857612 | 857641 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 277 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13076225 | 13076225 | PRJNA1195551_S_NODE_4731_length_394_cov_9.382609_g4378_i0 | PRJNA1195551 | 4731 | 394 | 9.382609 | 36.96747946 | Aporrectodea trapezoides | 408844 | Annelida | Annelida | 728 | 0 | NTclustered | gi|238818316|gb|FJ967664.1| | 408844 | g4378 | i0 | 100 | 99.9137055837563 | 394 | 0 | 100 | 0 | 1 | 394 | 808 | 1201 | Aporrectodea trapezoides isolate MPL94 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 39366 | 728 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea trapezoides | |
| 16345607 | 16345607 | PRJNA1195551_S_NODE_27373_length_193_cov_5.090278_g27020_i0 | PRJNA1195551 | 27373 | 193 | 5.090278 | 9.82423654 | Lumbricidae | 6392 | Annelida | Annelida | 357 | 3.1499999999999996e-94 | NTclustered | gi|11494215|gb|AF212166.1|AF212166 | 6396 | g27020 | i0 | 100 | 133.658031088083 | 193 | 0 | 100 | 0 | 1 | 193 | 2665 | 2857 | Eisenia fetida 28S ribosomal RNA gene, partial sequence | blastn | 25796 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 19448656 | 19448656 | PRJNA1195551_S_NODE_4316_length_410_cov_5.739612_g3963_i0 | PRJNA1195551 | 4316 | 410 | 5.739612 | 23.5324092 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 442 | 2e-119 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g3963 | i0 | 86.165 | 6.58292682926829 | 412 | 54 | 99 | 2 | 2 | 410 | 15241303 | 15240892 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 2699 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21999369 | 21999369 | PRJNA1195551_S_NODE_38258_length_166_cov_1.760684_g37905_i0 | PRJNA1195551 | 38258 | 166 | 1.760684 | 2.92273544 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g37905 | i0 | 100 | 0.180722891566265 | 30 | 0 | 18 | 0 | 136 | 165 | 16231474 | 16231445 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24548676 | 24548676 | PRJNA1195551_S_NODE_20840_length_219_cov_5.505882_g20487_i0 | PRJNA1195551 | 20840 | 219 | 5.505882 | 12.05788158 | Eisenia nordenskioldi | 538895 | Annelida | Annelida | 231 | 2.3199999999999997e-56 | NTclustered | gi|2178346761|gb|OL840315.1| | 538895 | g20487 | i0 | 86.321 | 65.3150684931507 | 212 | 29 | 97 | 0 | 8 | 219 | 1291 | 1502 | Eisenia nordenskioldi isolate 374NHb mitochondrion, complete genome | blastn | 14304 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia nordenskioldi | |
| 27388714 | 27388714 | PRJNA1195551_S_NODE_8643_length_311_cov_1.519084_g8290_i0 | PRJNA1195551 | 8643 | 311 | 1.519084 | 4.72435124 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 63.9 | 1.92e-10 | NR | KAI0218681.1 | 104711 | g8290 | i0 | 44.2 | 0.742765273311897 | 77 | 36 | 73.3 | 3 | 1 | 228 | 55 | 125 | KAI0218681.1 Profilin [Lamellibrachia satsuma] | diamond | 231 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28177634 | 28177634 | PRJNA1195551_S_NODE_38426_length_166_cov_0.863248_g38073_i0 | PRJNA1195551 | 38426 | 166 | 0.863248 | 1.43299168 | Cossura aciculata | 3162496 | Annelida | Annelida | 43.9 | 0.005 | NR | XOU09021.1 | 3162496 | g38073 | i0 | 90.9 | 31.8072289156627 | 22 | 2 | 39.8 | 0 | 126 | 61 | 201 | 222 | XOU09021.1 cytochrome c oxidase subunit 3 [Cossura aciculata] | diamond | 5280 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Cossuridae | Cossura | Cossura aciculata | ||
| 32632915 | 32632915 | PRJNA1195551_S_NODE_8700_length_310_cov_2.846743_g8347_i0 | PRJNA1195551 | 8700 | 310 | 2.846743 | 8.8249033 | Imetescolex patriarchalis | 1537933 | Annelida | Annelida | 103 | 2.3499999999999994e-23 | NR | XNY95961.1 | 1537933 | g8347 | i0 | 78.1 | 1.23870967741935 | 64 | 12 | 61.9 | 1 | 118 | 309 | 498 | 559 | XNY95961.1 NADH dehydrogenase subunit 5 [Imetescolex patriarchalis] | diamond | 384 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Imetescolex | Imetescolex patriarchalis |
Advanced export
JSON shape: default, array, newline-delimited
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);;