RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Promethearchaeati · 3 ✖

bioproject 1

  • PRJEB20058 · 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
33047739 33047739 PRJEB20058_P_NODE_228037_length_234_cov_4.745665_g225212_i0 PRJEB20058 228037 234 4.745665 11.1048561 Candidatus Lokiarchaeum ossiferum 2951803 Archaea Archaea 53.1 6.91e-6   NR UYP45242.1 2951803 g225212 i0 45.8 0.756410256410256 59 32 75.6 0 42 218 305 363 UYP45242.1 hypothetical protein NEF87_001527 [Candidatus Lokiarchaeum ossiferum] diamond 177 53.1 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia Promethearchaeales Promethearchaeaceae Candidatus Lokiarchaeum Candidatus Lokiarchaeum ossiferum
33081527 33081527 PRJEB20058_P_NODE_172318_length_284_cov_32.587444_g169495_i0 PRJEB20058 172318 284 32.587444 92.54834096 Promethearchaeia archaeon 3067280 Archaea Archaea 80.9 6.49e-16   NR HMF31672.1 3067280 g169495 i0 50 0.887323943661972 84 31 88.7 1 10 261 5 77 HMF31672.1 PHP domain-containing protein [Promethearchaeia archaeon] diamond 252 80.9 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
33179064 33179064 PRJEB20058_P_NODE_177984_length_278_cov_3.599078_g175161_i0 PRJEB20058 177984 278 3.599078 10.00543684 root 1 Root_unresolved Root_unresolved 66.6 6.2e-12   NR TET11562.1 2053491 g175161 i0 46 1.34892086330935 63 34 68 0 7 195 7 69 TET11562.1 MAG: hypothetical protein E3J82_05535 [Candidatus Thorarchaeota archaeon] diamond 375 66.6 1 Archaea   Promethearchaeati Candidatus Thorarchaeota         Candidatus Thorarchaeota 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);;