contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA315399" and tax_phylum = "Candidatus Sumerlaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10589628 | 10589628 | PRJNA315399_S_NODE_96449_length_180_cov_3.657343_g96248_i0 | PRJNA315399 | 96449 | 180 | 3.657343 | 6.5832174 | Bacteria | 2 | Bacteria | Bacteria | 99 | 2.02e-22 | NR | PKO16528.1 | 2013722 | g96248 | i0 | 76.4 | 2.75 | 55 | 13 | 91.7 | 0 | 179 | 15 | 188 | 242 | PKO16528.1 MAG: insulinase family protein [candidate division BRC1 bacterium HGW-BRC1-1] | diamond | 495 | 100 | 0.99 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | candidate division BRC1 bacterium HGW-BRC1-1 | ||||||
| 19509640 | 19509640 | PRJNA315399_P_NODE_501156_length_151_cov_3.289474_g500708_i0 | PRJNA315399 | 501156 | 151 | 3.289474 | 4.96710574 | Candidatus Sumerlaeaceae bacterium | 2315423 | Bacteria | Bacteria | 62.4 | 1.24e-9 | NR | MCX7717555.1 | 2315423 | g500708 | i0 | 54.5 | 1.09271523178808 | 55 | 19 | 97.4 | 1 | 147 | 1 | 306 | 360 | MCX7717555.1 glycosyltransferase [Candidatus Sumerlaeaceae bacterium] | diamond | 165 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaeaceae bacterium | |||
| 27801080 | 27801080 | PRJNA315399_P_NODE_407304_length_161_cov_1.580645_g406856_i0 | PRJNA315399 | 407304 | 161 | 1.580645 | 2.54483845 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 45.8 | 2.29e-4 | NR | MFP4579089.1 | 2715255 | g406856 | i0 | 61.3 | 1.15527950310559 | 31 | 12 | 57.8 | 0 | 15 | 107 | 76 | 106 | MFP4579089.1 thioredoxin [Candidatus Sumerlaeia bacterium] | diamond | 186 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 29712466 | 29712466 | PRJNA315399_S_NODE_79670_length_189_cov_6.276316_g79469_i0 | PRJNA315399 | 79670 | 189 | 6.276316 | 11.86223724 | Candidatus Sumerlaea | 2315418 | Bacteria | Bacteria | 79.3 | 2.26e-15 | NR | MCX7018788.1 | 2107588 | g79469 | i0 | 64.9 | 2.71428571428571 | 57 | 20 | 90.5 | 0 | 17 | 187 | 170 | 226 | MCX7018788.1 TIGR03663 family protein [Candidatus Sumerlaeota bacterium] | diamond | 513 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 31085555 | 31085555 | PRJNA315399_S_NODE_154615_length_159_cov_15.344262_g154414_i0 | PRJNA315399 | 154615 | 159 | 15.344262 | 24.39737658 | Candidatus Sumerlaeales bacterium | 2925322 | Bacteria | Bacteria | 92 | 4e-21 | NR | MDD4279862.1 | 2925322 | g154414 | i0 | 83 | 1.75471698113208 | 47 | 8 | 88.7 | 0 | 141 | 1 | 44 | 90 | MDD4279862.1 site-specific DNA-methyltransferase [Candidatus Sumerlaeales bacterium] | diamond | 279 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeales bacterium | ||||
| 31338350 | 31338350 | PRJNA315399_S_NODE_95116_length_181_cov_1.923611_g94915_i0 | PRJNA315399 | 95116 | 181 | 1.923611 | 3.48173591 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 61.2 | 3.84e-10 | NR | MBM3335638.1 | 2107588 | g94915 | i0 | 78.4 | 0.613259668508287 | 37 | 8 | 61.3 | 0 | 54 | 164 | 1 | 37 | MBM3335638.1 SHOCT domain-containing protein [Candidatus Sumerlaeota bacterium] | diamond | 111 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium |
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);;