RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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

  • PRJNA1160211 · 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
15612216 15612216 PRJNA1160211_S_NODE_165813_length_353_cov_2.053571_g164580_i0 PRJNA1160211 165813 353 2.053571 7.24910563 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 198 1.44e-62   NR MBX9724270.1 2364082 g164580 i0 94 0.84985835694051 100 6 85 0 352 53 71 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 300 198 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
16887686 16887686 PRJNA1160211_S_NODE_5414_length_931_cov_12.980186_g4826_i0 PRJNA1160211 5414 931 12.980186 120.84553166 Bacillati 1783272 Bacteria Bacteria 131 2.1399999999999997e-31   NR MFA6212919.1 2364082 g4826 i0 75.9 0.763694951664876 79 19 25.5 0 931 695 290 368 MFA6212919.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 711 131 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28114166 28114166 PRJNA1160211_S_NODE_66285_length_531_cov_2.820961_g65086_i0 PRJNA1160211 66285 531 2.820961 14.97930291 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 206 3.34e-65   NR MBX9722668.1 2364082 g65086 i0 71.5 1.5819209039548 137 39 77.4 0 97 507 1 137 MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 840 206 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30482822 30482822 PRJNA1160211_S_NODE_60033_length_547_cov_10.267932_g58849_i0 PRJNA1160211 60033 547 10.267932 56.16558804 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 358 3.66e-117   NR MBX3152849.1 2364082 g58849 i0 100 0.992687385740402 181 0 99.3 0 3 545 74 254 MBX3152849.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 543 358 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30628214 30628214 PRJNA1160211_S_NODE_198793_length_312_cov_2.577406_g197560_i0 PRJNA1160211 198793 312 2.577406 8.04150672 Bacillati 1783272 Bacteria Bacteria 143 4.939999999999999e-37   NR MBX9671475.1 2364082 g197560 i0 64.1 1.98076923076923 103 36 98.1 1 306 1 195 297 MBX9671475.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 618 144 0.993055555555556 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31208988 31208988 PRJNA1160211_S_NODE_105995_length_446_cov_2.538874_g104767_i0 PRJNA1160211 105995 446 2.538874 11.32337804 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 255 8.069999999999998e-82   NR MBX3134648.1 2364082 g104767 i0 100 0.881165919282511 131 0 88.1 0 394 2 1 131 MBX3134648.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 393 255 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31683731 31683731 PRJNA1160211_S_NODE_80657_length_497_cov_3.320755_g79440_i0 PRJNA1160211 80657 497 3.320755 16.50415235 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 49.7 5.61e-5   NR MDZ4832597.1 2052166 g79440 i0 57.1 0.253521126760563 42 18 25.4 0 372 497 1 42 MDZ4832597.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 126 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria 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);;