contig_metadata
6 rows where bioproject = "PRJNA255848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27281529 | 27281529 | PRJNA255848_P_NODE_24683_length_201_cov_0.888158_g24365_i0 | PRJNA255848 | 24683 | 201 | 0.888158 | 1.78519758 | Metazoa | 33208 | Annelida | Annelida | 128 | 1.09e-34 | NR | CAH1778036.1 | 6347 | g24365 | i0 | 96.8 | 128.791044776119 | 63 | 2 | 94 | 0 | 13 | 201 | 106 | 168 | CAH1778036.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 25887 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27502718 | 27502718 | PRJNA255848_P_NODE_27143_length_191_cov_1.267606_g26825_i0 | PRJNA255848 | 27143 | 191 | 1.267606 | 2.42112746 | root | 1 | Root_unresolved | Root_unresolved | 135 | 6.69e-39 | NR | ABB29582.1 | 6359 | g26825 | i0 | 98.4 | 258.267015706806 | 63 | 1 | 99 | 0 | 2 | 190 | 30 | 92 | ABB29582.1 cell division control protein 42, partial [Platynereis dumerilii] | diamond | 49329 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 27534141 | 27534141 | PRJNA255848_P_NODE_32423_length_174_cov_1.632000_g32105_i0 | PRJNA255848 | 32423 | 174 | 1.632 | 2.83968 | Metazoa | 33208 | Annelida | Annelida | 113 | 2.99e-29 | NR | XP_009024801.1 | 6412 | g32105 | i0 | 100 | 201.465517241379 | 57 | 0 | 98.3 | 0 | 173 | 3 | 170 | 226 | XP_009024801.1 hypothetical protein HELRODRAFT_155141 [Helobdella robusta] | diamond | 35055 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32020025 | 32020025 | PRJNA255848_P_NODE_42498_length_163_cov_2.236842_g42180_i0 | PRJNA255848 | 42498 | 163 | 2.236842 | 3.64605246 | root | 1 | Root_unresolved | Root_unresolved | 67.4 | 2.39e-12 | NR | CAH1776354.1 | 6347 | g42180 | i0 | 100 | 114.625766871166 | 36 | 0 | 66.3 | 0 | 3 | 110 | 119 | 154 | CAH1776354.1 unnamed protein product [Owenia fusiformis] | diamond | 18684 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32241790 | 32241790 | PRJNA255848_P_NODE_21958_length_213_cov_0.932927_g21640_i0 | PRJNA255848 | 21958 | 213 | 0.932927 | 1.98713451 | Metazoa | 33208 | Annelida | Annelida | 147 | 6.87e-41 | NR | XP_009015254.1 | 6412 | g21640 | i0 | 97.1 | 878.450704225352 | 70 | 2 | 98.6 | 0 | 212 | 3 | 196 | 265 | XP_009015254.1 hypothetical protein HELRODRAFT_186366 [Helobdella robusta] | diamond | 187110 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32368301 | 32368301 | PRJNA255848_P_NODE_30779_length_179_cov_1.461538_g30461_i0 | PRJNA255848 | 30779 | 179 | 1.461538 | 2.61615302 | Metazoa | 33208 | Annelida | Annelida | 114 | 9.979999999999999e-30 | NR | CAH1780222.1 | 6347 | g30461 | i0 | 100 | 137.966480446927 | 56 | 0 | 93.9 | 0 | 168 | 1 | 90 | 145 | CAH1780222.1 unnamed protein product [Owenia fusiformis] | diamond | 24696 | 114 | 1 | 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);;