RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA446034", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 5 ✖

tax_kingdom 1

  • Pseudomonadati · 5 ✖

bioproject 1

  • PRJNA446034 · 5 ✖

analysis 1

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
28939358 28939358 PRJNA446034_S_NODE_53808_length_180_cov_4.937063_g53771_i0 PRJNA446034 53808 180 4.937063 8.8867134 uncultured Bilophila sp. 529385 Bacteria Bacteria 96.7 4.6099999999999997e-23   NR WP_300686435.1 529385 g53771 i0 72.9 0.983333333333333 59 16 98.3 0 178 2 146 204 WP_300686435.1 flavodoxin [uncultured Bilophila sp.] diamond 177 96.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila uncultured Bilophila sp.
29002844 29002844 PRJNA446034_S_NODE_87988_length_160_cov_3.373984_g87951_i0 PRJNA446034 87988 160 3.373984 5.3983744 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 59.7 4.24e-9   NR HSG31782.1 2202153 g87951 i0 53.8 0.975 52 24 97.5 0 4 159 43 94 HSG31782.1 baseplate wedge protein 53 [Thermodesulfobacteriota bacterium] diamond 156 59.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30597671 30597671 PRJNA446034_S_NODE_1293_length_426_cov_3.051414_g1256_i0 PRJNA446034 1293 426 3.051414 12.99902364 Bacteria 2 Bacteria Bacteria 246 1.51e-75   NR WP_209818418.1 876 g1256 i0 84.1 20.5140845070423 132 21 93 0 29 424 501 632 WP_209818418.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [Desulfovibrio desulfuricans] diamond 8739 248 0.991935483870968 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
31403390 31403390 PRJNA446034_S_NODE_115216_length_150_cov_2.575221_g115179_i0 PRJNA446034 115216 150 2.575221 3.8628315 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 64.7 1.66e-10   NR HSG32051.1 2202153 g115179 i0 61.5 4.6 39 15 78 0 149 33 203 241 HSG32051.1 metallophosphoesterase [Thermodesulfobacteriota bacterium] diamond 690 64.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
32020607 32020607 PRJNA446034_S_NODE_36898_length_197_cov_2.187500_g36861_i0 PRJNA446034 36898 197 2.1875 4.309375 Pseudomonadati 3379134 Bacteria Bacteria 114 1.5600000000000002e-27   NR WP_209818418.1 876 g36861 i0 82.8 4.87309644670051 64 11 97.5 0 195 4 160 223 WP_209818418.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [Desulfovibrio desulfuricans] diamond 960 114 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans

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