RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA946307 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27562317 27562317 PRJNA946307_P_NODE_31424_length_233_cov_1.293478_g30550_i0 PRJNA946307 31424 233 1.293478 3.01380374 Sulfolobus sp. E5 2200884 Archaea Archaea 54.7 2.83e-7   NR TRM73768.1 2200884 g30550 i0 86.2 0.373390557939914 29 4 37.3 0 93 7 2 30 TRM73768.1 hypothetical protein DJ523_06495 [Sulfolobus sp. E5] diamond 87 54.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus sp. E5
29046618 29046618 PRJNA946307_P_NODE_126828_length_172_cov_1.845528_g125954_i0 PRJNA946307 126828 172 1.845528 3.17430816 Sulfolobus sp. E5 2200884 Archaea Archaea 97.8 3.59e-22   NR TRM73770.1 2200884 g125954 i0 100 0.88953488372093 51 0 89 0 15 167 371 421 TRM73770.1 acetaldehyde dehydrogenase [Sulfolobus sp. E5] diamond 153 97.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus sp. E5
29867497 29867497 PRJNA946307_P_NODE_162351_length_162_cov_0.902655_g161477_i0 PRJNA946307 162351 162 0.902655 1.4623011 Thermoprotei archaeon 2250277 Archaea Archaea 55.5 3.95e-7   NR RLE97824.1 2250277 g161477 i0 61 0.759259259259259 41 16 75.9 0 137 15 392 432 RLE97824.1 MAG: hypothetical protein DRJ63_08630, partial [Thermoprotei archaeon] diamond 123 55.5 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei archaeon
30657253 30657253 PRJNA946307_P_NODE_116713_length_176_cov_4.519685_g115839_i0 PRJNA946307 116713 176 4.519685 7.9546456 Thermoproteota archaeon 2056631 Archaea Archaea 105 8.44e-25   NR MDP9489871.1 2056631 g115839 i0 94.3 3.61363636363636 53 3 90.3 0 174 16 395 447 MDP9489871.1 Glu-tRNA(Gln) amidotransferase subunit GatD [Thermoproteota archaeon] diamond 636 105 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31605657 31605657 PRJNA946307_P_NODE_104716_length_182_cov_1.488722_g103842_i0 PRJNA946307 104716 182 1.488722 2.70947404 Pyrobaculum sp. 2004705 Archaea Archaea 108 7.98e-26   NR MEM0484483.1 2004705 g103842 i0 98.2 0.923076923076923 56 1 92.3 0 2 169 1050 1105 MEM0484483.1 PaRep2b protein [Pyrobaculum sp.] diamond 168 108 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum sp.
31668829 31668829 PRJNA946307_P_NODE_158217_length_163_cov_0.894737_g157343_i0 PRJNA946307 158217 163 0.894737 1.45842131 Sulfolobales archaeon 2268200 Archaea Archaea 96.7 1.17e-21   NR MEM0439188.1 2268200 g157343 i0 89.8 0.901840490797546 49 5 90.2 0 15 161 306 354 MEM0439188.1 methylmalonyl-CoA mutase family protein [Sulfolobales archaeon] diamond 147 96.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales     Sulfolobales archaeon
32491712 32491712 PRJNA946307_P_NODE_85419_length_191_cov_1.000000_g84545_i0 PRJNA946307 85419 191 1 1.91 Sulfolobus sp. E5 2200884 Archaea Archaea 113 1.0600000000000002e-27   NR TRM73770.1 2200884 g84545 i0 98.3 0.942408376963351 60 1 94.2 0 10 189 141 200 TRM73770.1 acetaldehyde dehydrogenase [Sulfolobus sp. E5] diamond 180 113 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus sp. E5

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);;