RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA560932", tax_kingdom = "Thermotogati" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 5 ✖

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA560932 · 5 ✖

analysis 1

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
28009152 28009152 PRJNA560932_P_NODE_33585_length_313_cov_1.283333_g33229_i0 PRJNA560932 33585 313 1.283333 4.01683229 Bacteria 2 Bacteria Bacteria 48.9 5.42e-4   NR WP_296905271.1 28240 g33229 i0 42.9 1.39936102236422 56 31 52.7 1 286 122 142 197 WP_296905271.1 radical SAM family heme chaperone HemW [Thermotoga sp.] diamond 438 48.9 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga sp.
28103521 28103521 PRJNA560932_P_NODE_16105_length_437_cov_4.717033_g15749_i0 PRJNA560932 16105 437 4.717033 20.61343421 Bacteria 2 Bacteria Bacteria 92.8 1.55e-20   NR WP_072864000.1 287990 g15749 i0 44.4 1.65446224256293 117 57 78.9 4 363 19 24 134 WP_072864000.1 hypoxanthine phosphoribosyltransferase [Marinitoga hydrogenitolerans] diamond 723 92.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Marinitoga Marinitoga hydrogenitolerans
28735211 28735211 PRJNA560932_P_NODE_8867_length_584_cov_3.409002_g8514_i0 PRJNA560932 8867 584 3.409002 19.90857168 root 1 Root_unresolved Root_unresolved 103 1.15e-24   NR WP_128080917.1 2335 g8514 i0 45.6 6.67294520547945 125 60 63.2 4 105 473 6 124 WP_128080917.1 MULTISPECIES: glycine cleavage system protein GcvH [Thermotoga] diamond 3897 104 0.990384615384615 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga  
29935211 29935211 PRJNA560932_P_NODE_50871_length_254_cov_1.276243_g50515_i0 PRJNA560932 50871 254 1.276243 3.24165722 PVC group 1783257 Bacteria Bacteria 80.5 9.35e-16   NR TYB95799.1 1955248 g50515 i0 46.4 7.9251968503937 84 40 99.2 1 2 253 130 208 TYB95799.1 MAG: carbamate kinase [Kosmotoga sp.] diamond 2013 81.3 0.990159901599016 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Kosmotoga Kosmotoga sp.
32513815 32513815 PRJNA560932_P_NODE_379_length_1913_cov_4.247283_g304_i0 PRJNA560932 379 1913 4.247283 81.25052379 Fervidobacterium sp. 1871331 Bacteria Bacteria 65.9 6.48e-9   NR MBP7303568.1 1871331 g304 i0 45.9 0.409304756926294 61 33 9.6 0 1548 1366 41 101 MBP7303568.1 tetratricopeptide repeat protein [Fervidobacterium sp.] diamond 783 65.9 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);;