RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA690592 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3221716 3221716 PRJNA690592_S_NODE_127663_length_297_cov_1.008929_g126649_i0 PRJNA690592 127663 297 1.008929 2.99651913 Desulfatiglandales bacterium 3024416 Bacteria Bacteria 237 7.1e-58   NTclustered gi|2621703766|emb|OY762721.1| 3024416 g126649 i0 81.145 195.649831649832 297 54 99 2 1 295 607125 607421 MAG: Desulfatiglandales bacterium isolate 7b555824-8626-4373-9f6d-e46e1e23d1ce genome assembly, chromosome: 1 blastn 58108 237 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfatiglandales     Desulfatiglandales bacterium
13425386 13425386 PRJNA690592_S_NODE_220491_length_226_cov_2.013072_g219477_i0 PRJNA690592 220491 226 2.013072 4.54954272 Pseudodesulfovibrio piezophilus 879567 Bacteria Bacteria 69.4 2e-7   NTclustered gi|451894361|emb|FO203427.1| 1322246 g219477 i0 78.992 12.3938053097345 119 11 48 10 95 203 2362018 2361904 Desulfovibrio piezophilus C1TLV30 complete genome blastn 2801 69.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio piezophilus
13932965 13932965 PRJNA690592_S_NODE_194371_length_248_cov_1.314286_g193357_i0 PRJNA690592 194371 248 1.314286 3.25942928 Desulfatibacillum 218207 Bacteria Bacteria 292 1.21e-74   NTclustered gi|218759244|gb|CP001322.1| 218208 g193357 i0 87.952 132.520161290323 249 28 100 2 1 248 4578740 4578493 Desulfatibacillum aliphaticivorans strain AK-01, complete genome blastn 32865 292 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum aliphaticivorans
14700035 14700035 PRJNA690592_S_NODE_159472_length_269_cov_2.142857_g158458_i0 PRJNA690592 159472 269 2.142857 5.76428533 Geomonas nitrogeniifigens 2843197 Bacteria Bacteria 58.4 5.3e-4   NTclustered gi|2060223057|gb|CP077684.1| 2847991 g158458 i0 90.698 1.61338289962825 43 4 16 0 206 248 2918412 2918370 Geomonas nitrogeniifigens strain RF4 chromosome, complete genome blastn 434 58.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas nitrogeniifigens

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