contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA495917" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3659089 | 3659089 | PRJNA495917_S_NODE_3403_length_265_cov_15.665217_g3209_i0 | PRJNA495917 | 3403 | 265 | 15.665217 | 41.512825049999996 | Bacteria | 2 | Bacteria | Bacteria | 457 | 4.39e-124 | NTclustered | gi|218533824|gb|FJ490338.1| | 171953 | g3209 | i0 | 97.736 | 99.3849056603774 | 265 | 6 | 100 | 0 | 1 | 265 | 269 | 5 | Uncultured Acidobacteria bacterium clone H_18 16S ribosomal RNA gene, partial sequence | blastn | 26337 | 457 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 4304291 | 4304291 | PRJNA495917_S_NODE_1084_length_454_cov_96.167064_g892_i0 | PRJNA495917 | 1084 | 454 | 96.167064 | 436.59847056 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 542 | 2.14e-149 | NTclustered | gi|105990458|gb|DQ514189.1| | 171953 | g892 | i0 | 96.914 | 73.9030837004405 | 324 | 9 | 71 | 1 | 131 | 454 | 893 | 571 | Uncultured Acidobacteria bacterium clone 500M2_F6 16S ribosomal RNA gene, partial sequence | blastn | 33552 | 542 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6855036 | 6855036 | PRJNA495917_S_NODE_1046_length_463_cov_24.282710_g854_i0 | PRJNA495917 | 1046 | 463 | 24.28271 | 112.4289473 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 510 | 6.17e-140 | NTclustered | gi|217038899|gb|EU810989.1| | 171953 | g854 | i0 | 94.562 | 303.980561555076 | 331 | 17 | 71 | 1 | 1 | 330 | 332 | 2 | Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence | blastn | 140743 | 510 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6855097 | 6855097 | PRJNA495917_S_NODE_14406_length_156_cov_2.793388_g14212_i0 | PRJNA495917 | 14406 | 156 | 2.793388 | 4.35768528 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 93.5 | 7.57e-15 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g14212 | i0 | 83.654 | 27.3397435897436 | 104 | 11 | 64 | 5 | 43 | 142 | 1523757 | 1523656 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 4265 | 93.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 9405451 | 9405451 | PRJNA495917_S_NODE_1768_length_361_cov_136.496933_g1574_i0 | PRJNA495917 | 1768 | 361 | 136.496933 | 492.75392813 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 569 | 7.639999999999997e-158 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g1574 | i0 | 96 | 137.537396121884 | 350 | 14 | 97 | 0 | 12 | 361 | 3301046 | 3300697 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 49651 | 569 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 11310966 | 11310966 | PRJNA495917_S_NODE_10209_length_173_cov_5.797101_g10015_i0 | PRJNA495917 | 10209 | 173 | 5.797101 | 10.02898473 | Bacteria | 2 | Bacteria | Bacteria | 143 | 8.38e-30 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g10015 | i0 | 95.506 | 8.67630057803468 | 89 | 4 | 51 | 0 | 1 | 89 | 4841884 | 4841796 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 1501 | 143 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22153996 | 22153996 | PRJNA495917_S_NODE_1078_length_456_cov_33.163895_g886_i0 | PRJNA495917 | 1078 | 456 | 33.163895 | 151.2273612 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 577 | 5.899999999999998e-160 | NTclustered | gi|217038907|gb|EU810998.1| | 171953 | g886 | i0 | 97.898 | 365.75 | 333 | 7 | 73 | 0 | 1 | 333 | 333 | 1 | Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence | blastn | 166782 | 577 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 24703547 | 24703547 | PRJNA495917_S_NODE_760_length_534_cov_20.775551_g583_i0 | PRJNA495917 | 760 | 534 | 20.775551 | 110.94144234 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 797 | 0 | NTclustered | gi|2874253710|emb|OY969475.1| | 2283092 | g583 | i0 | 93.645 | 105.715355805243 | 535 | 31 | 100 | 3 | 1 | 534 | 1821532 | 1822064 | MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 | blastn | 56452 | 797 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;