RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Thermoproteota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA773247 · 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
27527266 27527266 PRJNA773247_P_NODE_28963_length_257_cov_2.695652_g28879_i0 PRJNA773247 28963 257 2.695652 6.92782564 Thermoproteota archaeon 2056631 Archaea Archaea 86.7 7.75e-18   NR RDJ35437.1 2056631 g28879 i0 51.3 1.8326848249027201 78 37 89.9 1 232 2 48 125 RDJ35437.1 MAG: hypothetical protein DWQ19_11520 [Thermoproteota archaeon] diamond 471 86.7 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27937838 27937838 PRJNA773247_P_NODE_25485_length_277_cov_2.303922_g25401_i0 PRJNA773247 25485 277 2.303922 6.38186394 Thermoprotei archaeon 2250277 Archaea Archaea 137 1.95e-35   NR RLE97824.1 2250277 g25401 i0 72.6 1.02888086642599 95 23 99.6 1 277 2 437 531 RLE97824.1 MAG: hypothetical protein DRJ63_08630, partial [Thermoprotei archaeon] diamond 285 137 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei archaeon
30053190 30053190 PRJNA773247_P_NODE_21771_length_304_cov_6.779221_g21687_i0 PRJNA773247 21771 304 6.779221 20.60883184 Thermoprotei archaeon 2250277 Archaea Archaea 59.7 2.52e-8   NR RLE97814.1 2250277 g21687 i0 34.1 1.78618421052632 88 58 86.8 0 38 301 67 154 RLE97814.1 MAG: hypothetical protein DRJ63_08580, partial [Thermoprotei archaeon] diamond 543 59.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei archaeon
30558609 30558609 PRJNA773247_P_NODE_10673_length_477_cov_25.960396_g10590_i0 PRJNA773247 10673 477 25.960396 123.83108892 Thermoproteota archaeon 2056631 Archaea Archaea 132 1.05e-32   NR MEW6604485.1 2056631 g10590 i0 56.6 0.666666666666667 106 46 66.7 0 477 160 426 531 MEW6604485.1 glycosyltransferase family 39 protein [Thermoproteota archaeon] diamond 318 132 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota 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);;