contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13224965 | 13224965 | PRJNA493827_P_NODE_178231_length_255_cov_2.472527_g176033_i0 | PRJNA493827 | 178231 | 255 | 2.472527 | 6.30494385 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 145 | 3.7199999999999995e-30 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g176033 | i0 | 81.215 | 0.709803921568627 | 181 | 32 | 71 | 2 | 73 | 252 | 50187 | 50008 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 181 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 13225375 | 13225375 | PRJNA493827_P_NODE_197071_length_248_cov_1.828571_g194873_i0 | PRJNA493827 | 197071 | 248 | 1.828571 | 4.53485608 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 329 | 9.249999999999998e-86 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g194873 | i0 | 91.667 | 116.306451612903 | 240 | 17 | 96 | 3 | 11 | 248 | 1249223 | 1249461 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 28844 | 329 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 13227450 | 13227450 | PRJNA493827_P_NODE_67871_length_423_cov_0.745714_g65674_i0 | PRJNA493827 | 67871 | 423 | 0.745714 | 3.15437022 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 167 | 1.39e-36 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g65674 | i0 | 86.364 | 0.364066193853428 | 154 | 19 | 36 | 2 | 265 | 418 | 30681 | 30832 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 154 | 167 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20871318 | 20871318 | PRJNA493827_P_NODE_104397_length_335_cov_1.175573_g102199_i0 | PRJNA493827 | 104397 | 335 | 1.175573 | 3.93816955 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 233 | 1.0499999999999998e-56 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g102199 | i0 | 82.27 | 0.841791044776119 | 282 | 38 | 83 | 10 | 1 | 277 | 89599 | 89325 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 282 | 233 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 24699761 | 24699761 | PRJNA493827_P_NODE_74160_length_402_cov_1.574468_g71962_i0 | PRJNA493827 | 74160 | 402 | 1.574468 | 6.32936136 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 198 | 4.679999999999999e-46 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g71962 | i0 | 76.341 | 2.6592039800995 | 410 | 74 | 99 | 20 | 7 | 402 | 855397 | 855797 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 1069 | 198 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 24700236 | 24700236 | PRJNA493827_P_NODE_94380_length_353_cov_1.389286_g92182_i0 | PRJNA493827 | 94380 | 353 | 1.389286 | 4.90417958 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 198 | 4.05e-46 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g92182 | i0 | 77.374 | 1.01416430594901 | 358 | 65 | 98 | 11 | 3 | 349 | 118140 | 118492 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 358 | 198 | 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);;