RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA666695", tax_phylum = "Promethearchaeota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Promethearchaeota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA666695 · 4 ✖

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
26998557 26998557 PRJNA666695_S_NODE_40002_length_320_cov_2.637993_g38908_i0 PRJNA666695 40002 320 2.637993 8.4415776 Archaea 2157 Archaea Archaea 139 1.21e-38   NR TXT53453.1 2053489 g38908 i0 68 1.93125 103 33 96.6 0 320 12 151 253 TXT53453.1 MAG: hypothetical protein BAJALOKI2v1_960015 [Promethearchaeota archaeon] diamond 618 140 0.992857142857143 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
27061954 27061954 PRJNA666695_S_NODE_105702_length_214_cov_1.595376_g104608_i0 PRJNA666695 105702 214 1.595376 3.41410464 Promethearchaeati 1935183 Archaea Archaea 53.1 2.13e-6   NR TFF86372.1 2053489 g104608 i0 60.9 4.54205607476636 46 18 64.5 0 2 139 125 170 TFF86372.1 MAG: GTP-binding protein [Promethearchaeota archaeon] diamond 972 53.1 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
30113020 30113020 PRJNA666695_S_NODE_29172_length_360_cov_3.793103_g28079_i0 PRJNA666695 29172 360 3.793103 13.6551708 Promethearchaeota archaeon 2053489 Archaea Archaea 50.1 3.25e-4   NR MCK4282620.1 2053489 g28079 i0 68.6 0.291666666666667 35 11 29.2 0 355 251 281 315 MCK4282620.1 GTP-binding protein [Promethearchaeota archaeon] diamond 105 50.1 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
30113027 30113027 PRJNA666695_S_NODE_37152_length_329_cov_2.666667_g36058_i0 PRJNA666695 37152 329 2.666667 8.77333443 Promethearchaeota archaeon 2053489 Archaea Archaea 111 7.18e-27   NR MBN1800863.1 2053489 g36058 i0 50.5 1.01215805471125 111 49 96.7 3 324 7 238 347 MBN1800863.1 hypothetical protein [Promethearchaeota archaeon] diamond 333 111 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);;