RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA330616 · 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
5493394 5493394 PRJNA330616_P_NODE_3925_length_433_cov_2.270833_g3518_i0 PRJNA330616 3925 433 2.270833 9.83270689 Geopsychrobacteraceae bacterium 3065857 Bacteria Bacteria 108 8.8e-19   NTclustered gi|2621701823|emb|OY759353.1| 3065857 g3518 i0 91.25 1.04387990762125 80 5 18 2 19 97 2088524 2088446 MAG: Geopsychrobacteraceae bacterium isolate b20cad9c-d1d2-40c5-8f7b-178437520c26 genome assembly, chromosome: 1 blastn 452 108 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae   Geopsychrobacteraceae bacterium
10593361 10593361 PRJNA330616_P_NODE_21049_length_184_cov_1.511111_g20640_i0 PRJNA330616 21049 184 1.511111 2.78044424 Salidesulfovibrio onnuriiensis 2583823 Bacteria Bacteria 52.8 0.016   NTclustered gi|1725298512|gb|CP040751.1| 2583823 g20640 i0 100 0.152173913043478 28 0 15 0 107 134 1574414 1574387 Salidesulfovibrio onnuriiensis strain IOR2 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Salidesulfovibrio Salidesulfovibrio onnuriiensis
11868205 11868205 PRJNA330616_P_NODE_16090_length_209_cov_0.906250_g15681_i0 PRJNA330616 16090 209 0.90625 1.8940625 Desulfovibrio fairfieldensis 44742 Bacteria Bacteria 342 9.709999999999999e-90   NTclustered gi|987453195|gb|CP014229.1| 44742 g15681 i0 96.19 110.368421052632 210 6 100 2 1 209 165600 165392 Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome blastn 23067 342 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
14418524 14418524 PRJNA330616_P_NODE_24792_length_169_cov_1.758333_g24383_i0 PRJNA330616 24792 169 1.758333 2.97158277 Desulfopila sp. IMCC35008 2653858 Bacteria Bacteria 141 2.93e-29   NTclustered gi|2557433592|gb|CP050700.1| 2653858 g24383 i0 85 124.023668639053 140 20 84 1 15 153 465464 465325 Desulfopila sp. IMCC35008 chromosome, complete genome blastn 20960 141 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfopila Desulfopila sp. IMCC35008

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