RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14175 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
32908859 32908859 PRJEB14175_P_NODE_178897_length_246_cov_1.340541_g176630_i0 PRJEB14175 178897 246 1.340541 3.29773086 Thermoproteota archaeon 2056631 Archaea Archaea 171 1.1e-49   NR MDP9306352.1 2056631 g176630 i0 98.8 2 82 1 100 0 246 1 246 327 MDP9306352.1 tRNA pseudouridine(13) synthase TruD [Thermoproteota archaeon] diamond 492 171 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32943272 32943272 PRJEB14175_P_NODE_192954_length_234_cov_1.109827_g190687_i0 PRJEB14175 192954 234 1.109827 2.59699518 Thermoproteota archaeon 2056631 Archaea Archaea 156 5.76e-46   NR MDP9306257.1 2056631 g190687 i0 98.7 0.987179487179487 77 1 98.7 0 232 2 39 115 MDP9306257.1 S4 domain-containing protein [Thermoproteota archaeon] diamond 231 156 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32956922 32956922 PRJEB14175_P_NODE_220858_length_213_cov_1.657895_g218590_i0 PRJEB14175 220858 213 1.657895 3.53131635 Thermoproteati 1783275 Archaea Archaea 48.5 2.24e-4   NR MEM0172469.1 2056631 g218590 i0 43.9 2.83098591549296 66 30 93 2 209 12 150 208 MEM0172469.1 GH25 family lysozyme [Thermoproteota archaeon] diamond 603 48.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32995827 32995827 PRJEB14175_P_NODE_96595_length_365_cov_7.476974_g94329_i0 PRJEB14175 96595 365 7.476974 27.2909551 Thermoproteota archaeon 2056631 Archaea Archaea 148 8.119999999999997e-42   NR NLE03613.1 2056631 g94329 i0 68.8 0.895890410958904 109 34 89.6 0 18 344 73 181 NLE03613.1 hypothetical protein [Thermoproteota archaeon] diamond 327 148 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33042330 33042330 PRJEB14175_P_NODE_85444_length_393_cov_2.912651_g83179_i0 PRJEB14175 85444 393 2.912651 11.44671843 Thermoproteati 1783275 Archaea Archaea 158 5.329999999999998e-47   NR MDP9498899.1 2056631 g83179 i0 90.2 1.87786259541985 82 8 62.6 0 141 386 1 82 MDP9498899.1 hypothetical protein [Thermoproteota archaeon] diamond 738 158 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33113262 33113262 PRJEB14175_P_NODE_130191_length_303_cov_21.074380_g127924_i0 PRJEB14175 130191 303 21.07438 63.8553714 Ignisphaera sp. 2268142 Archaea Archaea 64.7 1.37e-9   NR MCI4435416.1 2268142 g127924 i0 63 0.881188118811881 46 16 45.5 1 153 290 393 437 MCI4435416.1 hypothetical protein [Ignisphaera sp.] diamond 267 64.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
33131669 33131669 PRJEB14175_P_NODE_268687_length_191_cov_7.269231_g266419_i0 PRJEB14175 268687 191 7.2692310000000004 13.88423121 Thermoproteota archaeon 2056631 Archaea Archaea 102 9.49e-26   NR MEM3368534.1 2056631 g266419 i0 96.4 0.879581151832461 56 2 88 0 2 169 92 147 MEM3368534.1 hypothetical protein [Thermoproteota archaeon] diamond 168 102 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33147188 33147188 PRJEB14175_P_NODE_101568_length_354_cov_5.163823_g99302_i0 PRJEB14175 101568 354 5.163823 18.27993342 Thermoproteota archaeon 2056631 Archaea Archaea 201 9.46e-64   NR MDP9305585.1 2056631 g99302 i0 91.9 0.940677966101695 111 9 94.1 0 22 354 47 157 MDP9305585.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Thermoproteota archaeon] diamond 333 201 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33147455 33147455 PRJEB14175_P_NODE_128288_length_306_cov_7.020408_g126021_i0 PRJEB14175 128288 306 7.020408 21.48244848 Thermoproteota archaeon 2056631 Archaea Archaea 154 2.75e-41   NR MDQ3869313.1 2056631 g126021 i0 83.2 1.86274509803922 95 16 93.1 0 21 305 321 415 MDQ3869313.1 SMC family ATPase [Thermoproteota archaeon] diamond 570 154 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);;