contig_metadata
10 rows where bioproject = "PRJNA1011844", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155974 | 155974 | PRJNA1011844_P_NODE_124861_length_276_cov_4.669951_g116284_i0 | PRJNA1011844 | 124861 | 276 | 4.669951 | 12.88906476 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 414 | 2.81e-111 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g116284 | i0 | 94.757 | 279.789855072464 | 267 | 12 | 96 | 2 | 10 | 274 | 5032313 | 5032579 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 77222 | 414 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 7809360 | 7809360 | PRJNA1011844_P_NODE_25907_length_1065_cov_26.547379_g19820_i0 | PRJNA1011844 | 25907 | 1065 | 26.547379 | 282.72958635 | Candidatus Aquilonibacter sp. | 2952903 | Bacteria | Bacteria | 187 | 4.53e-53 | NR | HTV09869.1 | 2952903 | g19820 | i0 | 41.1 | 4.4056338028169 | 314 | 150 | 85.1 | 8 | 942 | 37 | 14 | 304 | HTV09869.1 oxidoreductase [Candidatus Aquilonibacter sp.] | diamond | 4692 | 187 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Aquilonibacter | Candidatus Aquilonibacter sp. | ||
| 10359104 | 10359104 | PRJNA1011844_P_NODE_124289_length_277_cov_2.833333_g115712_i0 | PRJNA1011844 | 124289 | 277 | 2.833333 | 7.84833241 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 324 | 4.89e-84 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g115712 | i0 | 90.4 | 566.256317689531 | 250 | 19 | 89 | 2 | 3 | 249 | 5032057 | 5032304 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 156853 | 324 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 11635389 | 11635389 | PRJNA1011844_P_NODE_27190_length_1030_cov_3.963427_g20888_i0 | PRJNA1011844 | 27190 | 1030 | 3.963427 | 40.8232981 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 56.5 | 0.008 | NTclustered | gi|2874253703|emb|OY969429.1| | 3107663 | g20888 | i0 | 100 | 0.029126213592233 | 30 | 0 | 3 | 0 | 712 | 741 | 1885588 | 1885559 | MAG: Candidatus Eremiobacteraeota bacterium isolate MFD05705.bin.c.4 genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 15460492 | 15460492 | PRJNA1011844_P_NODE_88633_length_364_cov_2.594502_g80080_i0 | PRJNA1011844 | 88633 | 364 | 2.594502 | 9.44398728 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 446 | 1.36e-120 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g80080 | i0 | 89.943 | 4.17307692307692 | 348 | 32 | 95 | 1 | 17 | 361 | 5032549 | 5032896 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 1519 | 446 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 16732713 | 16732713 | PRJNA1011844_P_NODE_112694_length_296_cov_3.179372_g104118_i0 | PRJNA1011844 | 112694 | 296 | 3.179372 | 9.41094112 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 309 | 1.48e-79 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g104118 | i0 | 86.552 | 95.222972972973 | 290 | 28 | 96 | 9 | 5 | 288 | 5031544 | 5031260 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 28186 | 309 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 27824640 | 27824640 | PRJNA1011844_P_NODE_163704_length_238_cov_2.496970_g155123_i0 | PRJNA1011844 | 163704 | 238 | 2.49697 | 5.9427886 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 60.1 | 2.09e-8 | NR | HET6276301.1 | 2952917 | g155123 | i0 | 49.3 | 0.945378151260504 | 75 | 33 | 88.2 | 2 | 226 | 17 | 75 | 149 | HET6276301.1 hypothetical protein [Candidatus Cybelea sp.] | diamond | 225 | 60.1 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea sp. | ||
| 27950873 | 27950873 | PRJNA1011844_P_NODE_57025_length_553_cov_6.720833_g48663_i0 | PRJNA1011844 | 57025 | 553 | 6.720833 | 37.16620649 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 214 | 4.32e-68 | NR | HEV2878560.1 | 3069296 | g48663 | i0 | 59.2 | 11.1482820976492 | 157 | 64 | 85.2 | 0 | 526 | 56 | 1 | 157 | HEV2878560.1 N-acetyltransferase [Candidatus Eremiobacteraceae bacterium] | diamond | 6165 | 214 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 29119257 | 29119257 | PRJNA1011844_P_NODE_172209_length_225_cov_4.750000_g163628_i0 | PRJNA1011844 | 172209 | 225 | 4.75 | 10.6875 | Candidatus Tumulicola sp. | 3069698 | Bacteria | Bacteria | 77.4 | 1.84e-14 | NR | HXM17951.1 | 3069698 | g163628 | i0 | 56.4 | 4.29333333333333 | 55 | 22 | 73.3 | 1 | 168 | 4 | 109 | 161 | HXM17951.1 multicopper oxidase domain-containing protein [Candidatus Tumulicola sp.] | diamond | 966 | 77.4 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Tumulicola | Candidatus Tumulicola sp. | ||
| 32279510 | 32279510 | PRJNA1011844_P_NODE_108459_length_306_cov_3.583691_g99886_i0 | PRJNA1011844 | 108459 | 306 | 3.583691 | 10.96609446 | Candidatus Cybelea sp. | 2952917 | Bacteria | Bacteria | 45.4 | 0.0084 | NR | HLX25562.1 | 2952917 | g99886 | i0 | 45.7 | 0.450980392156863 | 46 | 24 | 44.1 | 1 | 239 | 105 | 360 | 405 | HLX25562.1 peptide ABC transporter substrate-binding protein [Candidatus Cybelea sp.] | diamond | 138 | 45.4 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Cybelea | Candidatus Cybelea 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);;