RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA804229", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 5 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA804229 · 5 ✖

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
3352479 3352479 PRJNA804229_S_NODE_109223_length_195_cov_1.263158_g108265_i0 PRJNA804229 109223 195 1.263158 2.4631581 Geoalkalibacter subterraneus 483547 Bacteria Bacteria 309 9.06e-80   NTclustered gi|749207097|gb|CP010311.1| 483547 g108265 i0 97.765 7.35384615384615 179 4 92 0 1 179 2202157 2202335 Geoalkalibacter subterraneus strain Red1, complete genome blastn 1434 309 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geoalkalibacteraceae Geoalkalibacter Geoalkalibacter subterraneus
8454443 8454443 PRJNA804229_S_NODE_105567_length_198_cov_1.890323_g104609_i0 PRJNA804229 105567 198 1.890323 3.74283954 Desulfobulbus oligotrophicus 1909699 Bacteria Bacteria 268 1.5699999999999998e-67   NTclustered gi|1951276582|gb|CP054140.1| 1909699 g104609 i0 94.798 12.5151515151515 173 8 87 1 1 173 639826 639655 Desulfobulbus oligotrophicus strain Prop6 chromosome, complete genome blastn 2478 268 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus oligotrophicus
19073786 19073786 PRJNA804229_S_NODE_85315_length_220_cov_2.378531_g84357_i0 PRJNA804229 85315 220 2.378531 5.2327682 Thermodesulfobacteriota 200940 Bacteria Bacteria 379 7.869999999999999e-101   NTclustered gi|78217452|gb|CP000112.1| 207559 g84357 i0 97.727 18.0181818181818 220 5 100 0 1 220 1968409 1968628 Desulfovibrio alaskensis G20, complete genome blastn 3964 379 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Oleidesulfovibrio Oleidesulfovibrio alaskensis
22482167 22482167 PRJNA804229_S_NODE_83058_length_223_cov_2.133333_g82100_i0 PRJNA804229 83058 223 2.133333 4.75733259 Solidesulfovibrio carbinolicus 296842 Bacteria Bacteria 401 1.7099999999999992e-107   NTclustered gi|1566432249|gb|CP026538.1| 296842 g82100 i0 99.103 25.4394618834081 223 2 100 0 1 223 1390116 1390338 Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome blastn 5673 401 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Solidesulfovibrio Solidesulfovibrio carbinolicus
29359500 29359500 PRJNA804229_S_NODE_154149_length_164_cov_1.586777_g153191_i0 PRJNA804229 154149 164 1.586777 2.60231428 Desulfarculus sp. 2093367 Bacteria Bacteria 41.2 0.0449   NR MBI4799901.1 2093367 g153191 i0 45.7 0.640243902439024 35 19 64 0 28 132 257 291 MBI4799901.1 methyltransferase domain-containing protein [Desulfarculus sp.] diamond 105 41.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae Desulfarculus Desulfarculus 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);;