RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA716463", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Thermoproteota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA716463 · 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
5021103 5021103 PRJNA716463_P_NODE_21604_length_310_cov_3.430380_g21187_i0 PRJNA716463 21604 310 3.43038 10.634178 root 1 Root_unresolved Root_unresolved 278 4.39e-70   NTclustered gi|27227784|emb|AJ535122.1| 29281 g21187 i0 100 90.6903225806452 150 0 97 0 1 150 842 693 Uncultured crenarchaeote partial 16S rRNA gene, clone Gitt-GR-74 blastn 28114 278 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
11396414 11396414 PRJNA716463_P_NODE_29729_length_310_cov_2.489451_g29312_i0 PRJNA716463 29729 310 2.489451 7.7172981 root 1 Root_unresolved Root_unresolved 568 2.3299999999999995e-157   NTclustered gi|42557759|emb|AJ627422.1| 29281 g29312 i0 99.677 99.8193548387097 310 1 100 0 1 310 39787 40096 Uncultured crenarchaeote genomic fragment 54d9 blastn 30944 573 0.991273996509599 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
17286718 17286718 PRJNA716463_P_NODE_88634_length_261_cov_3.031915_g88217_i0 PRJNA716463 88634 261 3.031915 7.91329815 uncultured crenarchaeote 29281 Archaea Archaea 444 3.36e-120   NTclustered gi|42557759|emb|AJ627422.1| 29281 g88217 i0 97.318 102.486590038314 261 7 100 0 1 261 42215 42475 Uncultured crenarchaeote genomic fragment 54d9 blastn 26749 444 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
27810313 27810313 PRJNA716463_P_NODE_105104_length_247_cov_1.758621_g104687_i0 PRJNA716463 105104 247 1.758621 4.34379387 Thermofilaceae archaeon 2268203 Archaea Archaea 184 9.02e-58   NR MEM2592530.1 2268203 g104687 i0 98.8 0.995951417004049 82 1 99.6 0 246 1 39 120 MEM2592530.1 DUF2750 domain-containing protein [Thermofilaceae archaeon] diamond 246 184 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae   Thermofilaceae 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);;