contig_metadata
15 rows where bioproject = "PRJEB36940", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5159185 | 5159185 | PRJEB36940_P_NODE_6825_length_330_cov_1.571984_g6696_i0 | PRJEB36940 | 6825 | 330 | 1.571984 | 5.1875472 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g6696 | i0 | 94.444 | 0.193939393939394 | 36 | 1 | 11 | 1 | 267 | 301 | 520155 | 520190 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6434994 | 6434994 | PRJEB36940_P_NODE_3366_length_463_cov_0.928205_g3238_i0 | PRJEB36940 | 3366 | 463 | 0.928205 | 4.29758915 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.045 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g3238 | i0 | 100 | 0.060475161987041 | 28 | 0 | 6 | 0 | 336 | 363 | 19232502 | 19232529 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17566817 | 17566817 | PRJEB36940_P_NODE_15934_length_242_cov_0.917160_g15805_i0 | PRJEB36940 | 15934 | 242 | 0.91716 | 2.2195272 | Metazoa | 33208 | Annelida | Annelida | 128 | 3.2999999999999997e-32 | NR | CAH1776242.1 | 6347 | g15805 | i0 | 68.8 | 51.198347107438 | 80 | 25 | 99.2 | 0 | 241 | 2 | 346 | 425 | CAH1776242.1 unnamed protein product [Owenia fusiformis] | diamond | 12390 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 20457710 | 20457710 | PRJEB36940_P_NODE_9997_length_277_cov_1.147059_g9868_i0 | PRJEB36940 | 9997 | 277 | 1.147059 | 3.17735343 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g9868 | i0 | 100 | 0.101083032490975 | 28 | 0 | 10 | 0 | 247 | 274 | 5534842 | 5534869 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21733444 | 21733444 | PRJEB36940_P_NODE_10858_length_267_cov_1.463918_g10729_i0 | PRJEB36940 | 10858 | 267 | 1.463918 | 3.90866106 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g10729 | i0 | 96.875 | 2.85393258426966 | 32 | 1 | 12 | 0 | 58 | 89 | 11854499 | 11854468 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 762 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 27159463 | 27159463 | PRJEB36940_P_NODE_5242_length_373_cov_1.550000_g5113_i0 | PRJEB36940 | 5242 | 373 | 1.55 | 5.7815 | Capitella teleta | 283909 | Annelida | Annelida | 117 | 2.6999999999999997e-31 | NR | ELU09549.1 | 283909 | g5113 | i0 | 55.6 | 0.723860589812332 | 90 | 40 | 72.4 | 0 | 273 | 4 | 12 | 101 | ELU09549.1 hypothetical protein CAPTEDRAFT_136883 [Capitella teleta] | diamond | 270 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27184645 | 27184645 | PRJEB36940_P_NODE_7162_length_323_cov_1.188000_g7033_i0 | PRJEB36940 | 7162 | 323 | 1.188 | 3.83724 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 2.38e-30 | NR | KAK2188786.1 | 27915 | g7033 | i0 | 64.4 | 9.29721362229102 | 87 | 31 | 80.8 | 0 | 62 | 322 | 3 | 89 | KAK2188786.1 hypothetical protein NP493_121g01009 [Ridgeia piscesae] | diamond | 3003 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 27437860 | 27437860 | PRJEB36940_P_NODE_6163_length_346_cov_1.710623_g6034_i0 | PRJEB36940 | 6163 | 346 | 1.710623 | 5.91875558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47 | 0.0037 | NR | XP_009008985.1 | 6412 | g6034 | i0 | 57.1 | 0.667630057803468 | 35 | 15 | 30.3 | 0 | 6 | 110 | 43 | 77 | XP_009008985.1 hypothetical protein HELRODRAFT_187817 [Helobdella robusta] | diamond | 231 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28037604 | 28037604 | PRJEB36940_P_NODE_5685_length_359_cov_2.202797_g5556_i0 | PRJEB36940 | 5685 | 359 | 2.202797 | 7.90804123 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 1.13e-29 | NR | CAH1782025.1 | 6347 | g5556 | i0 | 53.5 | 18.4763231197772 | 101 | 47 | 84.4 | 0 | 56 | 358 | 42 | 142 | CAH1782025.1 unnamed protein product [Owenia fusiformis] | diamond | 6633 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28289944 | 28289944 | PRJEB36940_P_NODE_9786_length_279_cov_1.742718_g9657_i0 | PRJEB36940 | 9786 | 279 | 1.742718 | 4.86218322 | Opisthokonta | 33154 | Annelida | Annelida | 99.8 | 8.209999999999999e-23 | NR | P38981.1 | 6431 | g9657 | i0 | 55.4 | 3.46236559139785 | 92 | 35 | 92.5 | 1 | 1 | 258 | 157 | 248 | P38981.1 RecName: Full=Small ribosomal subunit protein uS2; AltName: Full=40S ribosomal protein SA; AltName: Full=Laminin-binding protein p40; Short=LBP/p40 [Urechis caupo] | diamond | 966 | 100 | 0.998 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Xenopneusta | Urechidae | Urechis | Urechis caupo | |
| 30406296 | 30406296 | PRJEB36940_P_NODE_11773_length_257_cov_1.630435_g11644_i0 | PRJEB36940 | 11773 | 257 | 1.630435 | 4.19021795 | Metazoa | 33208 | Annelida | Annelida | 85.1 | 4.27e-17 | NR | AIZ77505.1 | 6359 | g11644 | i0 | 52.5 | 4.77431906614786 | 80 | 38 | 93.4 | 0 | 257 | 18 | 216 | 295 | AIZ77505.1 legumain-protease-precursor [Platynereis dumerilii] | diamond | 1227 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 30665238 | 30665238 | PRJEB36940_P_NODE_8233_length_302_cov_1.200873_g8104_i0 | PRJEB36940 | 8233 | 302 | 1.200873 | 3.62663646 | Owenia fusiformis | 6347 | Annelida | Annelida | 57.8 | 3.75e-7 | NR | CAH1797497.1 | 6347 | g8104 | i0 | 34.4 | 2.68211920529801 | 90 | 59 | 89.4 | 0 | 6 | 275 | 88 | 177 | CAH1797497.1 unnamed protein product [Owenia fusiformis] | diamond | 810 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30760100 | 30760100 | PRJEB36940_P_NODE_14494_length_246_cov_0.895954_g14365_i0 | PRJEB36940 | 14494 | 246 | 0.895954 | 2.20404684 | Helobdella robusta | 6412 | Annelida | Annelida | 59.7 | 3.49e-8 | NR | XP_009008917.1 | 6412 | g14365 | i0 | 44.3 | 24.9268292682927 | 61 | 32 | 74.4 | 1 | 54 | 236 | 10 | 68 | XP_009008917.1 hypothetical protein HELRODRAFT_62924, partial [Helobdella robusta] | diamond | 6132 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32404562 | 32404562 | PRJEB36940_P_NODE_7159_length_323_cov_1.220000_g7030_i0 | PRJEB36940 | 7159 | 323 | 1.22 | 3.9406 | Owenia fusiformis | 6347 | Annelida | Annelida | 55.5 | 3.35e-6 | NR | CAH1777895.1 | 6347 | g7030 | i0 | 35 | 0.956656346749226 | 103 | 63 | 93.8 | 2 | 307 | 5 | 221 | 321 | CAH1777895.1 unnamed protein product [Owenia fusiformis] | diamond | 309 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32625560 | 32625560 | PRJEB36940_P_NODE_5440_length_367_cov_1.448980_g5311_i0 | PRJEB36940 | 5440 | 367 | 1.44898 | 5.3177566 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 92 | 4.1e-20 | NR | CAD5118535.1 | 2664684 | g5311 | i0 | 49.4 | 4.91280653950954 | 89 | 45 | 72.8 | 0 | 101 | 367 | 16 | 104 | CAD5118535.1 DgyrCDS7226 [Dimorphilus gyrociliatus] | diamond | 1803 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus |
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);;