RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA564013 · 6 ✖

analysis 1

  • blastn · 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
2408049 2408049 PRJNA564013_P_NODE_31342_length_680_cov_17.754443_g28755_i0 PRJNA564013 31342 680 17.754443 120.7302124 Nitratidesulfovibrio 2802295 Bacteria Bacteria 248 8.06e-61   NTclustered gi|46451220|gb|AE017285.1| 882 g28755 i0 85.892 2.23676470588235 241 24 35 5 433 672 2106396 2106165 Desulfovibrio vulgaris subsp. vulgaris str. Hildenborough, complete genome blastn 1521 248 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio vulgaris
3682841 3682841 PRJNA564013_P_NODE_126003_length_375_cov_25.984076_g123157_i0 PRJNA564013 126003 375 25.984076 97.440285 root 1 Root_unresolved Root_unresolved 52.8 0.036   NTclustered gi|2893358420|emb|OZ220712.1| 2202153 g123157 i0 100 0.149333333333333 28 0 7 0 324 351 4487328 4487355 MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1 blastn 56 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
12032380 12032380 PRJNA564013_P_NODE_98470_length_412_cov_24.749288_g95636_i0 PRJNA564013 98470 412 24.749288 101.96706656 Desulfovibrio aminophilus 81425 Bacteria Bacteria 178 6.26e-40   NTclustered gi|2908463109|gb|CP168306.1| 81425 g95636 i0 88 1.96359223300971 150 18 36 0 30 179 3200290 3200141 MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome blastn 809 178 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio aminophilus
13306712 13306712 PRJNA564013_P_NODE_65691_length_496_cov_14.098851_g62888_i0 PRJNA564013 65691 496 14.098851 69.93030096 Thermodesulfomicrobium sp. WS 3004129 Bacteria Bacteria 224 9.7e-54   NTclustered gi|2416254156|dbj|AP027130.1| 3004129 g62888 i0 92.903 0.637096774193548 155 10 31 1 127 281 1879034 1879187 Thermodesulfomicrobium sp. WS DNA, complete genome blastn 316 224 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Thermodesulfomicrobium Thermodesulfomicrobium sp. WS
18399191 18399191 PRJNA564013_P_NODE_138615_length_362_cov_9.205980_g135767_i0 PRJNA564013 138615 362 9.20598 33.3256476 Thiovibrio sp. Mzg5 2715680 Bacteria Bacteria 233 1.14e-56   NTclustered gi|2883226761|dbj|AP022872.1| 2715680 g135767 i0 84.615 0.646408839779006 234 36 65 0 114 347 2742237 2742470 Desulfobulbaceae bacterium Mzg5 DNA, complete genome blastn 234 233 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Thiovibrionaceae Thiovibrio Thiovibrio sp. Mzg5
24774518 24774518 PRJNA564013_P_NODE_177120_length_327_cov_7.560150_g174270_i0 PRJNA564013 177120 327 7.56015 24.7216905 Thermodesulfomicrobium sp. WS 3004129 Bacteria Bacteria 348 3.5e-91   NTclustered gi|2416254156|dbj|AP027130.1| 3004129 g174270 i0 88.85 0.877675840978593 287 26 86 1 22 302 2322196 2322482 Thermodesulfomicrobium sp. WS DNA, complete genome blastn 287 348 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Thermodesulfomicrobium Thermodesulfomicrobium sp. WS

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