RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1005695" 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

bioproject 1

  • PRJNA1005695 · 5 ✖

analysis 1

  • blastn · 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
6104334 6104334 PRJNA1005695_P_NODE_39865_length_242_cov_1.775148_g39013_i0 PRJNA1005695 39865 242 1.775148 4.29585816 Pseudomonadati 3379134 Bacteria Bacteria 254 5.57e-63   NTclustered gi|2893358418|emb|OZ220710.1| 2202153 g39013 i0 86.325 645.111570247934 234 31 97 1 1 234 2289401 2289633 MAG: Thermodesulfobacteriota bacterium isolate dce1034a-8f23-488c-aa07-39e6c80a0035 genome assembly, chromosome: 1 blastn 156117 254 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
6531711 6531711 PRJNA1005695_P_NODE_30846_length_269_cov_0.943878_g29994_i0 PRJNA1005695 30846 269 0.943878 2.53903182 Geopsychrobacteraceae bacterium 3065857 Bacteria Bacteria 150 8.489999999999998e-32   NTclustered gi|2621703259|emb|OY762430.1| 3065857 g29994 i0 78.067 93.4386617100372 269 38 98 13 6 269 5392 5140 MAG: Geopsychrobacteraceae bacterium isolate 31ebb314-3b6f-4c34-9fd3-1c731cc0fcc3 genome assembly, chromosome: 1 blastn 25135 150 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae   Geopsychrobacteraceae bacterium
10356688 10356688 PRJNA1005695_P_NODE_29329_length_276_cov_1.399015_g28477_i0 PRJNA1005695 29329 276 1.399015 3.8612814 Thermodesulfomicrobium sp. WS 3004129 Bacteria Bacteria 54.7 0.007   NTclustered gi|2416254156|dbj|AP027130.1| 3004129 g28477 i0 100 0.105072463768116 29 0 11 0 75 103 2120417 2120445 Thermodesulfomicrobium sp. WS DNA, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Thermodesulfomicrobium Thermodesulfomicrobium sp. WS
14182080 14182080 PRJNA1005695_P_NODE_12252_length_440_cov_5.297003_g11400_i0 PRJNA1005695 12252 440 5.297003 23.3068132 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 612 1.56e-170   NTclustered gi|2575803239|emb|OY729416.1| 2202153 g11400 i0 91.837 198.170454545455 441 33 100 3 1 440 75911 76349 MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 blastn 87195 612 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
23105903 23105903 PRJNA1005695_P_NODE_42679_length_197_cov_6.193548_g41827_i0 PRJNA1005695 42679 197 6.193548 12.20128956 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 228 2.6399999999999995e-55   NTclustered gi|2575803239|emb|OY729416.1| 2202153 g41827 i0 90.698 148.086294416244 172 14 87 2 26 197 75734 75903 MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 blastn 29173 228 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota 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);;