contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3026020 | 3026020 | PRJNA494251_P_NODE_12223_length_389_cov_0.974684_g11916_i0 | PRJNA494251 | 12223 | 389 | 0.974684 | 3.79152076 | Candidatus Pacebacteria bacterium GW2011_GWB1_47_8 | 1618470 | Bacteria | Bacteria | 100 | 1.31e-16 | NTclustered | gi|1118703619|gb|KX123532.1| | 1618470 | g11916 | i0 | 82.883 | 23.9228791773779 | 111 | 19 | 29 | 0 | 99 | 209 | 767 | 657 | Candidatus Pacebacteria bacterium GW2011_GWB1_47_8 16S ribosomal RNA gene, partial sequence | blastn | 9306 | 100 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Candidatus Pacebacteria bacterium GW2011_GWB1_47_8 | ||||||
| 10679013 | 10679013 | PRJNA494251_P_NODE_34889_length_256_cov_1.803279_g34575_i0 | PRJNA494251 | 34889 | 256 | 1.803279 | 4.61639424 | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | 2933970 | Bacteria | Bacteria | 464 | 2.52e-126 | NTclustered | gi|2179907571|gb|CP090820.1| | 2933970 | g34575 | i0 | 99.606 | 239.48046875 | 254 | 1 | 99 | 0 | 3 | 256 | 138225 | 138478 | MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome | blastn | 61307 | 464 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | ||
| 12585855 | 12585855 | PRJNA494251_P_NODE_52030_length_223_cov_4.533333_g51716_i0 | PRJNA494251 | 52030 | 223 | 4.533333 | 10.10933259 | Candidatus Saccharimonadota | 95818 | Bacteria | Bacteria | 296 | 8.28e-76 | NTclustered | gi|2070586293|gb|CP076101.2| | 1917697 | g51716 | i0 | 91.705 | 159.641255605381 | 217 | 13 | 99 | 5 | 4 | 218 | 115256 | 115469 | MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome | blastn | 35600 | 298 | 0.993288590604027 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 17052784 | 17052784 | PRJNA494251_P_NODE_4074_length_623_cov_2.487273_g3784_i0 | PRJNA494251 | 4074 | 623 | 2.487273 | 15.49571079 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 348 | 7.040000000000001e-91 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g3784 | i0 | 79.487 | 20.0417335473515 | 507 | 90 | 80 | 13 | 95 | 594 | 1165738 | 1165239 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 12486 | 348 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 19601402 | 19601402 | PRJNA494251_P_NODE_44576_length_245_cov_0.895349_g44262_i0 | PRJNA494251 | 44576 | 245 | 0.895349 | 2.19360505 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 281 | 2.59e-71 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g44262 | i0 | 88.745 | 4.64081632653061 | 231 | 24 | 94 | 2 | 1 | 231 | 1252129 | 1251901 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 1137 | 281 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20877199 | 20877199 | PRJNA494251_P_NODE_38157_length_250_cov_0.870056_g37843_i0 | PRJNA494251 | 38157 | 250 | 0.870056 | 2.17514 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 137 | 6.08e-28 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g37843 | i0 | 81.25 | 1.412 | 176 | 28 | 69 | 5 | 1 | 172 | 174077 | 174251 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 353 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 |
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);;