RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax_kingdom = "Promethearchaeati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Promethearchaeati · 4 ✖

bioproject 1

  • PRJNA421571 · 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
13176888 13176888 PRJNA421571_P_NODE_46611_length_412_cov_2.646018_g44063_i0 PRJNA421571 46611 412 2.646018 10.90159416 Promethearchaeia archaeon 3067280 Archaea Archaea 199 1.36e-59   NR HME54153.1 3067280 g44063 i0 70.1 0.997572815533981 137 41 99.8 0 411 1 55 191 HME54153.1 acetyl-CoA C-acyltransferase [Promethearchaeia archaeon] diamond 411 199 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
27455077 27455077 PRJNA421571_P_NODE_35143_length_519_cov_1.322870_g32602_i0 PRJNA421571 35143 519 1.32287 6.8656953 Promethearchaeia archaeon 3067280 Archaea Archaea 309 2.2599999999999998e-104   NR MFO7797710.1 3067280 g32602 i0 94.8 0.994219653179191 172 9 99.4 0 518 3 8 179 MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] diamond 516 309 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
28528577 28528577 PRJNA421571_P_NODE_53567_length_370_cov_1.003367_g51018_i0 PRJNA421571 53567 370 1.003367 3.7124579 Promethearchaeia archaeon 3067280 Archaea Archaea 53.5 1.78e-5   NR MFO7797710.1 3067280 g51018 i0 52 0.405405405405405 50 23 39.7 1 5 151 183 232 MFO7797710.1 hypothetical protein [Promethearchaeia archaeon] diamond 150 53.5 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
31212657 31212657 PRJNA421571_P_NODE_53315_length_371_cov_1.432886_g50766_i0 PRJNA421571 53315 371 1.432886 5.31600706 Promethearchaeia archaeon 3067280 Archaea Archaea 179 2.1e-49   NR MFO7795213.1 3067280 g50766 i0 95.7 0.752021563342318 93 4 75.2 0 91 369 783 875 MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] diamond 279 179 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia 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);;