contig_metadata
10 rows where bioproject = "PRJNA1028258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1440556 | 1440556 | PRJNA1028258_P_NODE_91862_length_269_cov_1.620000_g91299_i0 | PRJNA1028258 | 91862 | 269 | 1.62 | 4.3578 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 283 | 8.03e-72 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g91299 | i0 | 85.874 | 806.423791821561 | 269 | 34 | 99 | 4 | 1 | 267 | 5033253 | 5033519 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 216928 | 283 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 15468668 | 15468668 | PRJNA1028258_P_NODE_94793_length_266_cov_1.431472_g94230_i0 | PRJNA1028258 | 94793 | 266 | 1.431472 | 3.80771552 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 137 | 6.53e-28 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g94230 | i0 | 81.707 | 1.1203007518797 | 164 | 30 | 65 | 0 | 30 | 193 | 7681783 | 7681620 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 298 | 137 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 15468766 | 15468766 | PRJNA1028258_P_NODE_99513_length_261_cov_1.609375_g98950_i0 | PRJNA1028258 | 99513 | 261 | 1.609375 | 4.20046875 | Vulcanimicrobium alpinum | 3016050 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2416250577|dbj|AP025523.1| | 3016050 | g98950 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 216 | 243 | 3366498 | 3366525 | Vulcanimicrobium alpinum WC8-2 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Vulcanimicrobium | Vulcanimicrobium alpinum | ||
| 19289576 | 19289576 | PRJNA1028258_P_NODE_15376_length_648_cov_2.305699_g14847_i0 | PRJNA1028258 | 15376 | 648 | 2.305699 | 14.94092952 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 741 | 0 | NTclustered | gi|2202949261|emb|OV972893.1| | 3107663 | g14847 | i0 | 87.5 | 839.172839506173 | 648 | 73 | 99 | 8 | 5 | 648 | 5032721 | 5032078 | MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1 | blastn | 543784 | 741 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 26813539 | 26813539 | PRJNA1028258_P_NODE_112881_length_250_cov_1.392265_g112318_i0 | PRJNA1028258 | 112881 | 250 | 1.392265 | 3.4806625 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 87.8 | 5.1e-18 | NR | MFN8613385.1 | 3107663 | g112318 | i0 | 62 | 0.852 | 71 | 22 | 85.2 | 1 | 236 | 24 | 4 | 69 | MFN8613385.1 DUF1800 domain-containing protein [Vulcanimicrobiota bacterium] | diamond | 213 | 87.8 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28677363 | 28677363 | PRJNA1028258_P_NODE_110167_length_252_cov_1.551913_g109604_i0 | PRJNA1028258 | 110167 | 252 | 1.551913 | 3.91082076 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 117 | 1.59e-28 | NR | MFA7480674.1 | 3107663 | g109604 | i0 | 71.1 | 0.988095238095238 | 83 | 24 | 98.8 | 0 | 2 | 250 | 140 | 222 | MFA7480674.1 tetratricopeptide repeat protein [Vulcanimicrobiota bacterium] | diamond | 249 | 117 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 28740440 | 28740440 | PRJNA1028258_P_NODE_152027_length_231_cov_0.876543_g151464_i0 | PRJNA1028258 | 152027 | 231 | 0.876543 | 2.02481433 | Candidatus Eremiobacteraceae bacterium | 3069296 | Bacteria | Bacteria | 90.5 | 5.34e-20 | NR | HZV58939.1 | 3069296 | g151464 | i0 | 55.4 | 1.92207792207792 | 74 | 33 | 96.1 | 0 | 224 | 3 | 154 | 227 | HZV58939.1 aspartate kinase [Candidatus Eremiobacteraceae bacterium] | diamond | 444 | 90.5 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Candidatus Eremiobacterales | Candidatus Eremiobacteraceae | Candidatus Eremiobacteraceae bacterium | |||
| 29466234 | 29466234 | PRJNA1028258_P_NODE_139810_length_233_cov_1.609756_g139247_i0 | PRJNA1028258 | 139810 | 233 | 1.609756 | 3.75073148 | Vulcanimicrobiota bacterium | 3107663 | Bacteria | Bacteria | 117 | 1.29e-28 | NR | MFA7483330.1 | 3107663 | g139247 | i0 | 66.7 | 0.965665236051502 | 75 | 25 | 96.6 | 0 | 225 | 1 | 603 | 677 | MFA7483330.1 DEAD/DEAH box helicase [Vulcanimicrobiota bacterium] | diamond | 225 | 117 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiota bacterium | ||||||
| 29877223 | 29877223 | PRJNA1028258_P_NODE_147831_length_232_cov_0.871166_g147268_i0 | PRJNA1028258 | 147831 | 232 | 0.871166 | 2.02110512 | Candidatus Baltobacteraceae bacterium | 3107660 | Bacteria | Bacteria | 69.3 | 1.34e-11 | NR | HEY1728394.1 | 2952909 | g147268 | i0 | 53.9 | 0.982758620689655 | 76 | 32 | 98.3 | 1 | 230 | 3 | 564 | 636 | HEY1728394.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Baltobacteraceae bacterium] | diamond | 228 | 69.3 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Vulcanimicrobiia | Vulcanimicrobiales | Vulcanimicrobiaceae | Candidatus Baltobacteraceae bacterium | |||
| 30572008 | 30572008 | PRJNA1028258_P_NODE_94913_length_266_cov_1.335025_g94350_i0 | PRJNA1028258 | 94913 | 266 | 1.335025 | 3.5511665 | Candidatus Xenobia bacterium | 3036772 | Bacteria | Bacteria | 120 | 8.16e-30 | NR | GMU55623.1 | 3036772 | g94350 | i0 | 71.8 | 0.958646616541353 | 85 | 24 | 95.9 | 0 | 257 | 3 | 324 | 408 | GMU55623.1 MAG: hypothetical protein AMXMBFR33_47690 [Candidatus Xenobia bacterium] | diamond | 255 | 120 | 1 | Bacteria | Bacillati | Vulcanimicrobiota | Candidatus Xenobia | Candidatus Xenobia 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);;