contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25503290 | 25503290 | PRJEB14175_P_NODE_148905_length_278_cov_2.949309_g146638_i0 | PRJEB14175 | 148905 | 278 | 2.949309 | 8.19907902 | uncultured Ignavibacteriales bacterium | 1191687 | Bacteria | Bacteria | 141 | 5.310000000000001e-29 | NTclustered | gi|2874253946|emb|OY970271.1| | 1191687 | g146638 | i0 | 94.565 | 34.9784172661871 | 92 | 3 | 33 | 2 | 31 | 122 | 2089471 | 2089560 | MAG: uncultured Ignavibacteriales bacterium isolate MFD02416.bin.c.14 genome assembly, chromosome: 1 | blastn | 9724 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | uncultured Ignavibacteriales bacterium | |||
| 25505298 | 25505298 | PRJEB14175_P_NODE_192649_length_234_cov_1.768786_g190382_i0 | PRJEB14175 | 192649 | 234 | 1.768786 | 4.13895924 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 233 | 6.97e-57 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g190382 | i0 | 90.449 | 247.666666666667 | 178 | 16 | 76 | 1 | 1 | 178 | 873531 | 873707 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 57954 | 233 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 25637257 | 25637257 | PRJEB14175_P_NODE_110426_length_336_cov_51.069091_g108160_i0 | PRJEB14175 | 110426 | 336 | 51.069091 | 171.59214576 | Ignavibacterium album JCM 16511 | 945713 | Bacteria | Bacteria | 148 | 3.9299999999999997e-31 | NTclustered | gi|383800634|gb|CP003418.1| | 945713 | g108160 | i0 | 78.541 | 0.693452380952381 | 233 | 45 | 69 | 3 | 85 | 315 | 499963 | 500192 | Ignavibacterium album JCM 16511, complete genome | blastn | 233 | 148 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium album | |
| 25772909 | 25772909 | PRJEB14175_P_NODE_100267_length_357_cov_3.591216_g98001_i0 | PRJEB14175 | 100267 | 357 | 3.591216 | 12.82064112 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 568 | 2.7099999999999993e-157 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g98001 | i0 | 96 | 814.056022408964 | 350 | 12 | 97 | 1 | 2 | 349 | 429183 | 428834 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 290618 | 568 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 25920764 | 25920764 | PRJEB14175_P_NODE_96364_length_366_cov_2.078689_g94098_i0 | PRJEB14175 | 96364 | 366 | 2.078689 | 7.60800174 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 180 | 1.53e-40 | NTclustered | gi|2621704225|emb|OY761615.1| | 2651163 | g94098 | i0 | 76.901 | 40.8005464480874 | 355 | 59 | 94 | 23 | 24 | 366 | 3101474 | 3101817 | MAG: Ignavibacteriaceae bacterium isolate 0c874fb2-9291-49ee-bde1-826c4484edf3 genome assembly, chromosome: 1 | blastn | 14933 | 180 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 26317484 | 26317484 | PRJEB14175_P_NODE_108055_length_341_cov_4.796429_g105789_i0 | PRJEB14175 | 108055 | 341 | 4.796429 | 16.35582289 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 113 | 1.46e-20 | NTclustered | gi|2621704225|emb|OY761615.1| | 2651163 | g105789 | i0 | 86.792 | 5.46920821114369 | 106 | 9 | 30 | 5 | 236 | 338 | 3100496 | 3100599 | MAG: Ignavibacteriaceae bacterium isolate 0c874fb2-9291-49ee-bde1-826c4484edf3 genome assembly, chromosome: 1 | blastn | 1865 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 26324751 | 26324751 | PRJEB14175_P_NODE_273647_length_183_cov_30.393443_g271379_i0 | PRJEB14175 | 273647 | 183 | 30.393443 | 55.62000069 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 178 | 2.4599999999999998e-40 | NTclustered | gi|1958088527|gb|CP065001.1| | 2049428 | g271379 | i0 | 87.582 | 12.6994535519126 | 153 | 19 | 84 | 0 | 9 | 161 | 39423 | 39271 | Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome | blastn | 2324 | 178 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales 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);;