contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601695 | 601695 | PRJNA630162_P_NODE_141721_length_166_cov_2.299145_g140198_i0 | PRJNA630162 | 141721 | 166 | 2.299145 | 3.8165807 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 135 | 1.34e-27 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g140198 | i0 | 84.672 | 128.831325301205 | 137 | 20 | 82 | 1 | 6 | 141 | 1251496 | 1251360 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 21386 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 602527 | 602527 | PRJNA630162_P_NODE_68621_length_214_cov_1.157576_g67098_i0 | PRJNA630162 | 68621 | 214 | 1.157576 | 2.47721264 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 130 | 8.47e-26 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g67098 | i0 | 80.663 | 23.8084112149533 | 181 | 23 | 84 | 9 | 2 | 181 | 1250187 | 1250356 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 5095 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 6980739 | 6980739 | PRJNA630162_P_NODE_36566_length_295_cov_466.243902_g35043_i0 | PRJNA630162 | 36566 | 295 | 466.243902 | 1375.4195109 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 372 | 1.8499999999999998e-98 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g35043 | i0 | 89.865 | 347.698305084746 | 296 | 20 | 99 | 8 | 1 | 291 | 1251395 | 1251685 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 102571 | 372 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 12082089 | 12082089 | PRJNA630162_P_NODE_79150_length_202_cov_2.274510_g77627_i0 | PRJNA630162 | 79150 | 202 | 2.27451 | 4.5945102 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 307 | 3.4e-79 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g77627 | i0 | 94.089 | 93.7178217821782 | 203 | 11 | 100 | 1 | 1 | 202 | 1249666 | 1249868 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 18931 | 307 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 12630322 | 12630322 | PRJNA630162_P_NODE_14990_length_487_cov_2.287671_g13498_i0 | PRJNA630162 | 14990 | 487 | 2.287671 | 11.14095777 | Bacteria | 2 | Bacteria | Bacteria | 163 | 2.1e-35 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g13498 | i0 | 89.764 | 1.18275154004107 | 127 | 13 | 26 | 0 | 10 | 136 | 1250825 | 1250699 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 576 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 18454818 | 18454818 | PRJNA630162_P_NODE_88515_length_193_cov_1.361111_g86992_i0 | PRJNA630162 | 88515 | 193 | 1.361111 | 2.62694423 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 231 | 1.9900000000000002e-56 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g86992 | i0 | 88.265 | 5.61658031088083 | 196 | 20 | 100 | 2 | 1 | 193 | 1250587 | 1250392 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 1084 | 231 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 21004526 | 21004526 | PRJNA630162_P_NODE_25917_length_358_cov_7.957929_g24396_i0 | PRJNA630162 | 25917 | 358 | 7.957929 | 28.48938582 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 390 | 6.33e-104 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g24396 | i0 | 86.895 | 249.667597765363 | 351 | 42 | 98 | 3 | 1 | 351 | 890475 | 890129 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 89381 | 390 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 21553382 | 21553382 | PRJNA630162_P_NODE_38957_length_285_cov_5.296610_g37434_i0 | PRJNA630162 | 38957 | 285 | 5.29661 | 15.0953385 | Bacteria | 2 | Bacteria | Bacteria | 202 | 2.4699999999999997e-47 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g37434 | i0 | 85.024 | 76.7508771929825 | 207 | 22 | 71 | 8 | 78 | 280 | 1249343 | 1249544 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 21874 | 202 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 23554811 | 23554811 | PRJNA630162_P_NODE_36359_length_296_cov_8.728745_g34836_i0 | PRJNA630162 | 36359 | 296 | 8.728745 | 25.8370852 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 169 | 2.62e-37 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g34836 | i0 | 89.552 | 2.70608108108108 | 134 | 13 | 45 | 1 | 138 | 271 | 1250498 | 1250366 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 801 | 169 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 23555335 | 23555335 | PRJNA630162_P_NODE_87179_length_194_cov_1.524138_g85656_i0 | PRJNA630162 | 87179 | 194 | 1.524138 | 2.95682772 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 110 | 9.8e-20 | NTclustered | gi|2621704339|emb|OY760935.1| | 2044595 | g85656 | i0 | 85.047 | 20.7113402061856 | 107 | 16 | 55 | 0 | 6 | 112 | 1136610 | 1136716 | MAG: Candidatus Gracilibacteria bacterium isolate 3c0776cb-dd52-49a3-965b-30fb91b92491 genome assembly, chromosome: 1 | blastn | 4018 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;