contig_metadata
25 rows where bioproject = "PRJNA680334", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 649274 | 649274 | PRJNA680334_S_NODE_19421_length_256_cov_27.125561_g18935_i0 | PRJNA680334 | 19421 | 256 | 27.125561 | 69.44143616 | Lumbricus terrestris | 6398 | Annelida | Annelida | 387 | 5.6199999999999985e-103 | NTclustered | gi|2472106000|emb|OX457054.1| | 6398 | g18935 | i0 | 94.094 | 1.984375 | 254 | 15 | 99 | 0 | 1 | 254 | 12378 | 12125 | Lumbricus terrestris genome assembly, organelle: mitochondrion | blastn | 508 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 1925524 | 1925524 | PRJNA680334_S_NODE_23322_length_242_cov_19.583732_g22836_i0 | PRJNA680334 | 23322 | 242 | 19.583732 | 47.39263144 | Lumbricus terrestris | 6398 | Annelida | Annelida | 381 | 2.449999999999999e-101 | NTclustered | gi|2472106000|emb|OX457054.1| | 6398 | g22836 | i0 | 95.041 | 4.65289256198347 | 242 | 12 | 100 | 0 | 1 | 242 | 5783 | 5542 | Lumbricus terrestris genome assembly, organelle: mitochondrion | blastn | 1126 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 3200145 | 3200145 | PRJNA680334_S_NODE_1643_length_549_cov_10.587209_g1195_i0 | PRJNA680334 | 1643 | 549 | 10.587209 | 58.12377741 | Lumbricus terrestris | 6398 | Annelida | Annelida | 846 | 0 | NTclustered | gi|5835191|ref|NC_001673.1| | 6398 | g1195 | i0 | 95.636 | 75.5992714025501 | 527 | 23 | 96 | 0 | 23 | 549 | 3413 | 2887 | Lumbricus terrestris mitochondrion, complete genome | blastn | 41504 | 846 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 3201160 | 3201160 | PRJNA680334_S_NODE_75263_length_168_cov_4.000000_g74777_i0 | PRJNA680334 | 75263 | 168 | 4 | 6.72 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g74777 | i0 | 100 | 0.172619047619048 | 29 | 0 | 17 | 0 | 6 | 34 | 1260813 | 1260785 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5752887 | 5752887 | PRJNA680334_S_NODE_15625_length_274_cov_4.788382_g15139_i0 | PRJNA680334 | 15625 | 274 | 4.788382 | 13.12016668 | Lumbricus terrestris | 6398 | Annelida | Annelida | 424 | 4.63e-114 | NTclustered | gi|2472106000|emb|OX457054.1| | 6398 | g15139 | i0 | 95.149 | 2.27007299270073 | 268 | 13 | 98 | 0 | 7 | 274 | 15933 | 15666 | Lumbricus terrestris genome assembly, organelle: mitochondrion | blastn | 622 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 5753506 | 5753506 | PRJNA680334_S_NODE_4985_length_386_cov_14.056657_g4501_i0 | PRJNA680334 | 4985 | 386 | 14.056657 | 54.25869602 | Lumbricus terrestris | 6398 | Annelida | Annelida | 451 | 3.11e-122 | NTclustered | gi|2472106000|emb|OX457054.1| | 6398 | g4501 | i0 | 95.423 | 42.4352331606218 | 284 | 12 | 100 | 1 | 104 | 386 | 8864 | 9147 | Lumbricus terrestris genome assembly, organelle: mitochondrion | blastn | 16380 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 7028090 | 7028090 | PRJNA680334_S_NODE_2446_length_479_cov_13.979821_g1971_i0 | PRJNA680334 | 2446 | 479 | 13.979821 | 66.96334259 | Lumbricus terrestris | 6398 | Annelida | Annelida | 726 | 0 | NTclustered | gi|5835191|ref|NC_001673.1| | 6398 | g1971 | i0 | 94.13 | 75.2066805845512 | 477 | 28 | 99 | 0 | 1 | 477 | 1450 | 974 | Lumbricus terrestris mitochondrion, complete genome | blastn | 36024 | 726 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 8303960 | 8303960 | PRJNA680334_S_NODE_967_length_674_cov_78.892356_g562_i0 | PRJNA680334 | 967 | 674 | 78.892356 | 531.73447944 | Lumbricus terrestris | 6398 | Annelida | Annelida | 1162 | 0 | NTclustered | gi|2472106000|emb|OX457054.1| | 6398 | g562 | i0 | 97.914 | 80.9554896142433 | 671 | 14 | 99 | 0 | 4 | 674 | 4125 | 3455 | Lumbricus terrestris genome assembly, organelle: mitochondrion | blastn | 54564 | 1162 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 8822260 | 8822260 | PRJNA680334_S_NODE_40647_length_204_cov_8.701754_g40161_i0 | PRJNA680334 | 40647 | 204 | 8.701754 | 17.75157816 | Lumbricus | 6397 | Annelida | Annelida | 359 | 9.36e-95 | NTclustered | gi|342220107|gb|HQ691218.1| | 6398 | g40161 | i0 | 98.529 | 131.730392156863 | 204 | 2 | 99 | 1 | 2 | 204 | 2223 | 2426 | Lumbricus terrestris 28S ribosomal RNA gene, partial sequence | blastn | 26873 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 12128425 | 12128425 | PRJNA680334_S_NODE_101150_length_153_cov_2.033333_g100664_i0 | PRJNA680334 | 101150 | 153 | 2.033333 | 3.11099949 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 100 | 4.41e-17 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g100664 | i0 | 91.781 | 0.477124183006536 | 73 | 5 | 47 | 1 | 82 | 153 | 18991789 | 18991717 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 73 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12128846 | 12128846 | PRJNA680334_S_NODE_2590_length_470_cov_21.096110_g2112_i0 | PRJNA680334 | 2590 | 470 | 21.09611 | 99.151717 | Lumbricus terrestris | 6398 | Annelida | Annelida | 708 | 0 | NTclustered | gi|2472106000|emb|OX457054.1| | 6398 | g2112 | i0 | 94.194 | 4.43191489361702 | 465 | 26 | 99 | 1 | 4 | 468 | 12353 | 12816 | Lumbricus terrestris genome assembly, organelle: mitochondrion | blastn | 2083 | 708 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 13403186 | 13403186 | PRJNA680334_S_NODE_103171_length_152_cov_2.159664_g102685_i0 | PRJNA680334 | 103171 | 152 | 2.159664 | 3.28268928 | root | 1 | Root_unresolved | Root_unresolved | 101 | 3.3299999999999998e-25 | NR | XP_009012174.1 | 6412 | g102685 | i0 | 94 | 25.6578947368421 | 50 | 3 | 98.7 | 0 | 1 | 150 | 109 | 158 | XP_009012174.1 hypothetical protein HELRODRAFT_92894, partial [Helobdella robusta] | diamond | 3900 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 13403698 | 13403698 | PRJNA680334_S_NODE_3651_length_423_cov_20.438462_g3170_i0 | PRJNA680334 | 3651 | 423 | 20.438462 | 86.45469426 | Lumbricus terrestris | 6398 | Annelida | Annelida | 656 | 0 | NTclustered | gi|2065693142|gb|MZ056784.1| | 6398 | g3170 | i0 | 96.931 | 20.2033096926714 | 391 | 12 | 92 | 0 | 2 | 392 | 521 | 911 | Lumbricus terrestris isolate HO 28 NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 8546 | 656 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 14678207 | 14678207 | PRJNA680334_S_NODE_106232_length_150_cov_7.145299_g105746_i0 | PRJNA680334 | 106232 | 150 | 7.145299 | 10.7179485 | Lumbricus terrestris | 6398 | Annelida | Annelida | 237 | 3.14e-58 | NTclustered | gi|83764112|emb|AJ966652.1| | 6398 | g105746 | i0 | 95.27 | 3.93333333333333 | 148 | 7 | 99 | 0 | 2 | 149 | 216 | 69 | Lumbricus terrestris mitochondrial partial nd4 gene for NADH dehydrogenase subunit 4, isolate 11096 | blastn | 590 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 14679427 | 14679427 | PRJNA680334_S_NODE_78392_length_166_cov_2.781955_g77906_i0 | PRJNA680334 | 78392 | 166 | 2.781955 | 4.6180453 | Lumbricus terrestris | 6398 | Annelida | Annelida | 302 | 1.2500000000000001e-77 | NTclustered | gi|377552935|gb|JN869707.1| | 6398 | g77906 | i0 | 99.398 | 98.433734939759 | 166 | 1 | 100 | 0 | 1 | 166 | 201 | 366 | Lumbricus terrestris voucher 1505 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 16340 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 14679715 | 14679715 | PRJNA680334_S_NODE_95872_length_155_cov_58.540984_g95386_i0 | PRJNA680334 | 95872 | 155 | 58.540984 | 90.7385252 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g95386 | i0 | 96.875 | 0.387096774193548 | 32 | 1 | 21 | 0 | 124 | 155 | 10099668 | 10099699 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 60 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17227805 | 17227805 | PRJNA680334_S_NODE_4214_length_406_cov_40.643432_g3732_i0 | PRJNA680334 | 4214 | 406 | 40.643432 | 165.01233392 | Lumbricus terrestris | 6398 | Annelida | Annelida | 652 | 0 | NTclustered | gi|5835191|ref|NC_001673.1| | 6398 | g3732 | i0 | 95.792 | 25.7389162561576 | 404 | 17 | 99 | 0 | 2 | 405 | 9644 | 10047 | Lumbricus terrestris mitochondrion, complete genome | blastn | 10450 | 652 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 18502905 | 18502905 | PRJNA680334_S_NODE_98795_length_154_cov_2.669421_g98309_i0 | PRJNA680334 | 98795 | 154 | 2.669421 | 4.11090834 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.013 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g98309 | i0 | 94.118 | 0.220779220779221 | 34 | 2 | 22 | 0 | 14 | 47 | 21102820 | 21102853 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 34 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19777336 | 19777336 | PRJNA680334_S_NODE_83696_length_162_cov_12.046512_g83210_i0 | PRJNA680334 | 83696 | 162 | 12.046512 | 19.51534944 | Lumbricus terrestris | 6398 | Annelida | Annelida | 289 | 9.44e-74 | NTclustered | gi|1770648232|gb|MK730632.1| | 6398 | g83210 | i0 | 98.758 | 100.364197530864 | 161 | 2 | 99 | 0 | 1 | 161 | 229 | 69 | Lumbricus terrestris voucher LT_B_II_1 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 16259 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 21052099 | 21052099 | PRJNA680334_S_NODE_3037_length_447_cov_191122.434783_g2557_i0 | PRJNA680334 | 3037 | 447 | 191122.434783 | 854317.28348001 | Lumbricus terrestris | 6398 | Annelida | Annelida | 497 | 4.62e-136 | NTclustered | gi|2472106000|emb|OX457054.1| | 6398 | g2557 | i0 | 91.69 | 13.4340044742729 | 361 | 27 | 81 | 2 | 86 | 446 | 12009 | 11652 | Lumbricus terrestris genome assembly, organelle: mitochondrion | blastn | 6005 | 497 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 22326738 | 22326738 | PRJNA680334_S_NODE_21318_length_249_cov_7.592593_g20832_i0 | PRJNA680334 | 21318 | 249 | 7.592593 | 18.90555657 | Aporrectodea rosea | 27389 | Annelida | Annelida | 279 | 9.5e-71 | NTclustered | gi|1829765830|ref|NC_046733.1| | 27389 | g20832 | i0 | 86.905 | 121.895582329317 | 252 | 30 | 100 | 2 | 1 | 249 | 3137 | 3388 | Aporrectodea rosea haplogroup L4 mitochondrion, complete genome | blastn | 30352 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea rosea | |
| 23602313 | 23602313 | PRJNA680334_S_NODE_23719_length_241_cov_5.980769_g23233_i0 | PRJNA680334 | 23719 | 241 | 5.980769 | 14.41365329 | Lumbricus terrestris | 6398 | Annelida | Annelida | 363 | 8.819999999999997e-96 | NTclustered | gi|5835191|ref|NC_001673.1| | 6398 | g23233 | i0 | 93.802 | 6.19087136929461 | 242 | 13 | 100 | 2 | 1 | 241 | 11474 | 11234 | Lumbricus terrestris mitochondrion, complete genome | blastn | 1492 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 24121175 | 24121175 | PRJNA680334_S_NODE_32279_length_219_cov_28.666667_g31793_i0 | PRJNA680334 | 32279 | 219 | 28.666667 | 62.78000073 | Clitellata | 42113 | Annelida | Annelida | 401 | 1.6699999999999995e-107 | NTclustered | gi|2703725018|gb|PP534975.1| | 35632 | g31793 | i0 | 100 | 99.0867579908676 | 217 | 0 | 99 | 0 | 3 | 219 | 101 | 317 | Lumbricus rubellus isolate E62 small subunit ribosomal RNA gene, partial sequence | blastn | 21700 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus rubellus | |
| 24875487 | 24875487 | PRJNA680334_S_NODE_19260_length_257_cov_6.830357_g18774_i0 | PRJNA680334 | 19260 | 257 | 6.830357 | 17.55401749 | Lumbricus terrestris | 6398 | Annelida | Annelida | 346 | 9.579999999999999e-91 | NTclustered | gi|83763848|emb|AJ966621.1| | 6398 | g18774 | i0 | 94.248 | 13.3929961089494 | 226 | 13 | 88 | 0 | 30 | 255 | 468 | 243 | Lumbricus terrestris mitochondrial partial ND2 gene NADH dehydrogenase subunit 2, haplotype LT5 | blastn | 3442 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 24876582 | 24876582 | PRJNA680334_S_NODE_82840_length_163_cov_2.969231_g82354_i0 | PRJNA680334 | 82840 | 163 | 2.969231 | 4.83984653 | Lumbricus rubellus | 35632 | Annelida | Annelida | 187 | 3.569999999999999e-43 | NTclustered | gi|377552782|gb|JN869595.1| | 35632 | g82354 | i0 | 90.21 | 47.159509202454 | 143 | 14 | 88 | 0 | 1 | 143 | 430 | 572 | Lumbricus rubellus voucher 1416 cytochrome c oxidase subunit II (COII) gene, partial cds; mitochondrial | blastn | 7687 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus rubellus |
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);;