RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA758398", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 4 ✖

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA758398 · 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
27526945 27526945 PRJNA758398_S_NODE_17803_length_238_cov_1.349206_g17662_i0 PRJNA758398 17803 238 1.349206 3.21111028 Candidatus Poseidonia alphae 1915863 Archaea Archaea 59.7 2.48e-8   NR MDA7464142.1 1915863 g17662 i0 42.6 2.31932773109244 68 33 80.7 3 236 45 201 266 MDA7464142.1 lipase family protein [Candidatus Poseidonia alphae] diamond 552 59.7 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae Candidatus Poseidonia Candidatus Poseidonia alphae
28010595 28010595 PRJNA758398_S_NODE_40525_length_170_cov_1.140496_g40384_i0 PRJNA758398 40525 170 1.140496 1.9388432 root 1 Root_unresolved Root_unresolved 42.4 0.0194   NR RJU80011.1 2163009 g40384 i0 52.3 2.91176470588235 44 17 77.6 1 38 169 122 161 RJU80011.1 MAG: hypothetical protein DWC09_08350 [Candidatus Poseidoniales archaeon] diamond 495 42.4 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
28789846 28789846 PRJNA758398_S_NODE_36247_length_179_cov_1.030769_g36106_i0 PRJNA758398 36247 179 1.030769 1.84507651 Thermoplasmata archaeon 1906666 Archaea Archaea 86.3 7.27e-18   NR MEM0354068.1 1906666 g36106 i0 55.9 1.94413407821229 59 26 98.9 0 2 178 198 256 MEM0354068.1 hypothetical protein [Thermoplasmata archaeon] diamond 348 86.3 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32275998 32275998 PRJNA758398_S_NODE_17838_length_238_cov_1.079365_g17697_i0 PRJNA758398 17838 238 1.079365 2.5688887 root 1 Root_unresolved Root_unresolved 66.2 1.82e-10   NR MEM0354167.1 1906666 g17697 i0 40 2.73529411764706 75 40 88.2 2 2 211 170 244 MEM0354167.1 hypothetical protein [Thermoplasmata archaeon] diamond 651 66.6 0.993993993993994 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata 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);;