contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA565778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10762390 | 10762390 | PRJNA565778_S_NODE_129_length_1424_cov_2.855804_g117_i0 | PRJNA565778 | 129 | 1424 | 2.855804 | 40.66664896 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 2.07e-80 | NR | KAH9092426.1 | 100861 | g117 | i0 | 38.4 | 3.73946629213483 | 437 | 213 | 90.4 | 6 | 1 | 1287 | 319 | 707 | KAH9092426.1 hypothetical protein LEN26_018391 [Aphanomyces euteiches] | diamond | 5325 | 274 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 12037173 | 12037173 | PRJNA565778_S_NODE_1550_length_725_cov_2.648256_g1443_i0 | PRJNA565778 | 1550 | 725 | 2.648256 | 19.199856 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 9.689999999999998e-117 | NR | CAD8176655.1 | 43137 | g1443 | i0 | 67.1 | 0.968275862068966 | 234 | 76 | 96.4 | 1 | 703 | 5 | 6 | 239 | CAD8176655.1 unnamed protein product [Paramecium octaurelia] | diamond | 702 | 346 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 26826488 | 26826488 | PRJNA565778_S_NODE_30781_length_198_cov_2.664596_g30485_i0 | PRJNA565778 | 30781 | 198 | 2.664596 | 5.27590008 | Blastocystis sp. Blastoise | 3128533 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 2.09e-5 | NR | KAK8811461.1 | 3128533 | g30485 | i0 | 48.8 | 0.651515151515151 | 43 | 22 | 65.2 | 0 | 69 | 197 | 282 | 324 | KAK8811461.1 hypothetical protein WA158_003195 [Blastocystis sp. Blastoise] | diamond | 129 | 51.2 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. Blastoise | |||
| 29890108 | 29890108 | PRJNA565778_S_NODE_9091_length_359_cov_2.645963_g8795_i0 | PRJNA565778 | 9091 | 359 | 2.645963 | 9.49900717 | Symbiodinium sp. KB8 | 230985 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 4.859999999999999e-37 | NR | CAE7887481.1 | 230985 | g8795 | i0 | 53.4 | 0.986072423398329 | 118 | 51 | 97.8 | 2 | 8 | 358 | 100 | 214 | CAE7887481.1 Capsl [Symbiodinium sp. KB8] | diamond | 354 | 135 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. KB8 | |||
| 30124480 | 30124480 | PRJNA565778_S_NODE_43172_length_150_cov_1.566372_g42876_i0 | PRJNA565778 | 43172 | 150 | 1.566372 | 2.349558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 2.39e-4 | NR | CAE7803942.1 | 2951 | g42876 | i0 | 52.6 | 3.84 | 38 | 18 | 76 | 0 | 119 | 6 | 267 | 304 | CAE7803942.1 unnamed protein product [Symbiodinium microadriaticum] | diamond | 576 | 47.4 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 30142320 | 30142320 | PRJNA565778_S_NODE_12472_length_310_cov_302.135531_g12176_i0 | PRJNA565778 | 12472 | 310 | 302.135531 | 936.6201461 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 5.46e-12 | NR | XP_067823616.1 | 4779 | g12176 | i0 | 86.7 | 1.16129032258065 | 30 | 4 | 29 | 0 | 39 | 128 | 23 | 52 | XP_067823616.1 uncharacterized protein CCR75_002949 [Bremia lactucae] | diamond | 360 | 66.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 30205595 | 30205595 | PRJNA565778_S_NODE_28492_length_206_cov_8.591716_g28196_i0 | PRJNA565778 | 28492 | 206 | 8.591716 | 17.69893496 | Mayamaea pseudoterrestris | 2872254 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.63e-5 | NR | GKY91383.1 | 2872254 | g28196 | i0 | 65.8 | 0.553398058252427 | 38 | 13 | 55.3 | 0 | 204 | 91 | 298 | 335 | GKY91383.1 hypothetical protein MPSEU_000110600 [Mayamaea pseudoterrestris] | diamond | 114 | 51.6 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Mayamaea | Mayamaea pseudoterrestris | ||
| 30427476 | 30427476 | PRJNA565778_S_NODE_15953_length_277_cov_2.275000_g15657_i0 | PRJNA565778 | 15953 | 277 | 2.275 | 6.30175 | Cladocopium goreaui | 2562237 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 1.75e-21 | NR | CAL1140818.1 | 2562237 | g15657 | i0 | 52.8 | 0.963898916967509 | 89 | 42 | 96.4 | 0 | 9 | 275 | 194 | 282 | CAL1140818.1 unnamed protein product [Cladocopium goreaui] | diamond | 267 | 98.2 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Cladocopium | Cladocopium goreaui | |||
| 30647940 | 30647940 | PRJNA565778_S_NODE_31353_length_196_cov_2.125786_g31057_i0 | PRJNA565778 | 31353 | 196 | 2.125786 | 4.16654056 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 1.8e-4 | NR | OWZ00785.1 | 4795 | g31057 | i0 | 42.4 | 1.01020408163265 | 66 | 34 | 96.4 | 2 | 195 | 7 | 4 | 68 | OWZ00785.1 Calcyphosin [Phytophthora megakarya] | diamond | 198 | 48.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 30837791 | 30837791 | PRJNA565778_S_NODE_8834_length_363_cov_10.435583_g8538_i0 | PRJNA565778 | 8834 | 363 | 10.435583 | 37.88116629 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 1.01e-17 | NR | KAJ1426609.1 | 483371 | g8538 | i0 | 88.7 | 0.43801652892562 | 53 | 5 | 43 | 1 | 36 | 191 | 52 | 104 | KAJ1426609.1 ribosomal L29 protein-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 159 | 83.2 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31641605 | 31641605 | PRJNA565778_S_NODE_1016_length_839_cov_3.068579_g941_i0 | PRJNA565778 | 1016 | 839 | 3.068579 | 25.74537781 | Suessiales | 89954 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 7.23e-34 | NR | CAE8676712.1 | 89957 | g941 | i0 | 34.4 | 3.14660309892729 | 218 | 135 | 75.4 | 3 | 646 | 14 | 32 | 248 | CAE8676712.1 unnamed protein product, partial [Polarella glacialis] | diamond | 2640 | 135 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 31881000 | 31881000 | PRJNA565778_S_NODE_15577_length_280_cov_3.473251_g15281_i0 | PRJNA565778 | 15577 | 280 | 3.473251 | 9.7251028 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 2.99e-11 | NR | KRX01349.1 | 266149 | g15281 | i0 | 50.9 | 5.11071428571429 | 53 | 26 | 56.8 | 0 | 39 | 197 | 240 | 292 | KRX01349.1 hypothetical protein PPERSA_01252 [Pseudocohnilembus persalinus] | diamond | 1431 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31881005 | 31881005 | PRJNA565778_S_NODE_27477_length_210_cov_165.855491_g27181_i0 | PRJNA565778 | 27477 | 210 | 165.855491 | 348.2965311 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0176 | NR | XP_067181760.1 | 310047 | g27181 | i0 | 41.9 | 0.885714285714286 | 62 | 30 | 80 | 2 | 200 | 33 | 359 | 420 | XP_067181760.1 interaptin [Cryptosporidium bovis] | diamond | 186 | 43.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 32134388 | 32134388 | PRJNA565778_S_NODE_13018_length_304_cov_165.056180_g12722_i0 | PRJNA565778 | 13018 | 304 | 165.05618 | 501.7707872 | Tribonema minus | 303371 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 7.73e-5 | NR | KAG5179691.1 | 303371 | g12722 | i0 | 77.8 | 0.266447368421053 | 27 | 6 | 26.6 | 0 | 265 | 185 | 128 | 154 | KAG5179691.1 hypothetical protein JKP88DRAFT_215336 [Tribonema minus] | diamond | 81 | 50.1 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema minus | |||
| 32432860 | 32432860 | PRJNA565778_S_NODE_26159_length_216_cov_2.787709_g25863_i0 | PRJNA565778 | 26159 | 216 | 2.787709 | 6.02145144 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 9.98e-14 | NR | YP_740803.1 | 5905 | g25863 | i0 | 63.5 | 4.33333333333333 | 52 | 19 | 72.2 | 0 | 41 | 196 | 330 | 381 | YP_740803.1 NADH dehydrogenase subunit 4 [Tetrahymena paravorax] | diamond | 936 | 75.5 | 0.994701986754967 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena paravorax |
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);;