RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA758087" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA758087 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
9661757 9661757 PRJNA758087_P_NODE_24328_length_516_cov_4.009029_g23008_i0 PRJNA758087 24328 516 4.009029 20.68658964 Deinococcus cavernae 2320857 Bacteria Bacteria 278 4.53e-92   NR WP_119762050.1 2320857 g23008 i0 99.3 0.790697674418605 136 1 79.1 0 408 1 1 136 WP_119762050.1 nucleotidyltransferase domain-containing protein [Deinococcus cavernae] diamond 408 278 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
22411097 22411097 PRJNA758087_P_NODE_39818_length_275_cov_1.287129_g38498_i0 PRJNA758087 39818 275 1.287129 3.53960475 Deinococcus 1298 Bacteria Bacteria 109 4.4000000000000005e-27   NR WP_129118210.1 1298 g38498 i0 83.6 7.98545454545455 61 10 66.5 0 37 219 1 61 WP_129118210.1 MULTISPECIES: PIG-L deacetylase family protein [Deinococcus] diamond 2196 110 0.990909090909091 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
24960100 24960100 PRJNA758087_P_NODE_32320_length_374_cov_4.033223_g31000_i0 PRJNA758087 32320 374 4.033223 15.08425402 Truepera radiovictrix 332249 Bacteria Bacteria 88.2 1.36e-18   NR WP_013179167.1 332249 g31000 i0 59.3 0.649732620320856 81 33 65 0 7 249 136 216 WP_013179167.1 metal-dependent transcriptional regulator [Truepera radiovictrix] diamond 243 88.2 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
27147346 27147346 PRJNA758087_P_NODE_31002_length_395_cov_4.077640_g29682_i0 PRJNA758087 31002 395 4.07764 16.106678 Deinococcus peraridilitoris 432329 Bacteria Bacteria 48.5 9.34e-4   NR WP_041232012.1 432329 g29682 i0 50 0.379746835443038 50 25 38 0 382 233 143 192 WP_041232012.1 SMI1/KNR4 family protein [Deinococcus peraridilitoris] diamond 150 48.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
29105790 29105790 PRJNA758087_P_NODE_42688_length_246_cov_0.890173_g41368_i0 PRJNA758087 42688 246 0.890173 2.18982558 Deinococcus caeni 569127 Bacteria Bacteria 153 1.3099999999999999e-42   NR WP_380064848.1 569127 g41368 i0 93.8 1.97560975609756 81 5 98.8 0 3 245 165 245 WP_380064848.1 hypothetical protein [Deinococcus caeni] diamond 486 153 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni

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