RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax_phylum = "Aquificota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Aquificota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA565778 · 8 ✖

analysis 1

  • diamond · 8 ✖

tax_clade 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
27110943 27110943 PRJNA565778_S_NODE_34842_length_184_cov_347.251701_g34546_i0 PRJNA565778 34842 184 347.251701 638.94312984 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 62 2.38e-9   NR MBX0310550.1 2053621 g34546 i0 75 0.782608695652174 48 12 78.3 0 181 38 121 168 MBX0310550.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 144 62 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
28974417 28974417 PRJNA565778_S_NODE_26848_length_213_cov_4.596591_g26552_i0 PRJNA565778 26848 213 4.596591 9.79073883 Aquificaceae bacterium 2053503 Bacteria Bacteria 97.1 1.02e-22   NR MCY0866857.1 2053503 g26552 i0 87.2 0.661971830985915 47 6 66.2 0 189 49 1 47 MCY0866857.1 peptidoglycan-binding protein [Aquificaceae bacterium] diamond 141 97.1 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
29163967 29163967 PRJNA565778_S_NODE_27689_length_209_cov_437.296512_g27393_i0 PRJNA565778 27689 209 437.296512 913.94971008 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 107 3.73e-26   NR MBX0310551.1 2053621 g27393 i0 96.4 0.803827751196172 56 2 80.4 0 38 205 10 65 MBX0310551.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 168 107 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
29984754 29984754 PRJNA565778_S_NODE_30611_length_198_cov_165.757764_g30315_i0 PRJNA565778 30611 198 165.757764 328.20037272 Aquificota bacterium 2202151 Bacteria Bacteria 50.4 2.1e-5   NR QWK12353.1 2202151 g30315 i0 95.5 0.333333333333333 22 1 33.3 0 38 103 149 170 QWK12353.1 MAG: hypothetical protein KNN14_05685 [Aquificota bacterium] diamond 66 50.4 1 Bacteria   Pseudomonadati Aquificota         Aquificota bacterium
30693385 30693385 PRJNA565778_S_NODE_31733_length_194_cov_104.484076_g31437_i0 PRJNA565778 31733 194 104.484076 202.69910744 Bacteria 2 Bacteria Bacteria 42.4 0.0265   NR MCY0866852.1 2053503 g31437 i0 100 0.587628865979381 19 0 29.4 0 166 110 255 273 MCY0866852.1 outer membrane protein transport protein [Aquificaceae bacterium] diamond 114 42.4 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
31198522 31198522 PRJNA565778_S_NODE_19175_length_253_cov_5.208333_g18879_i0 PRJNA565778 19175 253 5.208333 13.17708249 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 62 5.14e-9   NR MBX0310508.1 2053621 g18879 i0 100 0.735177865612648 31 0 36.8 0 93 1 1 31 MBX0310508.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 186 62 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
31958002 31958002 PRJNA565778_S_NODE_36037_length_181_cov_2.687500_g35741_i0 PRJNA565778 36037 181 2.6875 4.864375 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 109 4.16e-26   NR MBX0311688.1 2053621 g35741 i0 98.1 1.75690607734807 53 1 87.8 0 22 180 51 103 MBX0311688.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 318 109 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
32070995 32070995 PRJNA565778_S_NODE_32418_length_192_cov_5.554839_g32122_i0 PRJNA565778 32418 192 5.554839 10.66529088 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 96.7 1.7e-21   NR MBX0311688.1 2053621 g32122 i0 84.6 0.8125 52 8 81.3 0 157 2 315 366 MBX0311688.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 156 96.7 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.

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