RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA493827" and tax_phylum = "Promethearchaeota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Promethearchaeota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493827 · 7 ✖

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
2380153 2380153 PRJNA493827_P_NODE_114822_length_319_cov_1.252033_g112624_i0 PRJNA493827 114822 319 1.252033 3.99398527 Promethearchaeia archaeon 3067280 Archaea Archaea 152 3.95e-42   NR HME54153.1 3067280 g112624 i0 70.5 1.98432601880878 105 31 98.7 0 4 318 116 220 HME54153.1 acetyl-CoA C-acyltransferase [Promethearchaeia archaeon] diamond 633 152 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
28087371 28087371 PRJNA493827_P_NODE_195085_length_249_cov_0.875000_g192887_i0 PRJNA493827 195085 249 0.875 2.17875 Promethearchaeia archaeon 3067280 Archaea Archaea 170 5.49e-51   NR MFO7797710.1 3067280 g192887 i0 97.6 0.987951807228916 82 2 98.8 0 247 2 161 242 MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] diamond 246 170 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
28403216 28403216 PRJNA493827_P_NODE_156666_length_274_cov_1.084577_g154468_i0 PRJNA493827 156666 274 1.084577 2.97174098 Promethearchaeia archaeon 3067280 Archaea Archaea 45.4 0.00508   NR MFO7797710.1 3067280 g154468 i0 30 1.65328467153285 90 63 98.5 0 3 272 18 107 MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] diamond 453 45.4 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
29097913 29097913 PRJNA493827_P_NODE_114728_length_319_cov_1.361789_g112530_i0 PRJNA493827 114728 319 1.361789 4.34410691 Promethearchaeota archaeon 2053489 Archaea Archaea 63.5 4.34e-9   NR MBD3352732.1 2053489 g112530 i0 69.2 0.733542319749216 39 12 36.7 0 117 1 110 148 MBD3352732.1 protein kinase [Promethearchaeota archaeon] diamond 234 63.5 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
29192660 29192660 PRJNA493827_P_NODE_100369_length_342_cov_1.144981_g98171_i0 PRJNA493827 100369 342 1.144981 3.91583502 Promethearchaeia archaeon 3067280 Archaea Archaea 50.1 2.4e-4   NR MFO7797710.1 3067280 g98171 i0 41.3 0.701754385964912 80 44 67.5 2 342 112 141 220 MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] diamond 240 50.1 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
29571345 29571345 PRJNA493827_P_NODE_176270_length_257_cov_1.538043_g174072_i0 PRJNA493827 176270 257 1.538043 3.95277051 Promethearchaeia archaeon 3067280 Archaea Archaea 162 2.8999999999999996e-44   NR MFO7795213.1 3067280 g174072 i0 97.6 0.992217898832685 85 2 99.2 0 257 3 755 839 MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] diamond 255 162 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
30772038 30772038 PRJNA493827_P_NODE_172694_length_260_cov_1.566845_g170496_i0 PRJNA493827 172694 260 1.566845 4.073797 Promethearchaeota archaeon 2053489 Archaea Archaea 47 0.00139   NR MBY9004229.1 2053489 g170496 i0 36.1 0.830769230769231 72 40 78.5 2 206 3 224 293 MBY9004229.1 GTP-binding protein [Promethearchaeota archaeon] diamond 216 47 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);;