RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1067370", 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

  • PRJNA1067370 · 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
26814125 26814125 PRJNA1067370_P_NODE_38621_length_323_cov_1.924000_g38073_i0 PRJNA1067370 38621 323 1.924 6.21452 Promethearchaeota archaeon 2053489 Archaea Archaea 50.8 1.2e-4   NR MBD3193731.1 2053489 g38073 i0 40.7 0.547987616099071 59 29 49.2 1 120 278 131 189 MBD3193731.1 GTP-binding protein [Promethearchaeota archaeon] diamond 177 50.8 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
28858846 28858846 PRJNA1067370_P_NODE_87808_length_249_cov_0.875000_g87259_i0 PRJNA1067370 87808 249 0.875 2.17875 Candidatus Lokiarchaeum 1655637 Archaea Archaea 82.4 2.82e-16   NR KKK42630.1 1538547 g87259 i0 46.9 1.96385542168675 81 43 97.6 0 248 6 233 313 KKK42630.1 MAG: hypothetical protein Lokiarch_33560, partial [Candidatus Lokiarchaeum sp. GC14_75] diamond 489 82.4 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Candidatus Lokiarchaeum Candidatus Lokiarchaeum sp. GC14_75
29404039 29404039 PRJNA1067370_P_NODE_34289_length_338_cov_1.373585_g33741_i0 PRJNA1067370 34289 338 1.373585 4.6427173 Promethearchaeota archaeon 2053489 Archaea Archaea 44.7 0.0125   NR UCC21304.1 2053489 g33741 i0 44.2 0.461538461538462 52 29 46.2 0 24 179 123 174 UCC21304.1 MAG: GTP-binding protein [Promethearchaeota archaeon] diamond 156 44.7 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
31015093 31015093 PRJNA1067370_P_NODE_69095_length_266_cov_1.259067_g68546_i0 PRJNA1067370 69095 266 1.259067 3.34911822 Promethearchaeia archaeon 3067280 Archaea Archaea 62 7.78e-9   NR MFO8018952.1 3067280 g68546 i0 38.2 0.857142857142857 76 34 85.7 3 38 265 331 393 MFO8018952.1 trehalase family glycosidase [Promethearchaeia archaeon] diamond 228 62 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
31267942 31267942 PRJNA1067370_P_NODE_47615_length_302_cov_1.388646_g47067_i0 PRJNA1067370 47615 302 1.388646 4.19371092 Promethearchaeota archaeon 2053489 Archaea Archaea 43.5 0.0364   NR MBY8981975.1 2053489 g47067 i0 29.5 0.874172185430464 88 52 77.5 2 245 12 154 241 MBY8981975.1 SDR family oxidoreductase [Promethearchaeota archaeon] diamond 264 43.5 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);;