RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1022139" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1022139 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
161505 161505 PRJNA1022139_P_NODE_12201_length_385_cov_1.727564_g12096_i0 PRJNA1022139 12201 385 1.727564 6.6511214 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 199 1.12e-62   NR MBX9724270.1 2364082 g12096 i0 91.6 1.66753246753247 107 9 83.4 0 384 64 64 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 642 199 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
2278735 2278735 PRJNA1022139_P_NODE_2522_length_777_cov_1.740057_g2434_i0 PRJNA1022139 2522 777 1.740057 13.52024289 Bacillati 1783272 Bacteria Bacteria 269 9.92e-87   NR MDR3612005.1 2364082 g2434 i0 53.1 5.8030888030888 245 114 94.2 1 3 734 10 254 MDR3612005.1 acetoacetate decarboxylase [Candidatus Obscuribacterales bacterium] diamond 4509 269 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27817028 27817028 PRJNA1022139_P_NODE_38304_length_246_cov_2.780347_g38199_i0 PRJNA1022139 38304 246 2.780347 6.83965362 Bacillati 1783272 Bacteria Bacteria 97.8 6.94e-23   NR MBI3590799.1 2052166 g38199 i0 57.1 7.67073170731707 77 33 93.9 0 244 14 123 199 MBI3590799.1 SDR family oxidoreductase [Candidatus Melainabacteria bacterium] diamond 1887 97.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
27951041 27951041 PRJNA1022139_P_NODE_36945_length_248_cov_0.880000_g36840_i0 PRJNA1022139 36945 248 0.88 2.1824 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 140 5.22e-40   NR MBX9771135.1 2364082 g36840 i0 84.1 0.991935483870968 82 13 99.2 0 2 247 93 174 MBX9771135.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 246 140 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28077183 28077183 PRJNA1022139_P_NODE_41885_length_242_cov_0.911243_g41780_i0 PRJNA1022139 41885 242 0.911243 2.20520806 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 49.7 7.95e-6   NR MBX9771134.1 2364082 g41780 i0 66.7 0.446280991735537 36 11 44.6 1 240 133 28 62 MBX9771134.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 108 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30824786 30824786 PRJNA1022139_P_NODE_20974_length_306_cov_1.261803_g20869_i0 PRJNA1022139 20974 306 1.261803 3.86111718 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 45.1 0.0068   NR MBL0187007.1 2711154 g20869 i0 38.3 1.17647058823529 60 37 58.8 0 114 293 52 111 MBL0187007.1 N-acetyltransferase [Candidatus Obscuribacter sp.] diamond 360 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
31298826 31298826 PRJNA1022139_P_NODE_29055_length_270_cov_1.563452_g28950_i0 PRJNA1022139 29055 270 1.563452 4.2213204 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 46.6 0.00235   NR HEY9786590.1 2364082 g28950 i0 48.8 0.477777777777778 43 22 47.8 0 1 129 729 771 HEY9786590.1 protein kinase [Candidatus Obscuribacterales bacterium] diamond 129 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales 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);;