contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4204842 | 4204842 | PRJNA312107_P_NODE_24884_length_163_cov_0.912281_g24718_i0 | PRJNA312107 | 24884 | 163 | 0.912281 | 1.48701803 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 139 | 1.01e-28 | NTclustered | gi|2874253959|emb|OY970284.1| | 2651171 | g24718 | i0 | 82.692 | 1.91411042944785 | 156 | 27 | 96 | 0 | 1 | 156 | 1318265 | 1318110 | MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1 | blastn | 312 | 139 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 11856243 | 11856243 | PRJNA312107_P_NODE_21350_length_166_cov_1.504274_g21184_i0 | PRJNA312107 | 21350 | 166 | 1.5042739999999999 | 2.49709484 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 302 | 1.2500000000000001e-77 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g21184 | i0 | 99.398 | 101.71686746988 | 166 | 1 | 100 | 0 | 1 | 166 | 4651372 | 4651537 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 16885 | 302 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 12542115 | 12542115 | PRJNA312107_P_NODE_10590_length_222_cov_1.456647_g10424_i0 | PRJNA312107 | 10590 | 222 | 1.456647 | 3.23375634 | Bacteria | 2 | Bacteria | Bacteria | 224 | 3.94e-54 | NTclustered | gi|2621702213|emb|OY760195.1| | 188475 | g10424 | i0 | 85.135 | 169.004504504504 | 222 | 29 | 99 | 4 | 1 | 220 | 871090 | 870871 | MAG: uncultured Holophaga sp. isolate 19663c38-e6f5-42a8-8268-146037a524bf genome assembly, chromosome: 1 | blastn | 37519 | 224 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophaga | uncultured Holophaga sp. | ||
| 13131296 | 13131296 | PRJNA312107_P_NODE_11151_length_217_cov_1.232143_g10985_i0 | PRJNA312107 | 11151 | 217 | 1.232143 | 2.67375031 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 361 | 2.8e-95 | NTclustered | gi|2874254108|emb|OY970193.1| | 171953 | g10985 | i0 | 96.774 | 286.889400921659 | 217 | 6 | 99 | 1 | 1 | 216 | 1687240 | 1687456 | MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1 | blastn | 62255 | 361 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 15680392 | 15680392 | PRJNA312107_P_NODE_23653_length_164_cov_0.904348_g23487_i0 | PRJNA312107 | 23653 | 164 | 0.904348 | 1.48313072 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 215 | 1.65e-51 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g23487 | i0 | 91.304 | 143.201219512195 | 161 | 8 | 96 | 4 | 4 | 161 | 634458 | 634615 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 23485 | 215 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 18229314 | 18229314 | PRJNA312107_P_NODE_23735_length_164_cov_0.904348_g23569_i0 | PRJNA312107 | 23735 | 164 | 0.904348 | 1.48313072 | uncultured Holophaga sp. | 188475 | Bacteria | Bacteria | 259 | 7.52e-65 | NTclustered | gi|2621704223|emb|OY761614.1| | 188475 | g23569 | i0 | 95.152 | 114.689024390244 | 165 | 7 | 100 | 1 | 1 | 164 | 644214 | 644378 | MAG: uncultured Holophaga sp. isolate c3c763bb-72ba-4188-aae9-c4b83244ba6d genome assembly, chromosome: 1 | blastn | 18809 | 259 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophaga | uncultured Holophaga 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);;