RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA437204" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA437204 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
15736210 15736210 PRJNA437204_P_NODE_91633_length_249_cov_0.875000_g91334_i0 PRJNA437204 91633 249 0.875 2.17875 Thermoplasmata archaeon 1906666 Archaea Archaea 161 5.929999999999999e-47   NR MBE6528590.1 1906666 g91334 i0 98.8 0.987951807228916 82 1 98.8 0 3 248 174 255 MBE6528590.1 hypothetical protein [Thermoplasmata archaeon] diamond 246 161 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
27392099 27392099 PRJNA437204_P_NODE_22423_length_395_cov_0.776398_g22124_i0 PRJNA437204 22423 395 0.776398 3.0667721 Candidatus Poseidoniaceae archaeon 2666346 Archaea Archaea 80.5 2.5e-15   NR HII50895.1 2666346 g22124 i0 53.7 2.03544303797468 67 31 50.9 0 173 373 3 69 HII50895.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] diamond 804 80.5 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae   Candidatus Poseidoniaceae archaeon
28781067 28781067 PRJNA437204_P_NODE_51587_length_297_cov_1.370536_g51288_i0 PRJNA437204 51587 297 1.370536 4.07049192 Thermoplasmata archaeon 1906666 Archaea Archaea 96.7 2.5300000000000003e-21   NR RLF38486.1 1906666 g51288 i0 68.7 4.3030303030303 67 21 67.7 0 63 263 3 69 RLF38486.1 MAG: molecular chaperone DnaJ [Thermoplasmata archaeon] diamond 1278 96.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29002669 29002669 PRJNA437204_P_NODE_103108_length_246_cov_0.890173_g102809_i0 PRJNA437204 103108 246 0.890173 2.18982558 Thermoplasmatota archaeon 2806419 Archaea Archaea 79.3 3.33e-15   NR MEM4258062.1 2806419 g102809 i0 46.3 0.975609756097561 80 43 97.6 0 241 2 268 347 MEM4258062.1 hypothetical protein [Thermoplasmatota archaeon] diamond 240 79.3 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29886491 29886491 PRJNA437204_P_NODE_41651_length_320_cov_1.246964_g41352_i0 PRJNA437204 41651 320 1.246964 3.9902848 Thermoplasmata archaeon 1906666 Archaea Archaea 186 1.25e-57   NR MBE6526235.1 1906666 g41352 i0 100 0.99375 106 0 99.4 0 318 1 8 113 MBE6526235.1 hypothetical protein [Thermoplasmata archaeon] diamond 318 186 1 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);;