RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Altimarinota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Altimarinota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_kingdom 0

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
15904365 15904365 PRJNA630162_P_NODE_114253_length_177_cov_2.351562_g112730_i0 PRJNA630162 114253 177 2.351562 4.16226474 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 115 2.36e-28   NR MBX9808915.1 2044595 g112730 i0 100 3.84745762711864 57 0 96.6 0 6 176 159 215 MBX9808915.1 molecular chaperone DnaK [Candidatus Altimarinota bacterium] diamond 681 115 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
27302215 27302215 PRJNA630162_P_NODE_88883_length_192_cov_3.195804_g87360_i0 PRJNA630162 88883 192 3.195804 6.13594368 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 65.9 1.52e-11   NR MBX9808780.1 2044595 g87360 i0 81.6 0.59375 38 7 59.4 0 77 190 1 38 MBX9808780.1 50S ribosomal protein L15 [Candidatus Altimarinota bacterium] diamond 114 65.9 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
29133517 29133517 PRJNA630162_P_NODE_141209_length_166_cov_3.786325_g139686_i0 PRJNA630162 141209 166 3.786325 6.2852995 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 41.2 0.0469   NR MDD5213827.1 2044595 g139686 i0 90.5 0.379518072289157 21 2 38 0 104 166 210 230 MDD5213827.1 NADP-dependent malic enzyme [Candidatus Altimarinota bacterium] diamond 63 41.2 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
29354510 29354510 PRJNA630162_P_NODE_160929_length_162_cov_0.920354_g159406_i0 PRJNA630162 160929 162 0.920354 1.49097348 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 89.4 4.21e-19   NR MCF7843868.1 2044595 g159406 i0 75 0.962962962962963 52 13 96.3 0 157 2 40 91 MCF7843868.1 hypothetical protein [Candidatus Altimarinota bacterium] diamond 156 89.4 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
30491523 30491523 PRJNA630162_P_NODE_163193_length_161_cov_2.116071_g161670_i0 PRJNA630162 163193 161 2.116071 3.40687431 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 50.4 2.34e-5   NR MDD5377176.1 2044595 g161670 i0 88 0.46583850931677 25 3 46.6 0 11 85 2759 2783 MDD5377176.1 Ig-like domain-containing protein [Candidatus Altimarinota bacterium] diamond 75 50.4 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
31850657 31850657 PRJNA630162_P_NODE_159777_length_162_cov_1.442478_g158254_i0 PRJNA630162 159777 162 1.442478 2.33681436 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 74.7 6.45e-14   NR MCD5375397.1 2044595 g158254 i0 97.2 10.6666666666667 36 1 66.7 0 112 5 3 38 MCD5375397.1 molecular chaperone DnaK [Candidatus Altimarinota bacterium] diamond 1728 74.7 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;