RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB6584 · 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
25933687 25933687 PRJEB6584o_S_NODE_81212_length_151_cov_1.353448_g81104_i0 PRJEB6584 81212 151 1.353448 2.04370648 Syntrophotalea carbinolica DSM 238 19 Bacteria Bacteria 69.4 1.22e-7   NTclustered gi|90823168|gb|CP000142.2| 338963 g81104 i0 93.478 4.59602649006623 46 3 30 0 36 81 897263 897218 Pelobacter carbinolicus DSM 2380, complete genome blastn 694 69.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Syntrophotaleaceae Syntrophotalea Syntrophotalea carbinolica
26160288 26160288 PRJEB6584d_S_NODE_13173_length_174_cov_1.568345_g13105_i0 PRJEB6584 13173 174 1.568345 2.7289203 Pseudomonadati 3379134 Bacteria Bacteria 100 5.15e-17   NTclustered gi|2447237393|gb|CP087952.1| 933262 g13105 i0 81.746 132.994252873563 126 18 71 4 52 174 2911766 2911889 Desulfosarcina sp. BuS5 chromosome, complete genome blastn 23141 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfosarcinaceae Desulfosarcina Desulfosarcina sp. BuS5
26341542 26341542 PRJEB6584o_S_NODE_58311_length_163_cov_0.937500_g58203_i0 PRJEB6584 58311 163 0.9375 1.528125 Desulfovibrio aminophilus 81425 Bacteria Bacteria 108 2.86e-19   NTclustered gi|2908463109|gb|CP168306.1| 81425 g58203 i0 79.012 5.13496932515337 162 31 99 3 1 161 2517199 2517358 MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome blastn 837 108 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio aminophilus
26477169 26477169 PRJEB6584o_S_NODE_17872_length_212_cov_2.000000_g17764_i0 PRJEB6584 17872 212 2 4.24 Desulfovibrio piger 901 Bacteria Bacteria 243 1.03e-59   NTclustered gi|1102127722|emb|LT630450.1| 901 g17764 i0 87.264 62.0990566037736 212 27 100 0 1 212 982926 982715 Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I blastn 13165 243 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio piger

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