RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA453567 · 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
8094977 8094977 PRJNA453567_P_NODE_26127_length_171_cov_2.970149_g25890_i0 PRJNA453567 26127 171 2.970149 5.07895479 Pseudodesulfovibrio indicus 1716143 Bacteria Bacteria 134 4.97e-27   NTclustered gi|998152336|gb|CP014206.1| 1716143 g25890 i0 81.325 0.970760233918129 166 29 96 2 6 170 660567 660731 Pseudodesulfovibrio indicus strain J2 chromosome, complete genome blastn 166 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio indicus
14470405 14470405 PRJNA453567_P_NODE_12392_length_262_cov_2.115556_g12155_i0 PRJNA453567 12392 262 2.115556 5.54275672 Pelobacter propionicus 29543 Bacteria Bacteria 54.7 0.007   NTclustered gi|118501159|gb|CP000482.1| 338966 g12155 i0 96.97 0.125954198473282 33 0 12 1 171 202 96023 95991 Pelobacter propionicus DSM 2379, complete genome blastn 33 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
23394114 23394114 PRJNA453567_P_NODE_4719_length_478_cov_2.240363_g4486_i0 PRJNA453567 4719 478 2.240363 10.70893514 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 54.7 0.013   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g4486 i0 96.875 0.0669456066945607 32 1 7 0 185 216 2625942 2625973 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis

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