RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA807347" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA807347 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
13559841 13559841 PRJNA807347_P_NODE_10251_length_265_cov_1.895833_g10148_i0 PRJNA807347 10251 265 1.895833 5.02395745 Desulfopila sp. IMCC35008 2653858 Bacteria Bacteria 139 1.8099999999999999e-28   NTclustered gi|2557433592|gb|CP050700.1| 2653858 g10148 i0 98.718 32.7433962264151 78 1 29 0 105 182 543181 543258 Desulfopila sp. IMCC35008 chromosome, complete genome blastn 8677 139 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfopila Desulfopila sp. IMCC35008
16525433 16525433 PRJNA807347_P_NODE_6173_length_330_cov_1.470817_g6070_i0 PRJNA807347 6173 330 1.470817 4.8536961 Pseudomonadati 3379134 Bacteria Bacteria 394 4.48e-105   NTclustered gi|2893358420|emb|OZ220712.1| 2202153 g6070 i0 88.415 180.927272727273 328 36 99 2 1 328 1713064 1713389 MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1 blastn 59706 394 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
21208562 21208562 PRJNA807347_P_NODE_13177_length_249_cov_1.772727_g13074_i0 PRJNA807347 13177 249 1.772727 4.41409023 Desulfocurvibacter africanus 873 Bacteria Bacteria 226 1.2499999999999999e-54   NTclustered gi|367460290|gb|CP003221.1| 690850 g13074 i0 85.849 29.7991967871486 212 30 85 0 1 212 40309 40520 Desulfocurvibacter africanus subsp. africanus str. Walvis Bay chromosome, complete genome blastn 7420 226 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvibacter Desulfocurvibacter africanus

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