contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA782551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 763631 | 763631 | PRJNA782551_P_NODE_16981_length_250_cov_0.870056_g16859_i0 | PRJNA782551 | 16981 | 250 | 0.870056 | 2.17514 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 451 | 1.91e-122 | NTclustered | gi|1663050868|gb|CP040003.1| | 713059 | g16859 | i0 | 99.2 | 13.932 | 250 | 2 | 100 | 0 | 1 | 250 | 551428 | 551677 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC001 chromosome, complete genome | blastn | 3483 | 451 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 2039580 | 2039580 | PRJNA782551_P_NODE_15922_length_251_cov_0.865169_g15800_i0 | PRJNA782551 | 15922 | 251 | 0.865169 | 2.17157419 | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | 2933970 | Bacteria | Bacteria | 464 | 2.47e-126 | NTclustered | gi|2179907571|gb|CP090820.1| | 2933970 | g15800 | i0 | 100 | 1 | 251 | 0 | 100 | 0 | 1 | 251 | 57709 | 57459 | MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome | blastn | 251 | 464 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | ||
| 3314966 | 3314966 | PRJNA782551_P_NODE_19403_length_247_cov_0.885057_g19281_i0 | PRJNA782551 | 19403 | 247 | 0.885057 | 2.18609079 | Candidatus Nanosynbacter featherlites | 2572088 | Bacteria | Bacteria | 357 | 4.22e-94 | NTclustered | gi|1663054866|gb|CP040004.1| | 2572088 | g19281 | i0 | 92.713 | 3.10931174089069 | 247 | 18 | 100 | 0 | 1 | 247 | 589925 | 590171 | Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome | blastn | 768 | 357 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter featherlites | ||
| 6316612 | 6316612 | PRJNA782551_P_NODE_8325_length_325_cov_1.222222_g8203_i0 | PRJNA782551 | 8325 | 325 | 1.222222 | 3.9722215 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 601 | 2.4199999999999993e-167 | NTclustered | gi|1842055115|gb|CP040000.1| | 713059 | g8203 | i0 | 100 | 194.310769230769 | 325 | 0 | 100 | 0 | 1 | 325 | 146408 | 146732 | Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome | blastn | 63151 | 601 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 9692037 | 9692037 | PRJNA782551_P_NODE_15588_length_251_cov_1.707865_g15466_i0 | PRJNA782551 | 15588 | 251 | 1.707865 | 4.28674115 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 453 | 5.34e-123 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g15466 | i0 | 99.203 | 19.7808764940239 | 251 | 2 | 100 | 0 | 1 | 251 | 129675 | 129425 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 4965 | 453 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 10967788 | 10967788 | PRJNA782551_P_NODE_18289_length_248_cov_1.051429_g18167_i0 | PRJNA782551 | 18289 | 248 | 1.051429 | 2.60754392 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 442 | 1.1399999999999995e-119 | NTclustered | gi|2070586293|gb|CP076101.2| | 1917697 | g18167 | i0 | 98.79 | 3.00806451612903 | 248 | 3 | 100 | 0 | 1 | 248 | 202839 | 203086 | MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome | blastn | 746 | 442 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 10967835 | 10967835 | PRJNA782551_P_NODE_21149_length_245_cov_0.895349_g21027_i0 | PRJNA782551 | 21149 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 431 | 2.4299999999999996e-116 | NTclustered | gi|1663050868|gb|CP040003.1| | 713059 | g21027 | i0 | 98.367 | 14.5918367346939 | 245 | 4 | 100 | 0 | 1 | 245 | 402499 | 402743 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC001 chromosome, complete genome | blastn | 3575 | 431 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 14792237 | 14792237 | PRJNA782551_P_NODE_18292_length_248_cov_0.880000_g18170_i0 | PRJNA782551 | 18292 | 248 | 0.88 | 2.1824 | Candidatus Nanosynbacter featherlites | 2572088 | Bacteria | Bacteria | 398 | 2.5e-106 | NTclustered | gi|1663054866|gb|CP040004.1| | 2572088 | g18170 | i0 | 95.565 | 1.35887096774194 | 248 | 11 | 100 | 0 | 1 | 248 | 435350 | 435103 | Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome | blastn | 337 | 398 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter featherlites | ||
| 14792339 | 14792339 | PRJNA782551_P_NODE_24472_length_241_cov_0.916667_g24350_i0 | PRJNA782551 | 24472 | 241 | 0.916667 | 2.20916747 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 99 | 2.75e-16 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g24350 | i0 | 86.813 | 0.377593360995851 | 91 | 9 | 37 | 3 | 152 | 241 | 132022 | 132110 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 91 | 99 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 17341851 | 17341851 | PRJNA782551_P_NODE_16774_length_250_cov_0.870056_g16652_i0 | PRJNA782551 | 16774 | 250 | 0.870056 | 2.17514 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 412 | 9.02e-111 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g16652 | i0 | 96.4 | 1 | 250 | 9 | 100 | 0 | 1 | 250 | 136854 | 136605 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 250 | 412 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 |
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);;