RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358009 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
10602026 10602026 PRJNA358009_P_NODE_18269_length_152_cov_4.475728_g18200_i0 PRJNA358009 18269 152 4.475728 6.80310656 Desulfuromonadales bacterium 2099678 Bacteria Bacteria 87 1.93e-19   NR HKL27281.1 2099678 g18200 i0 79.2 1.91447368421053 48 10 94.7 0 8 151 8 55 HKL27281.1 DUF4214 domain-containing protein [Desulfuromonadales bacterium] diamond 291 87 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales     Desulfuromonadales bacterium
18249925 18249925 PRJNA358009_P_NODE_18635_length_150_cov_6.465347_g18566_i0 PRJNA358009 18635 150 6.465347 9.6980205 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 87.8 1.27e-18   NR MCF8030190.1 2683721 g18566 i0 93.5 0.92 46 3 92 0 6 143 404 449 MCF8030190.1 sigma 54-interacting transcriptional regulator [Desulfohalobiaceae bacterium] diamond 138 87.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
28117011 28117011 PRJNA358009_P_NODE_13385_length_166_cov_3.076923_g13316_i0 PRJNA358009 13385 166 3.076923 5.10769218 Desulfonatronovibrionaceae bacterium 3107345 Bacteria Bacteria 92 5.7e-20   NR MFP4657789.1 3107345 g13316 i0 85.7 0.885542168674699 49 7 88.6 0 153 7 270 318 MFP4657789.1 insulinase family protein [Desulfonatronovibrionaceae bacterium] diamond 147 92 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronovibrionaceae   Desulfonatronovibrionaceae bacterium
31686634 31686634 PRJNA358009_P_NODE_9597_length_185_cov_2.426471_g9528_i0 PRJNA358009 9597 185 2.426471 4.48897135 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 119 9.5e-31   NR MEF8822701.1 2683721 g9528 i0 98.3 0.940540540540541 58 1 94.1 0 179 6 5 62 MEF8822701.1 ribonuclease Z [Desulfohalobiaceae bacterium] diamond 174 119 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
32129836 32129836 PRJNA358009_P_NODE_11078_length_176_cov_2.795276_g11009_i0 PRJNA358009 11078 176 2.795276 4.91968576 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 48.5 1.38e-4   NR MBQ4133630.1 2049043 g11009 i0 43.2 0.75 44 25 75 0 18 149 384 427 MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium] diamond 132 48.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
32193015 32193015 PRJNA358009_P_NODE_15038_length_163_cov_2.350877_g14969_i0 PRJNA358009 15038 163 2.350877 3.83192951 Pelobacter propionicus 29543 Bacteria Bacteria 42.4 0.0174   NR WP_011735193.1 29543 g14969 i0 41.5 0.975460122699387 53 28 92 1 11 160 287 339 WP_011735193.1 radical SAM/SPASM domain-containing protein [Pelobacter propionicus] diamond 159 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus

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