RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA312899" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 7 ✖

bioproject 1

  • PRJNA312899 · 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
18230675 18230675 PRJNA312899_P_NODE_12375_length_537_cov_55.598361_g11946_i0 PRJNA312899 12375 537 55.598361 298.56319857 Nitrososphaeria archaeon 2268198 Archaea Archaea 137 4.19e-37   NR NDB92457.1 2268198 g11946 i0 65.3 0.547486033519553 98 34 54.7 0 294 1 7 104 NDB92457.1 class I SAM-dependent methyltransferase [Nitrososphaeria archaeon] diamond 294 137 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
28810858 28810858 PRJNA312899_P_NODE_90888_length_165_cov_1.293103_g90446_i0 PRJNA312899 90888 165 1.293103 2.13361995 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 44.7 3.44e-4   NR MEM2971321.1 3045160 g90446 i0 51.4 3.96363636363636 37 18 67.3 0 53 163 2 38 MEM2971321.1 DUF2283 domain-containing protein [Candidatus Bathyarchaeia archaeon] diamond 654 44.7 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
29270595 29270595 PRJNA312899_P_NODE_85909_length_167_cov_0.864407_g85467_i0 PRJNA312899 85909 167 0.864407 1.44355969 root 1 Root_unresolved Root_unresolved 41.6 0.0262   NR WP_252901390.1 1295370 g85467 i0 76.2 16.4730538922156 21 5 37.7 0 45 107 113 133 WP_252901390.1 M1 family aminopeptidase [Vulcanisaeta sp. JCM 14467] diamond 2751 42 0.990476190476191 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Vulcanisaeta Vulcanisaeta sp. JCM 14467
29789865 29789865 PRJNA312899_P_NODE_96991_length_163_cov_0.894737_g96549_i0 PRJNA312899 96991 163 0.894737 1.45842131 Nitrososphaera sp. 1971748 Archaea Archaea 97.1 3.98e-23   NR HEV8387235.1 1971748 g96549 i0 77.8 5.96319018404908 54 12 99.4 0 2 163 157 210 HEV8387235.1 DUF72 domain-containing protein [Nitrososphaera sp.] diamond 972 97.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
29948016 29948016 PRJNA312899_P_NODE_94811_length_164_cov_0.886957_g94369_i0 PRJNA312899 94811 164 0.886957 1.45460948 Thermoproteota archaeon 2056631 Archaea Archaea 63.2 7.92e-10   NR RLG43968.1 2056631 g94369 i0 68.5 1.97560975609756 54 17 98.8 0 3 164 286 339 RLG43968.1 MAG: helicase, partial [Thermoproteota archaeon] diamond 324 63.2 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32287640 32287640 PRJNA312899_P_NODE_72319_length_189_cov_1.457143_g71877_i0 PRJNA312899 72319 189 1.457143 2.75400027 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 107 2.9800000000000003e-27   NR HZB65072.1 2169593 g71877 i0 90.3 0.984126984126984 62 6 98.4 0 3 188 26 87 HZB65072.1 2-phospho-L-lactate guanylyltransferase [Nitrososphaeraceae archaeon] diamond 186 107 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32572253 32572253 PRJNA312899_P_NODE_43799_length_267_cov_6.513761_g43357_i0 PRJNA312899 43799 267 6.513761 17.39174187 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 157 1.94e-43   NR HEY7110298.1 2169593 g43357 i0 89.8 3.98876404494382 88 9 98.9 0 4 267 221 308 HEY7110298.1 ATP-binding protein [Nitrososphaeraceae archaeon] diamond 1065 157 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae 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);;