RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA826497 · 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
2503746 2503746 PRJNA826497_S_NODE_2642_length_266_cov_8.991416_g2602_i0 PRJNA826497 2642 266 8.991416 23.91716656 Desulfobacca 60892 Bacteria Bacteria 191 4.940000000000001e-44   NTclustered gi|470488362|ref|NR_076865.1| 60893 g2602 i0 85.263 139.353383458647 190 23 70 4 2 187 558 370 Desulfobacca acetoxidans strain ASRB2 23S ribosomal RNA gene, complete sequence blastn 37068 191 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobaccia Desulfobaccales Desulfobaccaceae Desulfobacca Desulfobacca acetoxidans
6332300 6332300 PRJNA826497_S_NODE_1085_length_330_cov_12.340067_g1045_i0 PRJNA826497 1085 330 12.340067 40.7222211 Desulfobulbus 893 Bacteria Bacteria 56.5 0.002   NTclustered gi|470487339|ref|NR_076814.1| 894 g1045 i0 96.97 1.1 33 1 10 0 92 124 1623 1655 Desulfobulbus propionicus strain 1pr3 23S ribosomal RNA gene, complete sequence blastn 363 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus propionicus
13574207 13574207 PRJNA826497_S_NODE_6931_length_208_cov_2.880000_g6891_i0 PRJNA826497 6931 208 2.88 5.9904 Desulfobulbus propionicus 894 Bacteria Bacteria 243 1.01e-59   NTclustered gi|320120648|gb|CP002364.1| 577650 g6891 i0 88.5 2.78846153846154 200 23 96 0 9 208 3065796 3065597 Desulfobulbus propionicus DSM 2032, complete genome blastn 580 243 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus propionicus
20354570 20354570 PRJNA826497_S_NODE_11696_length_179_cov_1.232877_g11656_i0 PRJNA826497 11696 179 1.232877 2.20684983 Candidatus Electrothrix 1859128 Bacteria Bacteria 158 3.12e-34   NTclustered gi|2755823080|gb|CP159373.1| 3062594 g11656 i0 82.955 68.9162011173184 176 28 98 2 1 176 2295742 2295569 MAG: Candidatus Electrothrix aestuarii isolate Rat1 chromosome, complete genome blastn 12336 158 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix aestuarii

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