contig_metadata
7 rows where bioproject = "PRJNA1002570" and tax_phylum = "Vulcanimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12906348 | 12906348 | PRJNA1002570_P_NODE_46011_length_209_cov_4.242647_g45816_i0 | PRJNA1002570 | 46011 | 209 | 4.242647 | 8.86713223 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 139 | 1.37e-28 | NTclustered | gi|2874253918|emb|OY970243.1| | 3107663 | g45816 | i0 | 80.319 | 20.866028708134 | 188 | 33 | 88 | 4 | 4 | 187 | 139340 | 139153 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 | blastn | 4361 | 139 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 23104724 | 23104724 | PRJNA1002570_P_NODE_38399_length_248_cov_0.880000_g38204_i0 | PRJNA1002570 | 38399 | 248 | 0.88 | 2.1824 | Vulcanimicrobium alpinum | 3016050 | Bacteria | Bacteria | 134 | 7.79e-27 | NTclustered | gi|2416250577|dbj|AP025523.1| | 3016050 | g38204 | i0 | 83.221 | 0.600806451612903 | 149 | 22 | 59 | 2 | 96 | 241 | 444220 | 444072 | Vulcanimicrobium alpinum WC8-2 DNA, complete genome | blastn | 149 | 134 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Vulcanimicrobium | Vulcanimicrobium alpinum | ||
| 26876464 | 26876464 | PRJNA1002570_P_NODE_15241_length_310_cov_3.839662_g15046_i0 | PRJNA1002570 | 15241 | 310 | 3.839662 | 11.9029522 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 86.7 | 3.2e-17 | NR | HXW57678.1 | 2952917 | g15046 | i0 | 42 | 2.34193548387097 | 119 | 50 | 96.8 | 3 | 6 | 305 | 1477 | 1595 | HXW57678.1 amino acid adenylation domain-containing protein [Candidatus Cybelea sp.] | diamond | 726 | 86.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 27445544 | 27445544 | PRJNA1002570_P_NODE_27703_length_273_cov_1.540000_g27508_i0 | PRJNA1002570 | 27703 | 273 | 1.54 | 4.2042 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 96.7 | 3.45e-22 | NR | HVO04733.1 | 2952917 | g27508 | i0 | 90.2 | 3.36263736263736 | 51 | 5 | 56 | 0 | 153 | 1 | 150 | 200 | HVO04733.1 IS21-like element helper ATPase IstB [Candidatus Cybelea sp.] | diamond | 918 | 96.7 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 28961087 | 28961087 | PRJNA1002570_P_NODE_45048_length_234_cov_3.099379_g44853_i0 | PRJNA1002570 | 45048 | 234 | 3.099379 | 7.25254686 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 52 | 1.85e-5 | NR | HEY7993380.1 | 3069296 | g44853 | i0 | 50.9 | 2.34615384615385 | 53 | 26 | 67.9 | 0 | 201 | 43 | 336 | 388 | HEY7993380.1 alpha/beta fold hydrolase [Candidatus Eremiobacteraceae bacterium] | diamond | 549 | 52 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 31551635 | 31551635 | PRJNA1002570_P_NODE_36396_length_250_cov_3.203390_g36201_i0 | PRJNA1002570 | 36396 | 250 | 3.20339 | 8.008475 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 63.2 | 1.28e-9 | NR | HXW56264.1 | 2952917 | g36201 | i0 | 60 | 1.116 | 50 | 20 | 60 | 0 | 9 | 158 | 196 | 245 | HXW56264.1 SDR family oxidoreductase [Candidatus Cybelea sp.] | diamond | 279 | 63.2 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 32689643 | 32689643 | PRJNA1002570_P_NODE_44620_length_238_cov_3.139394_g44425_i0 | PRJNA1002570 | 44620 | 238 | 3.139394 | 7.47175772 | Candidatus Aquilonibacter sp. | 2952903 | Bacteria | Bacteria | 119 | 4.5000000000000004e-30 | NR | HUO24823.1 | 2952903 | g44425 | i0 | 79.5 | 1.95378151260504 | 78 | 16 | 98.3 | 0 | 3 | 236 | 201 | 278 | HUO24823.1 ABC transporter permease [Candidatus Aquilonibacter sp.] | diamond | 465 | 119 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Aquilonibacter | Candidatus Aquilonibacter sp. |
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);;