RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJDB4470" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJDB4470 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27443633 27443633 PRJDB4470_P_NODE_108603_length_166_cov_0.871795_g107448_i0 PRJDB4470 108603 166 0.871795 1.4471797 Deinococcus sp. Marseille-Q64 47478 Bacteria Bacteria 77.4 7.6e-15   NR WP_261663159.1 2969223 g107448 i0 69.1 3.97590361445783 55 17 99.4 0 2 166 264 318 WP_261663159.1 TrkH family potassium uptake protein [Deinococcus sp. Marseille-Q6407] diamond 660 77.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. Marseille-Q6407
28674776 28674776 PRJDB4470_P_NODE_120687_length_163_cov_0.885965_g119532_i0 PRJDB4470 120687 163 0.885965 1.44412295 Deinococcus xinjiangensis 457454 Bacteria Bacteria 110 1.85e-27   NR WP_353541712.1 457454 g119532 i0 98.1 0.993865030674847 54 1 99.4 0 2 163 210 263 WP_353541712.1 D-alanine--D-alanine ligase family protein [Deinococcus xinjiangensis] diamond 162 110 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus xinjiangensis
28700462 28700462 PRJDB4470_P_NODE_115987_length_164_cov_0.886957_g114832_i0 PRJDB4470 115987 164 0.886957 1.45460948 Truepera 332248 Bacteria Bacteria 95.1 4.51e-21   NR WP_013176976.1 332249 g114832 i0 87 4.9390243902439 54 7 98.8 0 2 163 344 397 WP_013176976.1 endopeptidase La [Truepera radiovictrix] diamond 810 95.1 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
28864072 28864072 PRJDB4470_P_NODE_46888_length_305_cov_0.898438_g45735_i0 PRJDB4470 46888 305 0.898438 2.7402359 Aminobacterium sp. 1872491 Bacteria Bacteria 50.8 1.74e-5   NR WP_323401726.1 1872491 g45735 i0 58.3 0.708196721311475 36 15 35.4 0 123 16 1 36 WP_323401726.1 hypothetical protein [Aminobacterium sp.] diamond 216 50.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminobacterium Aminobacterium sp.
29432178 29432178 PRJDB4470_P_NODE_111770_length_165_cov_0.879310_g110615_i0 PRJDB4470 111770 165 0.87931 1.4508615 Allomeiothermus silvanus 52022 Bacteria Bacteria 107 2.02e-28   NR WP_276956473.1 52022 g110615 i0 100 0.981818181818182 54 0 98.2 0 163 2 20 73 WP_276956473.1 bactofilin family protein [Allomeiothermus silvanus] diamond 162 107 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
31827997 31827997 PRJDB4470_P_NODE_124157_length_162_cov_0.902655_g123002_i0 PRJDB4470 124157 162 0.902655 1.4623011 Thermus 270 Bacteria Bacteria 100 7.539999999999999e-23   NR WP_243091307.1 270 g123002 i0 81.1 6.87037037037037 53 10 98.1 0 161 3 745 797 WP_243091307.1 MULTISPECIES: type ISP restriction/modification enzyme [Thermus] diamond 1113 101 0.99009900990099 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus  
32562120 32562120 PRJDB4470_P_NODE_109019_length_166_cov_0.871795_g107864_i0 PRJDB4470 109019 166 0.871795 1.4471797 Truepera radiovictrix 332249 Bacteria Bacteria 85.9 4.46e-18   NR WP_041947253.1 332249 g107864 i0 75.5 0.957831325301205 53 13 95.8 0 3 161 9 61 WP_041947253.1 type IV pilus twitching motility protein PilT [Truepera radiovictrix] diamond 159 85.9 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix

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