contig_metadata
12 rows where bioproject = "PRJNA532380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1779476 | 1779476 | PRJNA532380_P_NODE_3502_length_556_cov_2.118343_g3184_i0 | PRJNA532380 | 3502 | 556 | 2.118343 | 11.77798708 | Gregarina cloptoni | 650276 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 6.93e-16 | NTclustered | gi|241739988|gb|FJ459742.1| | 650276 | g3184 | i0 | 95.161 | 11.660071942446 | 62 | 3 | 11 | 0 | 27 | 88 | 956 | 895 | Gregarina cloptoni small subunit ribosomal RNA gene, partial sequence | blastn | 6483 | 99 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina cloptoni | ||
| 27077600 | 27077600 | PRJNA532380_P_NODE_33142_length_162_cov_0.920354_g32817_i0 | PRJNA532380 | 33142 | 162 | 0.920354 | 1.49097348 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00105 | NR | XP_001017129.3 | 312017 | g32817 | i0 | 70.3 | 0.685185185185185 | 37 | 11 | 68.5 | 0 | 162 | 52 | 119 | 155 | XP_001017129.3 EF hand protein [Tetrahymena thermophila SB210] | diamond | 111 | 45.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28324285 | 28324285 | PRJNA532380_P_NODE_28266_length_168_cov_0.873950_g27941_i0 | PRJNA532380 | 28266 | 168 | 0.87395 | 1.468236 | Naviculaceae | 67474 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 5.43e-7 | NR | CAB9511201.1 | 568900 | g27941 | i0 | 85.4 | 1.71428571428571 | 48 | 7 | 85.7 | 0 | 163 | 20 | 48 | 95 | CAB9511201.1 ubiquitin [Seminavis robusta] | diamond | 288 | 52.4 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Seminavis | Seminavis robusta | ||
| 28941006 | 28941006 | PRJNA532380_P_NODE_33588_length_162_cov_0.920354_g33263_i0 | PRJNA532380 | 33588 | 162 | 0.920354 | 1.49097348 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 5.39e-19 | NR | TNV81950.1 | 5974 | g33263 | i0 | 71.2 | 0.962962962962963 | 52 | 15 | 96.3 | 0 | 3 | 158 | 395 | 446 | TNV81950.1 hypothetical protein FGO68_gene5546 [Halteria grandinella] | diamond | 156 | 89 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 29035707 | 29035707 | PRJNA532380_P_NODE_29448_length_167_cov_0.881356_g29123_i0 | PRJNA532380 | 29448 | 167 | 0.881356 | 1.47186452 | Cafeteria roenbergensis | 33653 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 5.49e-11 | NR | KAA0161520.1 | 33653 | g29123 | i0 | 84.8 | 0.592814371257485 | 33 | 5 | 59.3 | 0 | 1 | 99 | 295 | 327 | KAA0161520.1 hypothetical protein FNF31_03803 [Cafeteria roenbergensis] | diamond | 99 | 66.2 | 1 | Eukaryota | Sar | Bigyra | Bicosoecida | Cafeteriaceae | Cafeteria | Cafeteria roenbergensis | |||
| 29351347 | 29351347 | PRJNA532380_P_NODE_27389_length_169_cov_0.866667_g27064_i0 | PRJNA532380 | 27389 | 169 | 0.866667 | 1.46466723 | Karlodinium veneficum | 407301 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 4.01e-24 | NR | ABV22229.1 | 407301 | g27064 | i0 | 87.3 | 2.96449704142012 | 55 | 7 | 97.6 | 0 | 1 | 165 | 123 | 177 | ABV22229.1 ATP/ADP translocator [Karlodinium veneficum] | diamond | 501 | 101 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Kareniaceae | Karlodinium | Karlodinium veneficum | |||
| 29382891 | 29382891 | PRJNA532380_P_NODE_27829_length_169_cov_0.866667_g27504_i0 | PRJNA532380 | 27829 | 169 | 0.866667 | 1.46466723 | Vitrella brassicaformis | 1169539 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 4.46e-14 | NR | AND95666.1 | 1169539 | g27504 | i0 | 65.3 | 0.869822485207101 | 49 | 17 | 87 | 0 | 167 | 21 | 122 | 170 | AND95666.1 Alanine-glyoxylate aminotransferase [Vitrella brassicaformis] | diamond | 147 | 75.1 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 29445769 | 29445769 | PRJNA532380_P_NODE_28810_length_167_cov_1.762712_g28485_i0 | PRJNA532380 | 28810 | 167 | 1.762712 | 2.94372904 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00521 | NR | CAE8612162.1 | 89957 | g28485 | i0 | 39.2 | 9.75449101796407 | 51 | 31 | 91.6 | 0 | 158 | 6 | 185 | 235 | CAE8612162.1 unnamed protein product [Polarella glacialis] | diamond | 1629 | 43.9 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 30014508 | 30014508 | PRJNA532380_P_NODE_28591_length_168_cov_0.873950_g28266_i0 | PRJNA532380 | 28591 | 168 | 0.87395 | 1.468236 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 1.02e-15 | NR | TNV73304.1 | 5974 | g28266 | i0 | 53.6 | 1 | 56 | 26 | 100 | 0 | 168 | 1 | 43 | 98 | TNV73304.1 hypothetical protein FGO68_gene16622 [Halteria grandinella] | diamond | 168 | 78.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 31103596 | 31103596 | PRJNA532380_P_NODE_32595_length_163_cov_0.912281_g32270_i0 | PRJNA532380 | 32595 | 163 | 0.912281 | 1.48701803 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.58e-7 | NR | CAD8116103.1 | 5886 | g32270 | i0 | 56.4 | 2.13496932515337 | 39 | 17 | 71.8 | 0 | 47 | 163 | 16 | 54 | CAD8116103.1 unnamed protein product [Paramecium primaurelia] | diamond | 348 | 55.5 | 0.992792792792793 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 32764173 | 32764173 | PRJNA532380_P_NODE_27720_length_169_cov_0.866667_g27395_i0 | PRJNA532380 | 27720 | 169 | 0.866667 | 1.46466723 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 2.07e-6 | NR | CDW71884.1 | 5949 | g27395 | i0 | 42.9 | 0.869822485207101 | 49 | 28 | 87 | 0 | 15 | 161 | 153 | 201 | CDW71884.1 cop9 signalosome complex subunit 7b [Stylonychia lemnae] | diamond | 147 | 53.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32827238 | 32827238 | PRJNA532380_P_NODE_22320_length_190_cov_1.106383_g21995_i0 | PRJNA532380 | 22320 | 190 | 1.106383 | 2.1021277 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 2.53e-8 | NR | OQR97283.1 | 74557 | g21995 | i0 | 40.3 | 0.978947368421053 | 62 | 37 | 97.9 | 0 | 3 | 188 | 324 | 385 | OQR97283.1 phosphoacetylglucosamine mutase [Thraustotheca clavata] | diamond | 186 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata |
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);;