contig_metadata
12 rows where bioproject = "PRJNA438572" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6812960 | 6812960 | PRJNA438572_P_NODE_7226_length_376_cov_0.986799_g7107_i0 | PRJNA438572 | 7226 | 376 | 0.986799 | 3.71036424 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 189 | 5.61e-57 | NR | XP_009028567.1 | 6412 | g7107 | i0 | 76 | 24.8218085106383 | 125 | 30 | 99.7 | 0 | 2 | 376 | 71 | 195 | XP_009028567.1 hypothetical protein HELRODRAFT_186113, partial [Helobdella robusta] | diamond | 9333 | 190 | 0.994736842105263 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 18286482 | 18286482 | PRJNA438572_P_NODE_10135_length_322_cov_1.409639_g10016_i0 | PRJNA438572 | 10135 | 322 | 1.409639 | 4.53903758 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 156 | 2.24e-33 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g10016 | i0 | 79.399 | 0.72360248447205 | 233 | 39 | 70 | 5 | 5 | 229 | 6746266 | 6746035 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 233 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18286783 | 18286783 | PRJNA438572_P_NODE_4655_length_457_cov_3.908854_g4536_i0 | PRJNA438572 | 4655 | 457 | 3.908854 | 17.86346278 | Arenicola marina | 6344 | Annelida | Annelida | 291 | 8.63e-74 | NTclustered | gi|158187723|gb|EU124946.1| | 6344 | g4536 | i0 | 82.727 | 72.328227571116 | 330 | 53 | 72 | 4 | 3 | 330 | 446 | 119 | Arenicola marina ribosomal protein rps23 mRNA, complete cds | blastn | 33054 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 22111825 | 22111825 | PRJNA438572_P_NODE_7758_length_364_cov_2.037801_g7639_i0 | PRJNA438572 | 7758 | 364 | 2.037801 | 7.41759564 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.035 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g7639 | i0 | 100 | 0.0769230769230769 | 28 | 0 | 8 | 0 | 306 | 333 | 6771104 | 6771077 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24661314 | 24661314 | PRJNA438572_P_NODE_23280_length_243_cov_1.747059_g23161_i0 | PRJNA438572 | 23280 | 243 | 1.747059 | 4.24535337 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g23161 | i0 | 97.059 | 0.139917695473251 | 34 | 0 | 14 | 1 | 197 | 229 | 20938972 | 20938939 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27771165 | 27771165 | PRJNA438572_P_NODE_17724_length_252_cov_0.871508_g17605_i0 | PRJNA438572 | 17724 | 252 | 0.871508 | 2.19620016 | Helobdella robusta | 6412 | Annelida | Annelida | 41.6 | 0.0252 | NR | XP_009016464.1 | 6412 | g17605 | i0 | 50 | 0.595238095238095 | 50 | 21 | 56 | 2 | 70 | 210 | 36 | 84 | XP_009016464.1 hypothetical protein HELRODRAFT_92454, partial [Helobdella robusta] | diamond | 150 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28592004 | 28592004 | PRJNA438572_P_NODE_20107_length_248_cov_0.891429_g19988_i0 | PRJNA438572 | 20107 | 248 | 0.891429 | 2.21074392 | Owenia fusiformis | 6347 | Annelida | Annelida | 55.8 | 7.82e-7 | NR | CAH1780818.1 | 6347 | g19988 | i0 | 35 | 0.967741935483871 | 80 | 43 | 96.8 | 1 | 247 | 8 | 24 | 94 | CAH1780818.1 unnamed protein product [Owenia fusiformis] | diamond | 240 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29302788 | 29302788 | PRJNA438572_P_NODE_18169_length_251_cov_0.876404_g18050_i0 | PRJNA438572 | 18169 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 77.4 | 2.47e-14 | NR | CAH1773466.1 | 6347 | g18050 | i0 | 64.7 | 9.28685258964143 | 51 | 18 | 61 | 0 | 197 | 45 | 210 | 260 | CAH1773466.1 unnamed protein product [Owenia fusiformis] | diamond | 2331 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29586640 | 29586640 | PRJNA438572_P_NODE_2930_length_573_cov_1.144000_g2813_i0 | PRJNA438572 | 2930 | 573 | 1.144 | 6.55512 | Metazoa | 33208 | Annelida | Annelida | 228 | 1.95e-67 | NR | CAH1789021.1 | 6347 | g2813 | i0 | 57.6 | 1.99476439790576 | 191 | 79 | 99.5 | 2 | 571 | 2 | 458 | 647 | CAH1789021.1 unnamed protein product [Owenia fusiformis] | diamond | 1143 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30897640 | 30897640 | PRJNA438572_P_NODE_18474_length_251_cov_0.876404_g18355_i0 | PRJNA438572 | 18474 | 251 | 0.876404 | 2.19977404 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 106 | 1.29e-24 | NR | KAK2154102.1 | 53620 | g18355 | i0 | 53.6 | 3.07171314741036 | 84 | 37 | 98 | 1 | 2 | 247 | 200 | 283 | KAK2154102.1 hypothetical protein LSH36_276g00012 [Paralvinella palmiformis] | diamond | 771 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32510783 | 32510783 | PRJNA438572_P_NODE_22979_length_244_cov_0.912281_g22860_i0 | PRJNA438572 | 22979 | 244 | 0.912281 | 2.22596564 | Capitella teleta | 283909 | Annelida | Annelida | 47.4 | 8.81e-4 | NR | ELT93314.1 | 283909 | g22860 | i0 | 43.8 | 0.590163934426229 | 48 | 24 | 57.8 | 2 | 1 | 141 | 421 | 466 | ELT93314.1 hypothetical protein CAPTEDRAFT_225336 [Capitella teleta] | diamond | 144 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32605242 | 32605242 | PRJNA438572_P_NODE_19880_length_249_cov_0.886364_g19761_i0 | PRJNA438572 | 19880 | 249 | 0.886364 | 2.20704636 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 59.7 | 4.08e-8 | NR | KAK2161159.1 | 53620 | g19761 | i0 | 53.5 | 1.02409638554217 | 43 | 19 | 51.8 | 1 | 120 | 248 | 203 | 244 | KAK2161159.1 hypothetical protein LSH36_120g02000 [Paralvinella palmiformis] | diamond | 255 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis |
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);;