contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_phylum = "Candidatus Kaiseribacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 915854 | 915854 | PRJNA939415_P_NODE_62401_length_271_cov_2.959596_g61979_i0 | PRJNA939415 | 62401 | 271 | 2.959596 | 8.02050516 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 281 | 2.91e-71 | NTclustered | gi|2874253687|emb|OY969413.1| | 2030810 | g61979 | i0 | 85.662 | 8.22509225092251 | 272 | 33 | 99 | 5 | 1 | 269 | 887122 | 886854 | MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1 | blastn | 2229 | 281 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 4744602 | 4744602 | PRJNA939415_P_NODE_83824_length_250_cov_3.129944_g83402_i0 | PRJNA939415 | 83824 | 250 | 3.129944 | 7.82486 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 204 | 5.909999999999999e-48 | NTclustered | gi|2874253687|emb|OY969413.1| | 2030810 | g83402 | i0 | 82.203 | 22.788 | 236 | 42 | 94 | 0 | 1 | 236 | 51110 | 51345 | MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1 | blastn | 5697 | 204 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 13669687 | 13669687 | PRJNA939415_P_NODE_73611_length_260_cov_3.016043_g73189_i0 | PRJNA939415 | 73611 | 260 | 3.016043 | 7.8417118 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 303 | 5.92e-78 | NTclustered | gi|2874253687|emb|OY969413.1| | 2030810 | g73189 | i0 | 91.403 | 10.8192307692308 | 221 | 19 | 85 | 0 | 1 | 221 | 888997 | 888777 | MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1 | blastn | 2813 | 303 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 18766553 | 18766553 | PRJNA939415_P_NODE_106575_length_222_cov_4.530201_g106153_i0 | PRJNA939415 | 106575 | 222 | 4.530201 | 10.05704622 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 191 | 4e-44 | NTclustered | gi|1958016626|gb|CP064968.1| | 2030810 | g106153 | i0 | 86.782 | 106.887387387387 | 174 | 19 | 78 | 3 | 43 | 215 | 956418 | 956588 | MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome | blastn | 23729 | 191 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria 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);;