RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB7366" and tax_kingdom = "Promethearchaeati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Promethearchaeati · 3 ✖

bioproject 1

  • PRJEB7366 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
20536154 20536154 PRJEB7366_P_NODE_19677_length_172_cov_1.167883_g19243_i0 PRJEB7366 19677 172 1.167883 2.00875876 Promethearchaeota archaeon CR_4 1849166 Archaea Archaea 86.3 4.82e-18   NR OLS15498.1 1849166 g19243 i0 76.8 0.976744186046512 56 13 97.7 0 4 171 257 312 OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4] diamond 168 86.3 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon CR_4
27879797 27879797 PRJEB7366_P_NODE_15625_length_197_cov_1.481481_g15191_i0 PRJEB7366 15625 197 1.481481 2.91851757 Archaea 2157 Archaea Archaea 94.7 5.480000000000001e-21   NR OLS15498.1 1849166 g15191 i0 72.1 1.85786802030457 61 17 92.9 0 11 193 286 346 OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4] diamond 366 94.7 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon CR_4
29371076 29371076 PRJEB7366_P_NODE_12129_length_232_cov_1.395939_g11695_i0 PRJEB7366 12129 232 1.395939 3.23857848 Promethearchaeota archaeon CR_4 1849166 Archaea Archaea 97.4 9.78e-22   NR OLS14603.1 1849166 g11695 i0 83.3 1.39655172413793 54 9 69.8 0 232 71 364 417 OLS14603.1 MAG: acetyl-CoA acetyltransferase [Promethearchaeota archaeon CR_4] diamond 324 97.4 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon CR_4

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