contig_metadata
9 rows where bioproject = "PRJNA408129" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11897168 | 11897168 | PRJNA408129_S_NODE_11550_length_212_cov_7.337143_g11532_i0 | PRJNA408129 | 11550 | 212 | 7.337143 | 15.55474316 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 193 | 1.05e-44 | NTclustered | gi|756877081|ref|NC_026286.1| | 1008807 | g11532 | i0 | 84.466 | 0.971698113207547 | 206 | 20 | 97 | 6 | 5 | 209 | 716 | 910 | Acrasis kona culture-collection ATCC:MYA-3509 mitochondrion, complete genome | blastn | 206 | 193 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 24644911 | 24644911 | PRJNA408129_S_NODE_4480_length_275_cov_8.613445_g4462_i0 | PRJNA408129 | 4480 | 275 | 8.613445 | 23.68697375 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 324 | 4.85e-84 | NTclustered | gi|756877081|ref|NC_026286.1| | 1008807 | g4462 | i0 | 91.176 | 4.37090909090909 | 238 | 21 | 87 | 0 | 28 | 265 | 2398 | 2635 | Acrasis kona culture-collection ATCC:MYA-3509 mitochondrion, complete genome | blastn | 1202 | 324 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27170121 | 27170121 | PRJNA408129_S_NODE_11502_length_213_cov_1.886364_g11484_i0 | PRJNA408129 | 11502 | 213 | 1.886364 | 4.01795532 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 132 | 2.15e-35 | NR | KAL0483136.1 | 1008807 | g11484 | i0 | 90 | 0.985915492957746 | 70 | 7 | 98.6 | 0 | 212 | 3 | 297 | 366 | KAL0483136.1 serine/threonine phosphatase [Acrasis kona] | diamond | 210 | 132 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27423428 | 27423428 | PRJNA408129_S_NODE_10763_length_217_cov_2.627778_g10745_i0 | PRJNA408129 | 10763 | 217 | 2.627778 | 5.70227826 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 108 | 1.3e-25 | NR | KAL0482346.1 | 1008807 | g10745 | i0 | 79.2 | 0.995391705069124 | 72 | 12 | 99.5 | 2 | 2 | 217 | 601 | 669 | KAL0482346.1 endoplasmic reticulum chaperone BiP [Acrasis kona] | diamond | 216 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30486338 | 30486338 | PRJNA408129_S_NODE_33313_length_153_cov_4.008621_g33295_i0 | PRJNA408129 | 33313 | 153 | 4.008621 | 6.13319013 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 58.2 | 7.16e-9 | NR | KAL0486596.1 | 1008807 | g33295 | i0 | 62.8 | 0.843137254901961 | 43 | 16 | 84.3 | 0 | 1 | 129 | 54 | 96 | KAL0486596.1 ribosomal protein L26 [Acrasis kona] | diamond | 129 | 58.2 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31244552 | 31244552 | PRJNA408129_S_NODE_15635_length_193_cov_2.121795_g15617_i0 | PRJNA408129 | 15635 | 193 | 2.121795 | 4.09506435 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 53.9 | 2.11e-6 | NR | YP_009117126.1 | 1008807 | g15617 | i0 | 48.9 | 0.699481865284974 | 45 | 23 | 69.9 | 0 | 3 | 137 | 513 | 557 | YP_009117126.1 ATP synthase F1 subunit alpha [Acrasis kona] | diamond | 135 | 53.9 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31402922 | 31402922 | PRJNA408129_S_NODE_18936_length_182_cov_1.793103_g18918_i0 | PRJNA408129 | 18936 | 182 | 1.793103 | 3.26344746 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 87.4 | 2.93e-18 | NR | KAL0488885.1 | 1008807 | g18918 | i0 | 81.6 | 0.807692307692308 | 49 | 9 | 80.8 | 0 | 1 | 147 | 526 | 574 | KAL0488885.1 phosphoglucomutase [Acrasis kona] | diamond | 147 | 87.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32162136 | 32162136 | PRJNA408129_S_NODE_6618_length_248_cov_2.829384_g6600_i0 | PRJNA408129 | 6618 | 248 | 2.829384 | 7.01687232 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 88.6 | 2.06e-18 | NR | KAL0488669.1 | 1008807 | g6600 | i0 | 92.4 | 4.76612903225806 | 79 | 6 | 95.6 | 0 | 3 | 239 | 342 | 420 | KAL0488669.1 5'-nucleotidase SurE [Acrasis kona] | diamond | 1182 | 88.6 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32856584 | 32856584 | PRJNA408129_S_NODE_26220_length_164_cov_6.204724_g26202_i0 | PRJNA408129 | 26220 | 164 | 6.204724 | 10.17574736 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 45.8 | 0.00104 | NR | KAL0490808.1 | 1008807 | g26202 | i0 | 37.7 | 0.969512195121951 | 53 | 27 | 86 | 3 | 150 | 10 | 309 | 361 | KAL0490808.1 hypothetical protein AKO1_009603 [Acrasis kona] | diamond | 159 | 45.8 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;