RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA509429" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA509429 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28750894 28750894 PRJNA509429_P_NODE_22307_length_279_cov_3.954918_g21479_i0 PRJNA509429 22307 279 3.954918 11.03422122 Syntrophaceae bacterium CG2_3 2052184 Bacteria Bacteria 46.2 0.00179   NR OIP88326.1 1805378 g21479 i0 33.7 0.89247311827957 83 43 76.3 2 222 10 85 167 OIP88326.1 MAG: hypothetical protein AUK26_13940 [Syntrophaceae bacterium CG2_30_58_14] diamond 249 46.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae   Syntrophaceae bacterium CG2_30_58_14
29476802 29476802 PRJNA509429_P_NODE_13850_length_381_cov_10.971098_g13027_i0 PRJNA509429 13850 381 10.971098 41.79988338 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 45.1 0.0256   NR MBQ4133630.1 2049043 g13027 i0 36.2 0.456692913385827 58 35 44.1 1 198 365 368 425 MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium] diamond 174 45.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
30235094 30235094 PRJNA509429_P_NODE_32032_length_213_cov_6.578652_g31204_i0 PRJNA509429 32032 213 6.578652 14.01252876 Desulfobulbus sp. TB 1859132 Bacteria Bacteria 43.1 0.0184   NR MCW5213304.1 2821764 g31204 i0 34.8 0.929577464788732 66 36 83.1 2 35 211 553 618 MCW5213304.1 cobyric acid synthase [Desulfobulbus sp. TB] diamond 198 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus sp. TB
30298783 30298783 PRJNA509429_P_NODE_12052_length_413_cov_8.809524_g11233_i0 PRJNA509429 12052 413 8.809524 36.38333412 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 45.1 0.0346   NR MBQ4133630.1 2049043 g11233 i0 36.2 0.421307506053269 58 35 40.7 1 230 397 368 425 MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium] diamond 174 45.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium

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