RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA565584", tax_phylum = "Promethearchaeota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

  • Promethearchaeota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA565584 · 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
28121593 28121593 PRJNA565584_P_NODE_126485_length_278_cov_0.863415_g125333_i0 PRJNA565584 126485 278 0.863415 2.4002937 Promethearchaeota archaeon 2053489 Archaea Archaea 51.2 5.69e-5   NR TFG25295.1 2053489 g125333 i0 48.4 1.38129496402878 64 30 69.1 1 192 1 326 386 TFG25295.1 MAG: glycerol-3-phosphate dehydrogenase/oxidase, partial [Promethearchaeota archaeon] diamond 384 51.2 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
29289897 29289897 PRJNA565584_P_NODE_47669_length_432_cov_1.002786_g46518_i0 PRJNA565584 47669 432 1.002786 4.33203552 Promethearchaeota archaeon 2053489 Archaea Archaea 60.5 1.5e-7   NR MBD3157206.1 2053489 g46518 i0 29.6 0.798611111111111 115 77 77.1 1 62 394 163 277 MBD3157206.1 hypothetical protein [Promethearchaeota archaeon] diamond 345 60.5 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
29321480 29321480 PRJNA565584_P_NODE_91169_length_311_cov_1.294118_g90017_i0 PRJNA565584 91169 311 1.294118 4.02470698 Promethearchaeia archaeon 3067280 Archaea Archaea 132 2.05e-33   NR MFO7795213.1 3067280 g90017 i0 97 0.636655948553055 66 2 63.7 0 114 311 546 611 MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] diamond 198 132 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
30521704 30521704 PRJNA565584_P_NODE_185973_length_247_cov_0.885057_g184821_i0 PRJNA565584 185973 247 0.885057 2.18609079 Candidatus Harpocratesius repetitus 3049170 Archaea Archaea 42.7 0.0392   NR MCF2140506.1 3049170 g184821 i0 41.7 0.437246963562753 36 21 43.7 0 40 147 452 487 MCF2140506.1 MBL fold metallo-hydrolase [Candidatus Harpocratesius repetitus] diamond 108 42.7 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Candidatus Harpocratesius Candidatus Harpocratesius repetitus
32797222 32797222 PRJNA565584_P_NODE_124860_length_279_cov_1.106796_g123708_i0 PRJNA565584 124860 279 1.106796 3.08796084 Promethearchaeota archaeon 2053489 Archaea Archaea 43.1 0.0403   NR MBN2153423.1 2053489 g123708 i0 34.7 0.806451612903226 75 41 76.3 2 12 224 245 315 MBN2153423.1 hypothetical protein [Promethearchaeota archaeon] diamond 225 43.1 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon

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