contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2866384 | 2866384 | PRJNA1174207_P_NODE_22943_length_296_cov_3.502242_g22414_i0 | PRJNA1174207 | 22943 | 296 | 3.502242 | 10.36663632 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 540 | 4.81e-149 | NTclustered | gi|325147544|gb|HQ597525.1| | 171953 | g22414 | i0 | 99.661 | 99.6047297297297 | 295 | 1 | 99 | 0 | 2 | 296 | 307 | 13 | Uncultured Acidobacteria bacterium clone HEG_08_183 16S ribosomal RNA gene, partial sequence | blastn | 29483 | 540 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6693194 | 6693194 | PRJNA1174207_P_NODE_10186_length_478_cov_2.683951_g9660_i0 | PRJNA1174207 | 10186 | 478 | 2.683951 | 12.82928578 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 204 | 1.21e-47 | NTclustered | gi|2874253709|emb|OY969474.1| | 171953 | g9660 | i0 | 77.624 | 116.813807531381 | 362 | 63 | 74 | 13 | 22 | 376 | 3917853 | 3918203 | MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 | blastn | 55837 | 204 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6693240 | 6693240 | PRJNA1174207_P_NODE_13386_length_399_cov_2.073620_g12858_i0 | PRJNA1174207 | 13386 | 399 | 2.07362 | 8.2737438 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 592 | 1.82e-164 | NTclustered | gi|2874253796|emb|OY969780.1| | 194844 | g12858 | i0 | 93.5 | 157.914786967419 | 400 | 23 | 99 | 3 | 1 | 398 | 284788 | 285186 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 | blastn | 63008 | 592 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 8693547 | 8693547 | PRJNA1174207_P_NODE_25987_length_281_cov_2.288462_g25458_i0 | PRJNA1174207 | 25987 | 281 | 2.288462 | 6.43057822 | Acidobacteriaceae | 204434 | Bacteria | Bacteria | 453 | 6.08e-123 | NTclustered | gi|1799576755|gb|CP042596.1| | 2602070 | g25458 | i0 | 95.73 | 122.53024911032 | 281 | 12 | 100 | 0 | 1 | 281 | 397657 | 397937 | Granulicella sp. WH15 chromosome, complete genome | blastn | 34431 | 453 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella sp. WH15 | ||
| 9243735 | 9243735 | PRJNA1174207_P_NODE_37128_length_246_cov_1.780347_g36599_i0 | PRJNA1174207 | 37128 | 246 | 1.780347 | 4.37965362 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 211 | 3.46e-50 | NTclustered | gi|2621701418|emb|OY760136.1| | 2910147 | g36599 | i0 | 82.377 | 5.82520325203252 | 244 | 41 | 99 | 2 | 2 | 244 | 1096905 | 1097147 | MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1 | blastn | 1433 | 211 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 11794415 | 11794415 | PRJNA1174207_P_NODE_37050_length_246_cov_2.664740_g36521_i0 | PRJNA1174207 | 37050 | 246 | 2.66474 | 6.5552604 | Granulicella sp. 5B5 | 1617967 | Bacteria | Bacteria | 455 | 1.4500000000000002e-123 | NTclustered | gi|1886125103|gb|CP046444.1| | 1617967 | g36521 | i0 | 100 | 111.239837398374 | 246 | 0 | 100 | 0 | 1 | 246 | 2652647 | 2652892 | Granulicella sp. 5B5 chromosome, complete genome | blastn | 27365 | 455 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella sp. 5B5 | ||
| 13069014 | 13069014 | PRJNA1174207_P_NODE_17151_length_345_cov_1.128676_g16622_i0 | PRJNA1174207 | 17151 | 345 | 1.128676 | 3.8939322 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 390 | 6.089999999999999e-104 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g16622 | i0 | 96.983 | 106.330434782609 | 232 | 7 | 100 | 0 | 114 | 345 | 4233672 | 4233441 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 36684 | 390 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 15618658 | 15618658 | PRJNA1174207_P_NODE_42173_length_236_cov_4.797546_g41644_i0 | PRJNA1174207 | 42173 | 236 | 4.797546 | 11.32220856 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 355 | 1.44e-93 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g41644 | i0 | 94.372 | 186.71186440678 | 231 | 13 | 98 | 0 | 1 | 231 | 3301045 | 3300815 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 44064 | 355 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 18167591 | 18167591 | PRJNA1174207_P_NODE_7455_length_591_cov_2.191120_g6934_i0 | PRJNA1174207 | 7455 | 591 | 2.19112 | 12.9495192 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 1064 | 0 | NTclustered | gi|2874254057|emb|OY970381.1| | 194844 | g6934 | i0 | 99.154 | 101.485617597293 | 591 | 5 | 100 | 0 | 1 | 591 | 1657024 | 1656434 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1 | blastn | 59978 | 1064 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 19441621 | 19441621 | PRJNA1174207_P_NODE_27216_length_276_cov_1.719212_g26687_i0 | PRJNA1174207 | 27216 | 276 | 1.719212 | 4.74502512 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 143 | 1.46e-29 | NTclustered | gi|2874254108|emb|OY970193.1| | 171953 | g26687 | i0 | 80.402 | 35.9347826086956 | 199 | 30 | 71 | 7 | 47 | 242 | 6748566 | 6748374 | MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1 | blastn | 9918 | 143 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 21992529 | 21992529 | PRJNA1174207_P_NODE_43478_length_217_cov_5.763889_g42949_i0 | PRJNA1174207 | 43478 | 217 | 5.763889 | 12.50763913 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 335 | 1.7e-87 | NTclustered | gi|76574288|gb|DQ139436.1| | 171953 | g42949 | i0 | 94.47 | 60.7235023041475 | 217 | 12 | 100 | 0 | 1 | 217 | 11 | 227 | Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence | blastn | 13177 | 335 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 24541582 | 24541582 | PRJNA1174207_P_NODE_26680_length_278_cov_3.312195_g26151_i0 | PRJNA1174207 | 26680 | 278 | 3.312195 | 9.2079021 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 497 | 2.73e-136 | NTclustered | gi|2874254057|emb|OY970381.1| | 194844 | g26151 | i0 | 98.921 | 161.392086330935 | 278 | 3 | 100 | 0 | 1 | 278 | 1654453 | 1654730 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1 | blastn | 44867 | 497 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 24541910 | 24541910 | PRJNA1174207_P_NODE_43560_length_213_cov_4.221429_g43031_i0 | PRJNA1174207 | 43560 | 213 | 4.221429 | 8.99164377 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 274 | 3.67e-69 | NTclustered | gi|112980869|gb|DQ829673.1| | 171953 | g43031 | i0 | 90.385 | 91.0093896713615 | 208 | 20 | 98 | 0 | 1 | 208 | 30 | 237 | Uncultured Acidobacteria bacterium clone DON19 23S ribosomal RNA gene, partial sequence | blastn | 19385 | 274 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota 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);;