contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 958139 | 958139 | PRJNA980839_P_NODE_186401_length_258_cov_1.664865_g182617_i0 | PRJNA980839 | 186401 | 258 | 1.664865 | 4.2953517 | Triparma | 722752 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 4.84e-47 | NR | GMI08560.1 | 1606542 | g182617 | i0 | 85.9 | 12.8488372093023 | 85 | 12 | 98.8 | 0 | 2 | 256 | 88 | 172 | GMI08560.1 hypothetical protein TrVE_jg6717 [Triparma verrucosa] | diamond | 3315 | 159 | 1 | Eukaryota | Sar | Bolidophyceae | Parmales | Triparmaceae | Triparma | Triparma verrucosa | |||
| 17535650 | 17535650 | PRJNA980839_P_NODE_165954_length_273_cov_3.025000_g162170_i0 | PRJNA980839 | 165954 | 273 | 3.025 | 8.25825 | Eimeriidae | 5799 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 5.3e-31 | NR | XP_013230381.1 | 5802 | g162170 | i0 | 66.3 | 3.76923076923077 | 86 | 29 | 94.5 | 0 | 7 | 264 | 1 | 86 | XP_013230381.1 60S Ribosomal protein L36, putative [Eimeria tenella] | diamond | 1029 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 26614571 | 26614571 | PRJNA980839_P_NODE_83061_length_410_cov_2.089021_g79277_i0 | PRJNA980839 | 83061 | 410 | 2.089021 | 8.5649861 | Vitrella brassicaformis CCMP3155 | 1169540 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 4.42e-37 | NR | CEM30526.1 | 1169540 | g79277 | i0 | 73.1 | 0.760975609756098 | 104 | 28 | 76.1 | 0 | 410 | 99 | 3 | 106 | CEM30526.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 312 | 132 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 26905779 | 26905779 | PRJNA980839_P_NODE_239521_length_241_cov_0.916667_g235737_i0 | PRJNA980839 | 239521 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00755 | NR | CAE8625471.1 | 89957 | g235737 | i0 | 64 | 1.86721991701245 | 25 | 9 | 31.1 | 0 | 241 | 167 | 198 | 222 | CAE8625471.1 unnamed protein product, partial [Polarella glacialis] | diamond | 450 | 45.1 | 0.991130820399113 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 27595107 | 27595107 | PRJNA980839_P_NODE_203204_length_250_cov_0.870056_g199420_i0 | PRJNA980839 | 203204 | 250 | 0.870056 | 2.17514 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 2.43e-13 | NR | CEO97863.1 | 37360 | g199420 | i0 | 63.9 | 0.732 | 61 | 22 | 73.2 | 0 | 186 | 4 | 26 | 86 | CEO97863.1 hypothetical protein PBRA_005977 [Plasmodiophora brassicae] | diamond | 183 | 73.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27690053 | 27690053 | PRJNA980839_P_NODE_127844_length_313_cov_1.283333_g124060_i0 | PRJNA980839 | 127844 | 313 | 1.283333 | 4.01683229 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0435 | NR | CAK0871804.1 | 89957 | g124060 | i0 | 46.9 | 0.469648562300319 | 49 | 26 | 47 | 0 | 270 | 124 | 47 | 95 | CAK0871804.1 unnamed protein product [Polarella glacialis] | diamond | 147 | 43.5 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 28479085 | 28479085 | PRJNA980839_P_NODE_237606_length_241_cov_0.916667_g233822_i0 | PRJNA980839 | 237606 | 241 | 0.916667 | 2.20916747 | Vitrella brassicaformis CCMP3155 | 1169540 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.07e-35 | NR | CEM05395.1 | 1169540 | g233822 | i0 | 76 | 0.933609958506224 | 75 | 18 | 93.4 | 0 | 241 | 17 | 107 | 181 | CEM05395.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 225 | 129 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 28485141 | 28485141 | PRJNA980839_P_NODE_225186_length_244_cov_0.900585_g221402_i0 | PRJNA980839 | 225186 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 1.36e-7 | NR | OMJ66985.1 | 5963 | g221402 | i0 | 79.4 | 2.92622950819672 | 34 | 7 | 41.8 | 0 | 239 | 138 | 298 | 331 | OMJ66985.1 hypothetical protein SteCoe_35983 [Stentor coeruleus] | diamond | 714 | 58.5 | 0.994871794871795 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 28769185 | 28769185 | PRJNA980839_P_NODE_205467_length_249_cov_0.875000_g201683_i0 | PRJNA980839 | 205467 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.5e-6 | NR | CDW72625.1 | 5949 | g201683 | i0 | 38.3 | 2.67469879518072 | 81 | 48 | 97.6 | 1 | 245 | 3 | 185 | 263 | CDW72625.1 UNKNOWN [Stylonychia lemnae] | diamond | 666 | 55.5 | 0.992792792792793 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28984501 | 28984501 | PRJNA980839_P_NODE_232108_length_242_cov_1.822485_g228324_i0 | PRJNA980839 | 232108 | 242 | 1.822485 | 4.4104137 | Tribonema minus | 303371 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.73e-32 | NR | KAG5177524.1 | 303371 | g228324 | i0 | 72.7 | 0.954545454545455 | 77 | 21 | 95.5 | 0 | 2 | 232 | 3 | 79 | KAG5177524.1 ribosomal protein L14-domain-containing protein [Tribonema minus] | diamond | 231 | 119 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema minus | |||
| 29426061 | 29426061 | PRJNA980839_P_NODE_227349_length_244_cov_0.894737_g223565_i0 | PRJNA980839 | 227349 | 244 | 0.894737 | 2.18315828 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0212 | NR | OQR81176.1 | 1202772 | g223565 | i0 | 37.8 | 0.55327868852459 | 45 | 28 | 55.3 | 0 | 104 | 238 | 1714 | 1758 | OQR81176.1 hypothetical protein ACHHYP_16695 [Achlya hypogyna] | diamond | 135 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 29552307 | 29552307 | PRJNA980839_P_NODE_147790_length_289_cov_1.425926_g144006_i0 | PRJNA980839 | 147790 | 289 | 1.425926 | 4.12092614 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 3.429999999999999e-23 | NR | GBG28221.1 | 2315210 | g144006 | i0 | 62.7 | 2.75086505190311 | 83 | 30 | 86.2 | 1 | 6 | 254 | 512 | 593 | GBG28221.1 ATP synthase subunit beta, chloroplastic [Hondaea fermentalgiana] | diamond | 795 | 103 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 29994817 | 29994817 | PRJNA980839_P_NODE_152391_length_285_cov_1.334906_g148607_i0 | PRJNA980839 | 152391 | 285 | 1.334906 | 3.8044821 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 3.9e-11 | NR | KAJ1433988.1 | 483371 | g148607 | i0 | 41.4 | 1.04210526315789 | 99 | 53 | 98.9 | 1 | 3 | 284 | 213 | 311 | KAJ1433988.1 hypothetical protein B484DRAFT_394296, partial [Ochromonadaceae sp. CCMP2298] | diamond | 297 | 68.9 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 30563060 | 30563060 | PRJNA980839_P_NODE_195233_length_252_cov_1.659218_g191449_i0 | PRJNA980839 | 195233 | 252 | 1.659218 | 4.18122936 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1.14e-11 | NR | TEB19254.1 | 2494336 | g191449 | i0 | 62.3 | 0.630952380952381 | 53 | 20 | 63.1 | 0 | 189 | 31 | 211 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 159 | 68.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 31043704 | 31043704 | PRJNA980839_P_NODE_153395_length_284_cov_1.459716_g149611_i0 | PRJNA980839 | 153395 | 284 | 1.459716 | 4.14559344 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 8.73e-10 | NR | XP_003882759.1 | 572307 | g149611 | i0 | 59.6 | 1.20422535211268 | 57 | 23 | 60.2 | 0 | 284 | 114 | 90 | 146 | XP_003882759.1 hypothetical protein NCLIV_025160 [Neospora caninum Liverpool] | diamond | 342 | 62.8 | 0.993630573248408 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 31258510 | 31258510 | PRJNA980839_P_NODE_117095_length_329_cov_1.804688_g113311_i0 | PRJNA980839 | 117095 | 329 | 1.804688 | 5.93742352 | Symbiodinium natans | 878477 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 1.14e-45 | NR | CAE7558582.1 | 878477 | g113311 | i0 | 74 | 3.64741641337386 | 100 | 26 | 91.2 | 0 | 328 | 29 | 71 | 170 | CAE7558582.1 rps4x [Symbiodinium natans] | diamond | 1200 | 155 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium natans | |||
| 32080926 | 32080926 | PRJNA980839_P_NODE_213198_length_247_cov_0.885057_g209414_i0 | PRJNA980839 | 213198 | 247 | 0.885057 | 2.18609079 | Symbiodinium sp. CCMP2456 | 1519616 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 1.1599999999999999e-42 | NR | CAE7353696.1 | 1519616 | g209414 | i0 | 100 | 0.983805668016194 | 81 | 0 | 98.4 | 0 | 245 | 3 | 184 | 264 | CAE7353696.1 CACNA1H, partial [Symbiodinium sp. CCMP2456] | diamond | 243 | 149 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. CCMP2456 | |||
| 32775980 | 32775980 | PRJNA980839_P_NODE_179680_length_263_cov_1.278947_g175896_i0 | PRJNA980839 | 179680 | 263 | 1.278947 | 3.36363061 | Vitrella brassicaformis CCMP3155 | 1169540 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 8.33e-4 | NR | CEM24402.1 | 1169540 | g175896 | i0 | 37.9 | 0.992395437262357 | 87 | 48 | 92.4 | 2 | 19 | 261 | 982 | 1068 | CEM24402.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 261 | 47.8 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 32781918 | 32781918 | PRJNA980839_P_NODE_231760_length_242_cov_2.414201_g227976_i0 | PRJNA980839 | 231760 | 242 | 2.414201 | 5.84236642 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 2.41e-12 | NR | XP_067788400.1 | 4785 | g227976 | i0 | 49.3 | 7.17768595041322 | 73 | 37 | 90.5 | 0 | 23 | 241 | 492 | 564 | XP_067788400.1 TKL protein kinase [Phytophthora cinnamomi] | diamond | 1737 | 71.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;