contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157677 | 157677 | PRJNA1011844_P_NODE_75321_length_423_cov_4.702857_g66824_i0 | PRJNA1011844 | 75321 | 423 | 4.702857 | 19.89308511 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.011 | NTclustered | gi|675886919|ref|XM_009030714.1| | 6412 | g66824 | i0 | 100 | 0.0685579196217494 | 29 | 0 | 7 | 0 | 318 | 346 | 1850 | 1822 | Helobdella robusta hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 2706213 | 2706213 | PRJNA1011844_P_NODE_124103_length_277_cov_5.818627_g115526_i0 | PRJNA1011844 | 124103 | 277 | 5.818627 | 16.11759679 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5.48e-4 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g115526 | i0 | 100 | 2.67148014440433 | 31 | 0 | 11 | 0 | 234 | 264 | 17513061 | 17513031 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 740 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2706633 | 2706633 | PRJNA1011844_P_NODE_156043_length_244_cov_2.040936_g147463_i0 | PRJNA1011844 | 156043 | 244 | 2.040936 | 4.97988384 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.02e-5 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g147463 | i0 | 97.368 | 2.27868852459016 | 38 | 0 | 16 | 1 | 83 | 120 | 10901453 | 10901417 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 556 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2708300 | 2708300 | PRJNA1011844_P_NODE_99183_length_329_cov_4.484375_g90616_i0 | PRJNA1011844 | 99183 | 329 | 4.484375 | 14.75359375 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.85e-4 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g90616 | i0 | 100 | 5.1306990881459 | 32 | 0 | 10 | 0 | 272 | 303 | 3038159 | 3038190 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 1688 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3552782 | 3552782 | PRJNA1011844_P_NODE_59763_length_529_cov_2.050439_g51376_i0 | PRJNA1011844 | 59763 | 529 | 2.050439 | 10.84682231 | Metazoa | 33208 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|675858547|ref|XM_009016586.1| | 6412 | g51376 | i0 | 97.059 | 1.11909262759924 | 34 | 1 | 6 | 0 | 419 | 452 | 596 | 629 | Helobdella robusta hypothetical protein partial mRNA | blastn | 592 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 5260084 | 5260084 | PRJNA1011844_P_NODE_45925_length_675_cov_4.632890_g37813_i0 | PRJNA1011844 | 45925 | 675 | 4.63289 | 31.2720075 | Polygordius eschaturus | 2137588 | Annelida | Annelida | 54.7 | 0.019 | NTclustered | gi|1443018429|gb|MG603564.1| | 2137588 | g37813 | i0 | 94.444 | 0.0533333333333333 | 36 | 1 | 5 | 1 | 121 | 155 | 414 | 379 | Polygordius eschaturus isolate BZ_BC6 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Polygordiidae | Polygordius | Polygordius eschaturus | ||
| 7379739 | 7379739 | PRJNA1011844_P_NODE_25846_length_1067_cov_6.505030_g19765_i0 | PRJNA1011844 | 25846 | 1067 | 6.50503 | 69.4086701 | Clitellata | 42113 | Annelida | Annelida | 56.5 | 0.008 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g19765 | i0 | 100 | 0.19962511715089 | 30 | 0 | 3 | 0 | 322 | 351 | 15698785 | 15698814 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 213 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7808758 | 7808758 | PRJNA1011844_P_NODE_146227_length_251_cov_0.865169_g137648_i0 | PRJNA1011844 | 146227 | 251 | 0.865169 | 2.17157419 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g137648 | i0 | 94.444 | 0.705179282868526 | 36 | 2 | 14 | 0 | 43 | 78 | 8177627 | 8177662 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 177 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9085483 | 9085483 | PRJNA1011844_P_NODE_93848_length_346_cov_1.743590_g85287_i0 | PRJNA1011844 | 93848 | 346 | 1.74359 | 6.0328213999999996 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.033 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g85287 | i0 | 100 | 0.0809248554913295 | 28 | 0 | 8 | 0 | 6 | 33 | 11648340 | 11648367 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9085555 | 9085555 | PRJNA1011844_P_NODE_99888_length_327_cov_3.854331_g91319_i0 | PRJNA1011844 | 99888 | 327 | 3.854331 | 12.60366237 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g91319 | i0 | 100 | 0.26605504587156 | 30 | 0 | 9 | 0 | 30 | 59 | 917558 | 917529 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 87 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10361099 | 10361099 | PRJNA1011844_P_NODE_91009_length_355_cov_7.375887_g82451_i0 | PRJNA1011844 | 91009 | 355 | 7.375887 | 26.18439885 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.034 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g82451 | i0 | 100 | 0.0788732394366197 | 28 | 0 | 8 | 0 | 29 | 56 | 18560480 | 18560453 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12909499 | 12909499 | PRJNA1011844_P_NODE_118931_length_285_cov_2.099057_g110354_i0 | PRJNA1011844 | 118931 | 285 | 2.099057 | 5.98231245 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.57e-4 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g110354 | i0 | 100 | 0.428070175438596 | 32 | 0 | 11 | 0 | 244 | 275 | 8620402 | 8620371 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 122 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12911179 | 12911179 | PRJNA1011844_P_NODE_69291_length_458_cov_3.664935_g60825_i0 | PRJNA1011844 | 69291 | 458 | 3.664935 | 16.7854023 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.044 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g60825 | i0 | 100 | 0.0611353711790393 | 28 | 0 | 6 | 0 | 183 | 210 | 17907676 | 17907703 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13755725 | 13755725 | PRJNA1011844_P_NODE_79291_length_403_cov_3.700000_g70775_i0 | PRJNA1011844 | 79291 | 403 | 3.7 | 14.911 | Metazoa | 33208 | Annelida | Annelida | 62.1 | 6.42e-5 | NTclustered | gi|675871487|ref|XM_009023056.1| | 6412 | g70775 | i0 | 95 | 0.342431761786601 | 40 | 0 | 10 | 2 | 233 | 271 | 1428 | 1466 | Helobdella robusta hypothetical protein partial mRNA | blastn | 138 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 14184282 | 14184282 | PRJNA1011844_P_NODE_104432_length_315_cov_1.276860_g95860_i0 | PRJNA1011844 | 104432 | 315 | 1.27686 | 4.022109 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g95860 | i0 | 100 | 1.06031746031746 | 30 | 0 | 10 | 0 | 159 | 188 | 21007767 | 21007738 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 334 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14184433 | 14184433 | PRJNA1011844_P_NODE_115652_length_290_cov_2.700461_g107076_i0 | PRJNA1011844 | 115652 | 290 | 2.7004609999999998 | 7.8313369 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g107076 | i0 | 100 | 0.103448275862069 | 30 | 0 | 10 | 0 | 21 | 50 | 346033 | 346062 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19281723 | 19281723 | PRJNA1011844_P_NODE_143316_length_253_cov_4.611111_g134738_i0 | PRJNA1011844 | 143316 | 253 | 4.611111 | 11.66611083 | Hirudo verbana | 311461 | Annelida | Annelida | 78.7 | 3.79e-10 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g134738 | i0 | 78.862 | 0.486166007905138 | 123 | 20 | 47 | 4 | 46 | 163 | 11097534 | 11097413 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 123 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19283159 | 19283159 | PRJNA1011844_P_NODE_65616_length_483_cov_2.958537_g57190_i0 | PRJNA1011844 | 65616 | 483 | 2.958537 | 14.28973371 | Hirudo verbana | 311461 | Annelida | Annelida | 67.6 | 1.68e-6 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g57190 | i0 | 91.667 | 5.66252587991718 | 48 | 4 | 10 | 0 | 54 | 101 | 5854876 | 5854829 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 2735 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21833161 | 21833161 | PRJNA1011844_P_NODE_157338_length_243_cov_3.911765_g148758_i0 | PRJNA1011844 | 157338 | 243 | 3.911765 | 9.50558895 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.71e-4 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g148758 | i0 | 100 | 0.522633744855967 | 31 | 0 | 13 | 0 | 151 | 181 | 8325994 | 8325964 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 127 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23109724 | 23109724 | PRJNA1011844_P_NODE_57059_length_553_cov_4.102083_g48697_i0 | PRJNA1011844 | 57059 | 553 | 4.102083 | 22.68451899 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.015 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g48697 | i0 | 94.286 | 0.0632911392405063 | 35 | 2 | 6 | 0 | 463 | 497 | 1151329 | 1151295 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 25228146 | 25228146 | PRJNA1011844_P_NODE_146140_length_251_cov_0.865169_g137561_i0 | PRJNA1011844 | 146140 | 251 | 0.865169 | 2.17157419 | Clitellata | 42113 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g137561 | i0 | 96.875 | 0.466135458167331 | 32 | 1 | 13 | 0 | 205 | 236 | 283215 | 283246 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 117 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana |
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);;