RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJEB10140" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJEB10140 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
26614903 26614903 PRJEB10140_P_NODE_230861_length_176_cov_2.047244_g213552_i0 PRJEB10140 230861 176 2.047244 3.60314944 root 1 Root_unresolved Root_unresolved 60.8 1.65e-9   NR WP_081246776.1 1650659 g213552 i0 56 3.66477272727273 50 22 85.2 0 174 25 19 68 WP_081246776.1 ADP-ribose-binding protein [Thermoproteus sp. CP80] diamond 645 60.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Thermoproteus Thermoproteus sp. CP80
26652451 26652451 PRJEB10140_P_NODE_187941_length_205_cov_1.346154_g170632_i0 PRJEB10140 187941 205 1.346154 2.7596157 Pyrobaculum sp. 2004705 Archaea Archaea 48.1 2.75e-4   NR MFN7105009.1 2004705 g170632 i0 37 0.790243902439024 54 34 79 0 5 166 2 55 MFN7105009.1 hypothetical protein [Pyrobaculum sp.] diamond 162 48.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum sp.
27380488 27380488 PRJEB10140_P_NODE_230963_length_176_cov_1.921260_g213654_i0 PRJEB10140 230963 176 1.92126 3.3814176 Sulfuracidifex tepidarius 1294262 Archaea Archaea 79 2.17e-15   NR WP_149528435.1 1294262 g213654 i0 66.7 2.77840909090909 57 19 97.2 0 4 174 67 123 WP_149528435.1 hydroxymethylglutaryl-CoA reductase (NADPH) [Sulfuracidifex tepidarius] diamond 489 79 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfuracidifex Sulfuracidifex tepidarius
27822589 27822589 PRJEB10140_P_NODE_44504_length_812_cov_3.608126_g7533_i2 PRJEB10140 44504 812 3.608126 29.29798312 Thermoproteota archaeon 2056631 Archaea Archaea 66.2 2.79e-8   NR MDQ2684806.1 2056631 g7533 i2 62.8 0.158866995073892 43 16 15.9 0 235 107 259 301 MDQ2684806.1 hypothetical protein [Thermoproteota archaeon] diamond 129 66.2 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28517057 28517057 PRJEB10140_P_NODE_275667_length_164_cov_0.904348_g258358_i0 PRJEB10140 275667 164 0.904348 1.48313072 Sulfolobaceae archaeon 2967306 Archaea Archaea 84.3 9.06e-18   NR MEM0173169.1 2967306 g258358 i0 83.7 0.896341463414634 49 8 89.6 0 17 163 104 152 MEM0173169.1 hypothetical protein [Sulfolobaceae archaeon] diamond 147 84.3 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
29779932 29779932 PRJEB10140_P_NODE_244331_length_169_cov_1.616667_g227022_i0 PRJEB10140 244331 169 1.616667 2.73216723 Thermoproteota archaeon 2056631 Archaea Archaea 90.5 2.2700000000000003e-22   NR MEC8530265.1 2056631 g227022 i0 80.8 2.73372781065089 52 10 92.3 0 1 156 14 65 MEC8530265.1 adenosylhomocysteinase [Thermoproteota archaeon] diamond 462 90.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30475034 30475034 PRJEB10140_P_NODE_158473_length_236_cov_1.326203_g141165_i0 PRJEB10140 158473 236 1.326203 3.12983908 Thermoproteota archaeon 2056631 Archaea Archaea 43.5 0.0184   NR MCR8455893.1 2056631 g141165 i0 37.5 1.44915254237288 56 32 71.2 2 175 8 46 98 MCR8455893.1 hypothetical protein [Thermoproteota archaeon] diamond 342 43.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30790962 30790962 PRJEB10140_P_NODE_37014_length_953_cov_2.988938_g23503_i0 PRJEB10140 37014 953 2.988938 28.48457914 Thermoprotei archaeon 2250277 Archaea Archaea 61.6 5.43e-7   NR RLE92860.1 2250277 g23503 i0 33 0.333683105981112 106 65 33.1 3 599 913 128 228 RLE92860.1 MAG: hypothetical protein DRN04_09060 [Thermoprotei archaeon] diamond 318 61.6 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei archaeon
31929053 31929053 PRJEB10140_P_NODE_156117_length_239_cov_1.336842_g138809_i0 PRJEB10140 156117 239 1.336842 3.19505238 Thermoproteota archaeon 2056631 Archaea Archaea 42.4 0.0196   NR MDK2371869.1 2056631 g138809 i0 36.2 0.589958158995816 47 30 59 0 206 66 81 127 MDK2371869.1 hypothetical protein [Thermoproteota archaeon] diamond 141 42.4 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32656145 32656145 PRJEB10140_P_NODE_289040_length_162_cov_0.920354_g271731_i0 PRJEB10140 289040 162 0.920354 1.49097348 Thermoproteota archaeon 2056631 Archaea Archaea 48.5 1.15e-4   NR NIQ06866.1 2056631 g271731 i0 63.9 0.666666666666667 36 13 66.7 0 46 153 1 36 NIQ06866.1 DUF3383 domain-containing protein [Thermoproteota archaeon] diamond 108 48.5 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);;