RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA994052 · 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
7354494 7354494 PRJNA994052_P_NODE_73026_length_208_cov_1072.570370_g71770_i0 PRJNA994052 73026 208 1072.57037 2230.9463696 Oleidesulfovibrio alaskensis 58180 Bacteria Bacteria 385 1.58e-102   NTclustered gi|78217452|gb|CP000112.1| 207559 g71770 i0 100 1 208 0 100 0 1 208 3178680 3178473 Desulfovibrio alaskensis G20, complete genome blastn 208 385 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Oleidesulfovibrio Oleidesulfovibrio alaskensis
12455540 12455540 PRJNA994052_P_NODE_34510_length_270_cov_79.060914_g33266_i0 PRJNA994052 34510 270 79.060914 213.4644678 Desulfuromonas sp. DDH964 1823759 Bacteria Bacteria 97.1 1.13e-15   NTclustered gi|1015516084|gb|CP015080.1| 1823759 g33266 i0 92.537 0.462962962962963 67 5 25 0 197 263 3417744 3417810 Desulfuromonas sp. DDH964 chromosome, complete genome blastn 125 97.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. DDH964
18828281 18828281 PRJNA994052_P_NODE_45415_length_248_cov_1570.394286_g44165_i0 PRJNA994052 45415 248 1570.394286 3894.57782928 Oleidesulfovibrio alaskensis 58180 Bacteria Bacteria 459 1.13e-124   NTclustered gi|78217452|gb|CP000112.1| 207559 g44165 i0 100 4.95161290322581 248 0 100 0 1 248 2516922 2517169 Desulfovibrio alaskensis G20, complete genome blastn 1228 459 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Oleidesulfovibrio Oleidesulfovibrio alaskensis
25202724 25202724 PRJNA994052_P_NODE_54780_length_233_cov_243.775000_g53525_i0 PRJNA994052 54780 233 243.775 567.99575 Syntrophotalea acetylenivorans 1842532 Bacteria Bacteria 189 1.5199999999999996e-43   NTclustered gi|1109393802|gb|CP015519.1| 1842532 g53525 i0 81.858 255.712446351931 226 40 97 1 8 233 2834446 2834222 Syntrophotalea acetylenivorans strain SFB93 chromosome, complete genome blastn 59581 189 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Syntrophotaleaceae Syntrophotalea Syntrophotalea acetylenivorans
25202968 25202968 PRJNA994052_P_NODE_77060_length_204_cov_13.564885_g75803_i0 PRJNA994052 77060 204 13.564885 27.6723654 uncultured Desulfobacter sp. 240139 Bacteria Bacteria 174 3.64e-39   NTclustered gi|2621704716|emb|OY762069.1| 240139 g75803 i0 85.143 93.1127450980392 175 21 85 5 28 200 4511767 4511938 MAG: uncultured Desulfobacter sp. isolate 00b13672-1c6a-4f01-9bd3-5d9cfdb0d95e genome assembly, chromosome: 1 blastn 18995 174 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter uncultured Desulfobacter 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);;