RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB36940" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 4 ✖

bioproject 1

  • PRJEB36940 · 4 ✖

analysis 1

  • diamond · 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
28075519 28075519 PRJEB36940_P_NODE_5745_length_358_cov_0.933333_g5616_i0 PRJEB36940 5745 358 0.933333 3.34133214 Thermoprotei archaeon 2250277 Archaea Archaea 53.1 2.07e-5   NR RLG82655.1 2250277 g5616 i0 28.1 2.40502793296089 89 61 73.7 2 65 328 145 231 RLG82655.1 MAG: hypothetical protein DRO40_07150 [Thermoprotei archaeon] diamond 861 53.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei archaeon
28107107 28107107 PRJEB36940_P_NODE_6505_length_338_cov_1.030189_g6376_i0 PRJEB36940 6505 338 1.030189 3.48203882 Infirmifilum uzonense 1550241 Archaea Archaea 57.8 5.1e-7   NR WP_052883929.1 1550241 g6376 i0 37.6 3.21301775147929 85 51 73.7 1 80 328 3 87 WP_052883929.1 NAD-dependent epimerase/dehydratase family protein [Infirmifilum uzonense] diamond 1086 57.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae Infirmifilum Infirmifilum uzonense
32782914 32782914 PRJEB36940_P_NODE_11160_length_264_cov_1.094241_g11031_i0 PRJEB36940 11160 264 1.094241 2.88879624 Nitrosopumilales archaeon 2026768 Archaea Archaea 45.8 0.00407   NR KAG2476733.1 2026768 g11031 i0 44.6 0.636363636363636 56 25 56.8 1 259 110 2731 2786 KAG2476733.1 MAG: hypothetical protein NPMRTH1_1560003 [Nitrosopumilales archaeon] diamond 168 45.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
32846033 32846033 PRJEB36940_P_NODE_6640_length_334_cov_1.793103_g6511_i0 PRJEB36940 6640 334 1.793103 5.98896402 Thermoprotei archaeon 2250277 Archaea Archaea 41.2 0.0443   NR RLG83113.1 2250277 g6511 i0 78.3 0.206586826347305 23 4 19.8 1 312 247 4 26 RLG83113.1 MAG: hypothetical protein DRO40_05770 [Thermoprotei archaeon] diamond 69 41.2 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei 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);;