contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA782235" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 763426 | 763426 | PRJNA782235_P_NODE_27821_length_241_cov_0.916667_g27632_i0 | PRJNA782235 | 27821 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 318 | 1.94e-82 | NTclustered | gi|2890901196|gb|CP128407.1| | 713059 | g27632 | i0 | 90.456 | 8.99585062240664 | 241 | 23 | 100 | 0 | 1 | 241 | 795017 | 795257 | Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome | blastn | 2168 | 318 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 3314594 | 3314594 | PRJNA782235_P_NODE_19363_length_249_cov_0.875000_g19174_i0 | PRJNA782235 | 19363 | 249 | 0.875 | 2.17875 | Candidatus Nanosynbacter sp. HMT-352 | 2899133 | Bacteria | Bacteria | 412 | 8.97e-111 | NTclustered | gi|2218410560|gb|CP089288.1| | 2899133 | g19174 | i0 | 96.761 | 6.79919678714859 | 247 | 8 | 99 | 0 | 3 | 249 | 502868 | 503114 | Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome | blastn | 1693 | 412 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-352 | ||
| 7141918 | 7141918 | PRJNA782235_P_NODE_26526_length_242_cov_0.911243_g26337_i0 | PRJNA782235 | 26526 | 242 | 0.911243 | 2.20520806 | Candidatus Sumerlaea chitinivorans | 2250252 | Bacteria | Bacteria | 259 | 1.2e-64 | NTclustered | gi|1419285073|gb|CP030759.1| | 2250252 | g26337 | i0 | 86.364 | 246.181818181818 | 242 | 27 | 99 | 5 | 1 | 239 | 161006 | 161244 | Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome | blastn | 59576 | 259 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaea | Candidatus Sumerlaea chitinivorans | ||
| 7141922 | 7141922 | PRJNA782235_P_NODE_26686_length_242_cov_0.911243_g26497_i0 | PRJNA782235 | 26686 | 242 | 0.911243 | 2.20520806 | Candidatus Nanosynbacter sp. TM7-074 | 3158573 | Bacteria | Bacteria | 209 | 1.22e-49 | NTclustered | gi|2781952016|gb|CP158487.1| | 3158573 | g26497 | i0 | 82.231 | 1 | 242 | 43 | 100 | 0 | 1 | 242 | 597821 | 598062 | Candidatus Nanosynbacter sp. TM7-074 chromosome, complete genome | blastn | 242 | 209 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. TM7-074 | ||
| 10967571 | 10967571 | PRJNA782235_P_NODE_28369_length_241_cov_0.916667_g28180_i0 | PRJNA782235 | 28369 | 241 | 0.916667 | 2.20916747 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 390 | 4.05e-104 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g28180 | i0 | 95.851 | 2 | 241 | 10 | 100 | 0 | 1 | 241 | 291599 | 291839 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 482 | 390 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 13517188 | 13517188 | PRJNA782235_P_NODE_24531_length_244_cov_0.900585_g24342_i0 | PRJNA782235 | 24531 | 244 | 0.900585 | 2.1974274 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 379 | 8.889999999999998e-101 | NTclustered | gi|2070586293|gb|CP076101.2| | 1917697 | g24342 | i0 | 94.672 | 1 | 244 | 13 | 100 | 0 | 1 | 244 | 89294 | 89051 | MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome | blastn | 244 | 379 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 14791984 | 14791984 | PRJNA782235_P_NODE_24132_length_244_cov_1.801170_g23943_i0 | PRJNA782235 | 24132 | 244 | 1.80117 | 4.3948548 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 368 | 1.92e-97 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g23943 | i0 | 93.852 | 2 | 244 | 15 | 100 | 0 | 1 | 244 | 546849 | 546606 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 488 | 368 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 16065729 | 16065729 | PRJNA782235_P_NODE_16213_length_251_cov_0.865169_g16024_i0 | PRJNA782235 | 16213 | 251 | 0.865169 | 2.17157419 | Candidatus Southlakia epibionticum | 3043284 | Bacteria | Bacteria | 457 | 4.13e-124 | NTclustered | gi|2516687873|gb|CP124550.1| | 3043284 | g16024 | i0 | 99.602 | 1 | 251 | 0 | 100 | 1 | 1 | 251 | 792660 | 792909 | Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome | blastn | 251 | 457 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Southlakia | Candidatus Southlakia epibionticum | ||
| 17341512 | 17341512 | PRJNA782235_P_NODE_17934_length_250_cov_0.870056_g17745_i0 | PRJNA782235 | 17934 | 250 | 0.870056 | 2.17514 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 361 | 3.31e-95 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g17745 | i0 | 93.089 | 4.116 | 246 | 17 | 98 | 0 | 5 | 250 | 53600 | 53845 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 1029 | 361 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 21165923 | 21165923 | PRJNA782235_P_NODE_21297_length_247_cov_0.885057_g21108_i0 | PRJNA782235 | 21297 | 247 | 0.885057 | 2.18609079 | TM7 phylum sp. oral taxon 349 | 713051 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g21108 | i0 | 100 | 1.9919028340081 | 247 | 0 | 100 | 0 | 1 | 247 | 329001 | 328755 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 492 | 457 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 |
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);;