contig_metadata
11 rows where bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9484330 | 9484330 | PRJNA565584_P_NODE_191988_length_246_cov_0.890173_g190836_i0 | PRJNA565584 | 191988 | 246 | 0.890173 | 2.18982558 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 185 | 2.1e-42 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g190836 | i0 | 80.645 | 356.487804878049 | 248 | 40 | 100 | 7 | 1 | 246 | 890690 | 890449 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 87696 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 18409938 | 18409938 | PRJNA565584_P_NODE_99135_length_300_cov_1.356828_g97983_i0 | PRJNA565584 | 99135 | 300 | 1.356828 | 4.070484 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 70.1 | 1.45e-12 | NR | MBC7498624.1 | 2044595 | g97983 | i0 | 48.7 | 3.2 | 78 | 37 | 78 | 2 | 284 | 51 | 85 | 159 | MBC7498624.1 peptidylprolyl isomerase [Candidatus Altimarinota bacterium] | diamond | 960 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 23508253 | 23508253 | PRJNA565584_P_NODE_188459_length_247_cov_0.885057_g187307_i0 | PRJNA565584 | 188459 | 247 | 0.885057 | 2.18609079 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 99.4 | 2.58e-24 | NR | NRH20457.1 | 2044595 | g187307 | i0 | 91.4 | 0.704453441295547 | 58 | 5 | 70.4 | 0 | 176 | 3 | 1 | 58 | NRH20457.1 transcription elongation factor GreA [Candidatus Altimarinota bacterium] | diamond | 174 | 99.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27743118 | 27743118 | PRJNA565584_P_NODE_56364_length_396_cov_1.241486_g55213_i0 | PRJNA565584 | 56364 | 396 | 1.241486 | 4.91628456 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 44.7 | 0.0379 | NR | MBF0913662.1 | 2044595 | g55213 | i0 | 33.3 | 0.704545454545455 | 93 | 53 | 70.5 | 3 | 394 | 116 | 231 | 314 | MBF0913662.1 23S rRNA (uracil(1939)-C(5))-methyltransferase RlmD [Candidatus Altimarinota bacterium] | diamond | 279 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29146053 | 29146053 | PRJNA565584_P_NODE_154649_length_259_cov_1.655914_g153497_i0 | PRJNA565584 | 154649 | 259 | 1.655914 | 4.28881726 | Bacteria | 2 | Bacteria | Bacteria | 83.2 | 2.65e-16 | NR | MBW7954494.1 | 2044595 | g153497 | i0 | 43.4 | 7.76061776061776 | 83 | 47 | 96.1 | 0 | 249 | 1 | 295 | 377 | MBW7954494.1 translational GTPase TypA [Candidatus Altimarinota bacterium] | diamond | 2010 | 84 | 0.990476190476191 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29699982 | 29699982 | PRJNA565584_P_NODE_213270_length_241_cov_0.916667_g212118_i0 | PRJNA565584 | 213270 | 241 | 0.916667 | 2.20916747 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 112 | 3.62e-27 | NR | MFA5948541.1 | 2044595 | g212118 | i0 | 62.5 | 0.995850622406639 | 80 | 30 | 99.6 | 0 | 2 | 241 | 334 | 413 | MFA5948541.1 adenylosuccinate synthase [Candidatus Altimarinota bacterium] | diamond | 240 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30553114 | 30553114 | PRJNA565584_P_NODE_131773_length_274_cov_1.532338_g130621_i0 | PRJNA565584 | 131773 | 274 | 1.532338 | 4.19860612 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 90.5 | 6.97e-19 | NR | MFN7160725.1 | 2044595 | g130621 | i0 | 54.9 | 5.79197080291971 | 91 | 39 | 97.4 | 1 | 6 | 272 | 132 | 222 | MFN7160725.1 ribosome biogenesis GTPase Der [Candidatus Altimarinota bacterium] | diamond | 1587 | 90.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30742941 | 30742941 | PRJNA565584_P_NODE_60234_length_383_cov_0.993548_g59083_i0 | PRJNA565584 | 60234 | 383 | 0.993548 | 3.80528884 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 47 | 0.00514 | NR | MDD2892228.1 | 2044595 | g59083 | i0 | 31.2 | 0.72845953002611 | 93 | 40 | 68.1 | 3 | 1 | 261 | 211 | 285 | MDD2892228.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 279 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30869207 | 30869207 | PRJNA565584_P_NODE_205274_length_243_cov_0.905882_g204122_i0 | PRJNA565584 | 205274 | 243 | 0.905882 | 2.20129326 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 62 | 6.25e-9 | NR | MFN7160928.1 | 2044595 | g204122 | i0 | 38.1 | 1.03703703703704 | 84 | 49 | 100 | 1 | 1 | 243 | 18 | 101 | MFN7160928.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Altimarinota bacterium] | diamond | 252 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31912711 | 31912711 | PRJNA565584_P_NODE_206137_length_243_cov_0.905882_g204985_i0 | PRJNA565584 | 206137 | 243 | 0.905882 | 2.20129326 | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_5 | 2044595 | Bacteria | Bacteria | 56.6 | 4.84e-7 | NR | PIV90421.1 | 1974580 | g204985 | i0 | 41.7 | 0.888888888888889 | 72 | 40 | 88.9 | 1 | 6 | 221 | 1303 | 1372 | PIV90421.1 MAG: hypothetical protein COW46_02850 [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13] | diamond | 216 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13 | ||||||
| 31944261 | 31944261 | PRJNA565584_P_NODE_94617_length_308_cov_1.200000_g93465_i0 | PRJNA565584 | 94617 | 308 | 1.2 | 3.696 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 45.1 | 0.0118 | NR | MCF7846628.1 | 2044595 | g93465 | i0 | 29.5 | 1.02272727272727 | 105 | 54 | 95.5 | 4 | 8 | 301 | 179 | 270 | MCF7846628.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 315 | 45.1 | 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);;