RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 3 ✖

bioproject 1

  • PRJNA917598 · 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
26898184 26898184 PRJNA917598_P_NODE_80921_length_250_cov_1.587571_g79977_i0 PRJNA917598 80921 250 1.587571 3.9689275 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 52.8 1.22e-5   NR MEM2159665.1 2507556 g79977 i0 52.4 0.504 42 20 50.4 0 126 1 1 42 MEM2159665.1 hypothetical protein [Candidatus Nitrosotenuis sp.] diamond 126 52.8 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
31984343 31984343 PRJNA917598_P_NODE_40218_length_362_cov_1.110727_g39274_i0 PRJNA917598 40218 362 1.110727 4.02083174 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 98.2 6.6e-22   NR MEM2159556.1 2507556 g39274 i0 49.6 0.969613259668508 117 59 97 0 3 353 150 266 MEM2159556.1 hypothetical protein [Candidatus Nitrosotenuis sp.] diamond 351 98.2 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
32805885 32805885 PRJNA917598_P_NODE_73760_length_264_cov_1.335079_g72816_i0 PRJNA917598 73760 264 1.335079 3.52460856 Candidatus Bathyarchaeota archaeon CG 2026714 Archaea Archaea 71.2 1.2e-12   NR PIU58854.1 1974385 g72816 i0 44.8 1.97727272727273 87 47 98.9 1 263 3 38 123 PIU58854.1 MAG: hypothetical protein COS86_07270, partial [Candidatus Bathyarchaeota archaeon CG07_land_8_20_14_0_80_47_9] diamond 522 71.2 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon CG07_land_8_20_14_0_80_47_9

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