contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7404411 | 7404411 | PRJNA1120060_P_NODE_3144046_length_234_cov_2.484472_g3125942_i0 | PRJNA1120060 | 3144046 | 234 | 2.484472 | 5.81366448 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 305 | 1.46e-78 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g3125942 | i0 | 90.476 | 51.8034188034188 | 231 | 22 | 99 | 0 | 4 | 234 | 1073935 | 1073705 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 12122 | 305 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 7902180 | 7902180 | PRJNA1120060_P_NODE_2267747_length_262_cov_2.788360_g2249692_i0 | PRJNA1120060 | 2267747 | 262 | 2.78836 | 7.3055032 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g2249692 | i0 | 100 | 0.110687022900763 | 29 | 0 | 11 | 0 | 124 | 152 | 2061735 | 2061763 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 9200773 | 9200773 | PRJNA1120060_P_NODE_899988_length_312_cov_4.514644_g882059_i0 | PRJNA1120060 | 899988 | 312 | 4.514644 | 14.08568928 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g882059 | i0 | 100 | 0.0897435897435897 | 28 | 0 | 9 | 0 | 103 | 130 | 460227 | 460254 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 14297875 | 14297875 | PRJNA1120060_P_NODE_636552_length_342_cov_10.992565_g618787_i0 | PRJNA1120060 | 636552 | 342 | 10.992565 | 37.5945723 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 52.8 | 0.032 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g618787 | i0 | 100 | 0.0818713450292398 | 28 | 0 | 8 | 0 | 135 | 162 | 1604343 | 1604316 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 16818720 | 16818720 | PRJNA1120060_P_NODE_1700634_length_285_cov_1.462264_g1682630_i0 | PRJNA1120060 | 1700634 | 285 | 1.462264 | 4.1674524 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2874253742|emb|OY969585.1| | 2026749 | g1682630 | i0 | 100 | 0.101754385964912 | 29 | 0 | 10 | 0 | 200 | 228 | 1605052 | 1605024 | MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 16828199 | 16828199 | PRJNA1120060_P_NODE_2399754_length_257_cov_3.277174_g2381686_i0 | PRJNA1120060 | 2399754 | 257 | 3.277174 | 8.42233718 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g2381686 | i0 | 94.444 | 0.140077821011673 | 36 | 0 | 14 | 2 | 65 | 100 | 1328343 | 1328310 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 36 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 16828392 | 16828392 | PRJNA1120060_P_NODE_2414654_length_257_cov_1.434783_g2396586_i0 | PRJNA1120060 | 2414654 | 257 | 1.434783 | 3.68739231 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2621704225|emb|OY761615.1| | 2651163 | g2396586 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 224 | 251 | 5534182 | 5534155 | MAG: Ignavibacteriaceae bacterium isolate 0c874fb2-9291-49ee-bde1-826c4484edf3 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 16851329 | 16851329 | PRJNA1120060_P_NODE_972354_length_312_cov_2.866109_g954425_i0 | PRJNA1120060 | 972354 | 312 | 2.866109 | 8.94226008 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2874253742|emb|OY969585.1| | 2026749 | g954425 | i0 | 100 | 0.0897435897435897 | 28 | 0 | 9 | 0 | 112 | 139 | 1227976 | 1227949 | MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 18109541 | 18109541 | PRJNA1120060_P_NODE_29695_length_885_cov_4.352217_g20831_i0 | PRJNA1120060 | 29695 | 885 | 4.352217 | 38.51712045 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 54.7 | 0.025 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g20831 | i0 | 100 | 0.0327683615819209 | 29 | 0 | 3 | 0 | 69 | 97 | 2061735 | 2061763 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 19366600 | 19366600 | PRJNA1120060_P_NODE_163056_length_495_cov_3.672986_g147017_i0 | PRJNA1120060 | 163056 | 495 | 3.672986 | 18.1812807 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 54.7 | 0.013 | NTclustered | gi|2314740639|dbj|AP026678.1| | 2651167 | g147017 | i0 | 94.444 | 0.0727272727272727 | 36 | 1 | 7 | 1 | 347 | 381 | 2380685 | 2380720 | MAG: Ignavibacterium sp. KatS3mg037 DNA, complete genome | blastn | 36 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 20644914 | 20644914 | PRJNA1120060_P_NODE_1855957_length_278_cov_3.804878_g1837941_i0 | PRJNA1120060 | 1855957 | 278 | 3.804878 | 10.57756084 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2556932299|gb|CP129491.1| | 2651163 | g1837941 | i0 | 100 | 0.827338129496403 | 29 | 0 | 10 | 0 | 68 | 96 | 74478 | 74506 | MAG: Ignavibacteriaceae bacterium isolate cMAG.5 chromosome, complete genome | blastn | 230 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae 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);;