contig_metadata
9 rows where bioproject = "PRJNA285816", tax_clade = "Sar" and tax_phylum = "Foraminifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19498094 | 19498094 | PRJNA285816_S_NODE_9476_length_235_cov_2.236559_g9374_i0 | PRJNA285816 | 9476 | 235 | 2.236559 | 5.25591365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 5.17e-25 | NR | ETO07522.1 | 46433 | g9374 | i0 | 61.5 | 4.96595744680851 | 78 | 30 | 99.6 | 0 | 1 | 234 | 243 | 320 | ETO07522.1 aminotransferase, classes I and II family protein [Reticulomyxa filosa] | diamond | 1167 | 107 | 0.990654205607477 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28986836 | 28986836 | PRJNA285816_S_NODE_29148_length_162_cov_1.380531_g29046_i0 | PRJNA285816 | 29148 | 162 | 1.380531 | 2.23646022 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 1.27e-5 | NR | ETO08983.1 | 46433 | g29046 | i0 | 47.8 | 1.7037037037037 | 46 | 24 | 85.2 | 0 | 4 | 141 | 245 | 290 | ETO08983.1 NADH-ubiquinone oxidoreductase subunit, mitochondrial precursor, partial [Reticulomyxa filosa] | diamond | 276 | 51.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29252814 | 29252814 | PRJNA285816_S_NODE_11049_length_223_cov_0.896552_g10947_i0 | PRJNA285816 | 11049 | 223 | 0.896552 | 1.99931096 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 5.34e-11 | NR | ETO00580.1 | 46433 | g10947 | i0 | 46.2 | 1.04932735426009 | 78 | 35 | 98.2 | 2 | 4 | 222 | 128 | 203 | ETO00580.1 hypothetical protein RFI_36860 [Reticulomyxa filosa] | diamond | 234 | 66.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29284447 | 29284447 | PRJNA285816_S_NODE_11549_length_219_cov_1.217647_g11447_i0 | PRJNA285816 | 11549 | 219 | 1.217647 | 2.66664693 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 4.52e-12 | NR | ETO22086.1 | 46433 | g11447 | i0 | 47.9 | 1.94520547945205 | 71 | 36 | 97.3 | 1 | 217 | 5 | 815 | 884 | ETO22086.1 protein serine/threonine phosphatase, partial [Reticulomyxa filosa] | diamond | 426 | 70.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29428345 | 29428345 | PRJNA285816_S_NODE_12209_length_215_cov_1.048193_g12107_i0 | PRJNA285816 | 12209 | 215 | 1.048193 | 2.25361495 | root | 1 | Root_unresolved | Root_unresolved | 109 | 7.61e-26 | NR | ETO16168.1 | 46433 | g12107 | i0 | 76.1 | 9.72558139534884 | 67 | 16 | 93.5 | 0 | 209 | 9 | 339 | 405 | ETO16168.1 hypothetical protein RFI_21190, partial [Reticulomyxa filosa] | diamond | 2091 | 109 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30516448 | 30516448 | PRJNA285816_S_NODE_19833_length_181_cov_1.181818_g19731_i0 | PRJNA285816 | 19833 | 181 | 1.181818 | 2.13909058 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.91e-12 | NR | ETO12503.1 | 46433 | g19731 | i0 | 62.1 | 0.961325966850829 | 58 | 21 | 96.1 | 1 | 176 | 3 | 893 | 949 | ETO12503.1 hypothetical protein RFI_24873, partial [Reticulomyxa filosa] | diamond | 174 | 70.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30913423 | 30913423 | PRJNA285816_S_NODE_23134_length_171_cov_1.278689_g23032_i0 | PRJNA285816 | 23134 | 171 | 1.278689 | 2.18655819 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 9.81e-8 | NR | ETO19462.1 | 46433 | g23032 | i0 | 50 | 4.7719298245614 | 54 | 26 | 94.7 | 1 | 162 | 1 | 259 | 311 | ETO19462.1 hypothetical protein RFI_17769 [Reticulomyxa filosa] | diamond | 816 | 57.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31844041 | 31844041 | PRJNA285816_S_NODE_20937_length_177_cov_1.828125_g20835_i0 | PRJNA285816 | 20937 | 177 | 1.828125 | 3.23578125 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 1.71e-30 | NR | ETO19396.1 | 46433 | g20835 | i0 | 84.7 | 3.98305084745763 | 59 | 9 | 100 | 0 | 1 | 177 | 149 | 207 | ETO19396.1 acetyl-coenzyme a synthetase, partial [Reticulomyxa filosa] | diamond | 705 | 116 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32715413 | 32715413 | PRJNA285816_S_NODE_8960_length_241_cov_0.979167_g8858_i0 | PRJNA285816 | 8960 | 241 | 0.979167 | 2.35979247 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 2.54e-25 | NR | ETO05095.1 | 46433 | g8858 | i0 | 69.6 | 22.5311203319502 | 79 | 24 | 98.3 | 0 | 1 | 237 | 222 | 300 | ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] | diamond | 5430 | 109 | 0.990825688073395 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa |
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);;