contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 293616 | 293616 | PRJNA1148190_P_NODE_294321_length_322_cov_1.534137_g283148_i0 | PRJNA1148190 | 294321 | 322 | 1.534137 | 4.93992114 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 379 | 1.22e-100 | NTclustered | gi|1938792964|gb|CP054182.1| | 2049428 | g283148 | i0 | 87.963 | 1.00621118012422 | 324 | 36 | 100 | 3 | 1 | 322 | 87153 | 87475 | Ignavibacteriales bacterium isolate H2_BAC3 chromosome, complete genome | blastn | 324 | 379 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 2311490 | 2311490 | PRJNA1148190_P_NODE_732922_length_243_cov_2.035294_g721749_i0 | PRJNA1148190 | 732922 | 243 | 2.035294 | 4.94576442 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 294 | 3.3e-75 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g721749 | i0 | 88.477 | 173.0329218107 | 243 | 28 | 100 | 0 | 1 | 243 | 1601916 | 1602158 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 42047 | 294 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 5398349 | 5398349 | PRJNA1148190_P_NODE_403905_length_285_cov_2.476415_g392732_i0 | PRJNA1148190 | 403905 | 285 | 2.476415 | 7.05778275 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g392732 | i0 | 100 | 0.101754385964912 | 29 | 0 | 10 | 0 | 248 | 276 | 3360009 | 3360037 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 6672088 | 6672088 | PRJNA1148190_P_NODE_339746_length_304_cov_1.484848_g328573_i0 | PRJNA1148190 | 339746 | 304 | 1.484848 | 4.51393792 | Melioribacter roseus | 1134405 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|395810495|gb|CP003557.1| | 1191523 | g328573 | i0 | 100 | 0.0986842105263158 | 30 | 0 | 10 | 0 | 258 | 287 | 52588 | 52559 | Melioribacter roseus P3M, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacter | Melioribacter roseus | |
| 6674671 | 6674671 | PRJNA1148190_P_NODE_517306_length_263_cov_1.568421_g506133_i0 | PRJNA1148190 | 517306 | 263 | 1.568421 | 4.12494723 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2621703982|emb|OY762937.1| | 2651163 | g506133 | i0 | 96.875 | 0.121673003802281 | 32 | 1 | 12 | 0 | 45 | 76 | 1476850 | 1476881 | MAG: Ignavibacteriaceae bacterium isolate 77385eac-16a0-46d9-9606-3f30544cc643 genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 7951004 | 7951004 | PRJNA1148190_P_NODE_605307_length_250_cov_0.870056_g594134_i0 | PRJNA1148190 | 605307 | 250 | 0.870056 | 2.17514 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 313 | 9.41e-81 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g594134 | i0 | 89.2 | 1 | 250 | 27 | 100 | 0 | 1 | 250 | 546608 | 546359 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 250 | 313 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 9226138 | 9226138 | PRJNA1148190_P_NODE_620428_length_249_cov_1.312500_g609255_i0 | PRJNA1148190 | 620428 | 249 | 1.3125 | 3.268125 | Ignavibacterium album | 591197 | Bacteria | Bacteria | 58.4 | 4.84e-4 | NTclustered | gi|383800634|gb|CP003418.1| | 945713 | g609255 | i0 | 94.595 | 0.14859437751004 | 37 | 2 | 15 | 0 | 64 | 100 | 2593119 | 2593083 | Ignavibacterium album JCM 16511, complete genome | blastn | 37 | 58.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium album | |
| 15596035 | 15596035 | PRJNA1148190_P_NODE_267673_length_334_cov_1.938697_g256502_i0 | PRJNA1148190 | 267673 | 334 | 1.938697 | 6.47524798 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 335 | 2.789999999999999e-87 | NTclustered | gi|1938792964|gb|CP054182.1| | 2049428 | g256502 | i0 | 87.762 | 0.856287425149701 | 286 | 35 | 86 | 0 | 2 | 287 | 85584 | 85299 | Ignavibacteriales bacterium isolate H2_BAC3 chromosome, complete genome | blastn | 286 | 335 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 18885374 | 18885374 | PRJNA1148190_P_NODE_127875_length_466_cov_1.567430_g116712_i0 | PRJNA1148190 | 127875 | 466 | 1.56743 | 7.3042238 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 97.1 | 2.06e-15 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g116712 | i0 | 88.095 | 4.86051502145923 | 84 | 7 | 18 | 2 | 116 | 197 | 377989 | 377907 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 2265 | 97.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 23247725 | 23247725 | PRJNA1148190_P_NODE_418519_length_283_cov_0.890476_g407346_i0 | PRJNA1148190 | 418519 | 283 | 0.890476 | 2.52004708 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 198 | 3.1699999999999993e-46 | NTclustered | gi|1958088527|gb|CP065001.1| | 2049428 | g407346 | i0 | 80.074 | 3.50883392226148 | 271 | 50 | 95 | 4 | 1 | 269 | 1381243 | 1381511 | Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome | blastn | 993 | 198 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 23252865 | 23252865 | PRJNA1148190_P_NODE_86599_length_582_cov_1.944990_g75466_i0 | PRJNA1148190 | 86599 | 582 | 1.94499 | 11.3198418 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 418 | 4.919999999999999e-112 | NTclustered | gi|2314740639|dbj|AP026678.1| | 2651167 | g75466 | i0 | 88.986 | 6.48453608247423 | 345 | 29 | 59 | 4 | 172 | 514 | 2447959 | 2447622 | MAG: Ignavibacterium sp. KatS3mg037 DNA, complete genome | blastn | 3774 | 418 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium 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);;