RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA724039" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA724039 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
4539606 4539606 PRJNA724039_S_NODE_5544_length_294_cov_12.101167_g5337_i0 PRJNA724039 5544 294 12.101167 35.57743098 Desulfobacter sp. 2294 Bacteria Bacteria 145 4.3699999999999995e-30   NTclustered gi|2447547639|gb|CP054838.1| 2294 g5337 i0 89.076 70.1904761904762 119 9 40 2 56 172 385552 385436 MAG: Desulfobacter sp. isolate Buss2-1 chromosome, complete genome blastn 20636 145 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter Desulfobacter sp.
8364319 8364319 PRJNA724039_S_NODE_10027_length_205_cov_4.220238_g9820_i0 PRJNA724039 10027 205 4.220238 8.6514879 uncultured Desulfospira sp. 232702 Bacteria Bacteria 132 2.24e-26   NTclustered gi|2621702176|emb|OY760175.1| 232702 g9820 i0 83.333 169.326829268293 144 22 70 1 58 201 1026395 1026536 MAG: uncultured Desulfospira sp. isolate 271fe3a7-c87a-42bf-b72a-f39fa9e244f5 genome assembly, chromosome: 1 blastn 34712 132 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfospira uncultured Desulfospira sp.
18562809 18562809 PRJNA724039_S_NODE_12335_length_183_cov_1.452055_g12128_i0 PRJNA724039 12335 183 1.452055 2.65726065 Desulfobacterales bacterium 2044940 Bacteria Bacteria 150 5.37e-32   NTclustered gi|2621701778|emb|OY759308.1| 2044940 g12128 i0 82.386 93.7377049180328 176 27 95 3 8 180 1936036 1936210 MAG: Desulfobacterales bacterium isolate 4b48c405-a8b0-44ce-a896-9916d3c4254b genome assembly, chromosome: 1 blastn 17154 150 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
19045991 19045991 PRJNA724039_S_NODE_7475_length_244_cov_5.009662_g7268_i0 PRJNA724039 7475 244 5.009662 12.22357528 Pseudomonadati 3379134 Bacteria Bacteria 248 2.6199999999999997e-61   NTclustered gi|2891482193|emb|OZ219926.1| 2202153 g7268 i0 85.306 159.676229508197 245 31 99 5 2 242 775581 775824 MAG: Thermodesulfobacteriota bacterium isolate 21442c6b-cc68-4f82-8039-a5361455a999 genome assembly, chromosome: 3 blastn 38961 248 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
19838044 19838044 PRJNA724039_S_NODE_16156_length_158_cov_4.388430_g15949_i0 PRJNA724039 16156 158 4.38843 6.9337194 uncultured Desulfuromonas sp. 181013 Bacteria Bacteria 132 1.63e-26   NTclustered gi|2621704006|emb|OY762961.1| 181013 g15949 i0 83.673 2.06962025316456 147 16 91 7 1 143 318430 318572 MAG: uncultured Desulfuromonas sp. isolate cad01da2-5f99-43ef-8b90-e7e0a75d6a39 genome assembly, chromosome: 1 blastn 327 132 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas uncultured Desulfuromonas sp.
20320596 20320596 PRJNA724039_S_NODE_17796_length_151_cov_2.798246_g17589_i0 PRJNA724039 17796 151 2.798246 4.22535146 Pseudomonadati 3379134 Bacteria Bacteria 226 6.859999999999999e-55   NTclustered gi|2891482193|emb|OZ219926.1| 2202153 g17589 i0 94.521 215.211920529801 146 8 97 0 1 146 774317 774172 MAG: Thermodesulfobacteriota bacterium isolate 21442c6b-cc68-4f82-8039-a5361455a999 genome assembly, chromosome: 3 blastn 32497 226 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
24937800 24937800 PRJNA724039_S_NODE_9120_length_216_cov_7.675978_g8913_i0 PRJNA724039 9120 216 7.675978 16.58011248 Thiovibrio sp. Mzg5 2715680 Bacteria Bacteria 150 6.57e-32   NTclustered gi|2883226761|dbj|AP022872.1| 2715680 g8913 i0 84.076 59.8148148148148 157 23 72 2 1 155 640458 640614 Desulfobulbaceae bacterium Mzg5 DNA, complete genome blastn 12920 150 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Thiovibrionaceae Thiovibrio Thiovibrio sp. Mzg5

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