contig_metadata
13 rows where bioproject = "PRJNA789095", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4598747 | 4598747 | PRJNA789095_P_NODE_36904_length_334_cov_1.762452_g35570_i0 | PRJNA789095 | 36904 | 334 | 1.762452 | 5.88658968 | Mesenchytraeus cf. pedatus SL-2017 | 2052678 | Annelida | Annelida | 106 | 2.38e-18 | NTclustered | gi|1275874787|gb|KU728824.2| | 2052678 | g35570 | i0 | 84.906 | 1.73952095808383 | 106 | 14 | 31 | 2 | 22 | 126 | 873 | 977 | Mesenchytraeus cf. pedatus SL-2017 glyceraldehyde-3-phosphate dehydrogenase mRNA, complete cds | blastn | 581 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Mesenchytraeus | Mesenchytraeus cf. pedatus SL-2017 | |
| 9699855 | 9699855 | PRJNA789095_P_NODE_72688_length_244_cov_0.900585_g71354_i0 | PRJNA789095 | 72688 | 244 | 0.900585 | 2.1974274 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|675865263|ref|XM_009019944.1| | 6412 | g71354 | i0 | 90.698 | 0.848360655737705 | 43 | 1 | 17 | 3 | 149 | 189 | 888 | 847 | Helobdella robusta hypothetical protein partial mRNA | blastn | 207 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 10974421 | 10974421 | PRJNA789095_P_NODE_34409_length_350_cov_6.545126_g33075_i0 | PRJNA789095 | 34409 | 350 | 6.545126 | 22.907941 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g33075 | i0 | 100 | 0.082857142857142893 | 29 | 0 | 8 | 0 | 58 | 86 | 28651412 | 28651384 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16073735 | 16073735 | PRJNA789095_P_NODE_59853_length_263_cov_20.000000_g58519_i0 | PRJNA789095 | 59853 | 263 | 20 | 52.6 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g58519 | i0 | 94.444 | 0.136882129277567 | 36 | 1 | 13 | 1 | 95 | 129 | 7826631 | 7826666 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17348902 | 17348902 | PRJNA789095_P_NODE_41694_length_310_cov_3.506329_g40360_i0 | PRJNA789095 | 41694 | 310 | 3.506329 | 10.8696199 | Hirudo verbana | 311461 | Annelida | Annelida | 67.6 | 1.03e-6 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g40360 | i0 | 85.075 | 0.861290322580645 | 67 | 8 | 21 | 2 | 245 | 310 | 4903751 | 4903816 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 267 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19897376 | 19897376 | PRJNA789095_P_NODE_38696_length_323_cov_1.908000_g37362_i0 | PRJNA789095 | 38696 | 323 | 1.908 | 6.16284 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.03 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g37362 | i0 | 100 | 0.086687306501548 | 28 | 0 | 9 | 0 | 209 | 236 | 4022576 | 4022549 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22448279 | 22448279 | PRJNA789095_P_NODE_5278_length_1603_cov_17.896078_g4640_i0 | PRJNA789095 | 5278 | 1603 | 17.896078 | 286.87413034 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.013 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g4640 | i0 | 100 | 0.129132875857767 | 30 | 0 | 2 | 0 | 678 | 707 | 4415831 | 4415860 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 207 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27568348 | 27568348 | PRJNA789095_P_NODE_24904_length_450_cov_1.119363_g23572_i0 | PRJNA789095 | 24904 | 450 | 1.119363 | 5.0371335 | Metazoa | 33208 | Annelida | Annelida | 191 | 2.27e-53 | NR | CAH1793612.1 | 6347 | g23572 | i0 | 71.2 | 96.3266666666667 | 132 | 35 | 88 | 1 | 448 | 53 | 176 | 304 | CAH1793612.1 unnamed protein product [Owenia fusiformis] | diamond | 43347 | 192 | 0.994791666666667 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28127703 | 28127703 | PRJNA789095_P_NODE_57665_length_268_cov_4.430769_g56331_i0 | PRJNA789095 | 57665 | 268 | 4.430769 | 11.87446092 | Capitella teleta | 283909 | Annelida | Annelida | 52.4 | 1.38e-5 | NR | ELU10826.1 | 283909 | g56331 | i0 | 39 | 0.66044776119403 | 59 | 36 | 66 | 0 | 179 | 3 | 86 | 144 | ELU10826.1 hypothetical protein CAPTEDRAFT_200270 [Capitella teleta] | diamond | 177 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28885264 | 28885264 | PRJNA789095_P_NODE_70148_length_246_cov_8.867052_g68814_i0 | PRJNA789095 | 70148 | 246 | 8.867052 | 21.81294792 | Helobdella robusta | 6412 | Annelida | Annelida | 41.6 | 0.0363 | NR | XP_009014082.1 | 6412 | g68814 | i0 | 45.8 | 0.585365853658537 | 48 | 26 | 58.5 | 0 | 246 | 103 | 13 | 60 | XP_009014082.1 hypothetical protein HELRODRAFT_169997 [Helobdella robusta] | diamond | 144 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29769347 | 29769347 | PRJNA789095_P_NODE_81151_length_209_cov_6.323529_g79817_i0 | PRJNA789095 | 81151 | 209 | 6.323529 | 13.21617561 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 85.9 | 1.5e-17 | NR | KAI0237845.1 | 104711 | g79817 | i0 | 65.2 | 0.990430622009569 | 69 | 24 | 99 | 0 | 209 | 3 | 31 | 99 | KAI0237845.1 Serine hydroxymethyltransferase, cytosolic [Lamellibrachia satsuma] | diamond | 207 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 30157479 | 30157479 | PRJNA789095_P_NODE_42452_length_310_cov_2.708861_g41118_i0 | PRJNA789095 | 42452 | 310 | 2.708861 | 8.3974691 | Metazoa | 33208 | Annelida | Annelida | 101 | 2.33e-22 | NR | XP_009018356.1 | 6412 | g41118 | i0 | 98 | 19.6548387096774 | 49 | 1 | 47.4 | 0 | 163 | 309 | 442 | 490 | XP_009018356.1 hypothetical protein HELRODRAFT_191960 [Helobdella robusta] | diamond | 6093 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30789613 | 30789613 | PRJNA789095_P_NODE_65254_length_252_cov_1.368715_g63920_i0 | PRJNA789095 | 65254 | 252 | 1.368715 | 3.4491618 | Opisthokonta | 33154 | Annelida | Annelida | 88.2 | 3.88e-18 | NR | CAH1795454.1 | 6347 | g63920 | i0 | 56.6 | 3.95238095238095 | 83 | 35 | 98.8 | 1 | 2 | 250 | 428 | 509 | CAH1795454.1 unnamed protein product [Owenia fusiformis] | diamond | 996 | 89 | 0.991011235955056 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;