RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA924320" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA924320 · 3 ✖

analysis 1

  • diamond · 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
29835122 29835122 PRJNA924320_S_NODE_9011_length_325_cov_1.264493_g8869_i0 PRJNA924320 9011 325 1.264493 4.10960225 Deinococcus reticulitermitis 856736 Bacteria Bacteria 79.7 1.1e-15   NR WP_092264064.1 856736 g8869 i0 45.7 4.43076923076923 92 46 84.9 1 32 307 4 91 WP_092264064.1 MIP/aquaporin family protein [Deinococcus reticulitermitis] diamond 1440 79.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
30916791 30916791 PRJNA924320_S_NODE_15554_length_256_cov_2.246377_g15412_i0 PRJNA924320 15554 256 2.246377 5.75072512 Aminobacterium 81466 Bacteria Bacteria 43.5 0.023   NR MDD3708237.1 1872491 g15412 i0 42 1.171875 50 29 58.6 0 56 205 19 68 MDD3708237.1 tripartite tricarboxylate transporter permease [Aminobacterium sp.] diamond 300 43.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminobacterium Aminobacterium sp.
32585782 32585782 PRJNA924320_S_NODE_10459_length_304_cov_1.200000_g10317_i0 PRJNA924320 10459 304 1.2 3.648 Fervidobacterium sp. 1871331 Bacteria Bacteria 43.1 0.048   NR WP_339745441.1 1871331 g10317 i0 37.3 0.503289473684211 51 32 50.3 0 303 151 111 161 WP_339745441.1 transglycosylase SLT domain-containing protein [Fervidobacterium sp.] diamond 153 43.1 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.

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