contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA631796" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4431074 | 4431074 | PRJNA631796_P_NODE_11524_length_207_cov_0.876712_g11246_i0 | PRJNA631796 | 11524 | 207 | 0.876712 | 1.81479384 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.12e-29 | NR | KAJ1440792.1 | 483371 | g11246 | i0 | 81.2 | 1 | 69 | 13 | 100 | 0 | 207 | 1 | 85 | 153 | KAJ1440792.1 ribosomal protein L22/L17 [Ochromonadaceae sp. CCMP2298] | diamond | 207 | 113 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 12082804 | 12082804 | PRJNA631796_P_NODE_12350_length_204_cov_0.895105_g12072_i0 | PRJNA631796 | 12350 | 204 | 0.895105 | 1.8260142 | Vitrella brassicaformis CCMP3155 | 1169540 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 3.26e-26 | NR | CEM28386.1 | 1169540 | g12072 | i0 | 79.4 | 1 | 68 | 14 | 100 | 0 | 204 | 1 | 435 | 502 | CEM28386.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 204 | 110 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 27251489 | 27251489 | PRJNA631796_P_NODE_12003_length_205_cov_0.944444_g11725_i0 | PRJNA631796 | 12003 | 205 | 0.944444 | 1.9361102 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 6.72e-23 | NR | CAI5722356.1 | 86335 | g11725 | i0 | 57.6 | 5.38536585365854 | 92 | 11 | 93.7 | 1 | 12 | 203 | 265 | 356 | CAI5722356.1 unnamed protein product [Peronospora destructor] | diamond | 1104 | 101 | 0.99009900990099 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora destructor | ||
| 27333952 | 27333952 | PRJNA631796_P_NODE_11783_length_206_cov_0.882759_g11505_i0 | PRJNA631796 | 11783 | 206 | 0.882759 | 1.81848354 | Pelagomonas calceolata | 35677 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 5.04e-32 | NR | CAH0369848.1 | 35677 | g11505 | i0 | 80.9 | 0.990291262135922 | 68 | 13 | 99 | 0 | 1 | 204 | 190 | 257 | CAH0369848.1 unnamed protein product [Pelagomonas calceolata] | diamond | 204 | 122 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Pelagomonas | Pelagomonas calceolata | |||
| 28533819 | 28533819 | PRJNA631796_P_NODE_8427_length_235_cov_0.936782_g8149_i0 | PRJNA631796 | 8427 | 235 | 0.936782 | 2.2014377 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00366 | NR | XP_012652362.1 | 312017 | g8149 | i0 | 48.9 | 1.14893617021277 | 45 | 23 | 57.4 | 0 | 26 | 160 | 24 | 68 | XP_012652362.1 hypothetical protein TTHERM_000294739 [Tetrahymena thermophila SB210] | diamond | 270 | 43.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30902441 | 30902441 | PRJNA631796_P_NODE_12194_length_204_cov_3.041958_g11916_i0 | PRJNA631796 | 12194 | 204 | 3.041958 | 6.20559432 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 3.96e-10 | NR | KRX05960.1 | 266149 | g11916 | i0 | 60.8 | 0.75 | 51 | 20 | 75 | 0 | 178 | 26 | 408 | 458 | KRX05960.1 hypothetical protein PPERSA_01038 [Pseudocohnilembus persalinus] | diamond | 153 | 64.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32357472 | 32357472 | PRJNA631796_S_NODE_24479_length_259_cov_1.292929_g24312_i0 | PRJNA631796 | 24479 | 259 | 1.292929 | 3.34868611 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 8.68e-16 | NR | YP_008475337.1 | 1202772 | g24312 | i0 | 75.5 | 0.567567567567568 | 49 | 12 | 56.8 | 0 | 113 | 259 | 1 | 49 | YP_008475337.1 ATP synthase F0 subunit 9 [Achlya hypogyna] | diamond | 147 | 75.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 32420549 | 32420549 | PRJNA631796_P_NODE_13179_length_201_cov_0.914286_g12901_i0 | PRJNA631796 | 13179 | 201 | 0.914286 | 1.83771486 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.06e-35 | NR | CAE7564791.1 | 2951 | g12901 | i0 | 82.1 | 2 | 67 | 12 | 100 | 0 | 201 | 1 | 197 | 263 | CAE7564791.1 unnamed protein product [Symbiodinium microadriaticum] | diamond | 402 | 132 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum |
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);;