RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1144090" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 16 ✖

bioproject 1

  • PRJNA1144090 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
8686175 8686175 PRJNA1144090_P_NODE_77667_length_286_cov_1.765258_g77132_i0 PRJNA1144090 77667 286 1.765258 5.04863788 Nitrososphaerota archaeon 2026795 Archaea Archaea 77 5.28e-14   NR MDG6904333.1 2026795 g77132 i0 45.7 0.986013986013986 94 45 98.6 2 2 283 77 164 MDG6904333.1 IMP dehydrogenase [Nitrososphaerota archaeon] diamond 282 77 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
26806269 26806269 PRJNA1144090_P_NODE_54901_length_343_cov_2.111111_g54366_i0 PRJNA1144090 54901 343 2.111111 7.24111073 root 1 Root_unresolved Root_unresolved 113 6.84e-27   NR WP_157926633.1 1903276 g54366 i0 53.2 3.91836734693878 111 47 96.2 2 342 13 260 366 WP_157926633.1 NAD-dependent succinate-semialdehyde dehydrogenase [Candidatus Nitrosotalea okcheonensis] diamond 1344 113 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis
27122351 27122351 PRJNA1144090_P_NODE_87262_length_269_cov_1.576531_g86727_i0 PRJNA1144090 87262 269 1.576531 4.24086839 root 1 Root_unresolved Root_unresolved 43.1 0.036   NR MFL6310445.1 1971748 g86727 i0 40 3.37918215613383 40 24 44.6 0 250 131 360 399 MFL6310445.1 MBL fold metallo-hydrolase [Nitrososphaera sp.] diamond 909 43.5 0.990804597701149 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
27734226 27734226 PRJNA1144090_P_NODE_65044_length_314_cov_1.896266_g64509_i0 PRJNA1144090 65044 314 1.896266 5.95427524 Desulfurococcaceae archaeon 2184738 Archaea Archaea 48.1 0.00111   NR MEL9999848.1 2184738 g64509 i0 33.3 2.14968152866242 75 44 71.7 2 241 17 369 437 MEL9999848.1 isoleucine--tRNA ligase [Desulfurococcaceae archaeon] diamond 675 48.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae   Desulfurococcaceae archaeon
27828689 27828689 PRJNA1144090_P_NODE_92884_length_260_cov_1.647059_g92349_i0 PRJNA1144090 92884 260 1.647059 4.2823534 Nitrososphaerota archaeon 2026795 Archaea Archaea 54.7 2.92e-6   NR MDG6921989.1 2026795 g92349 i0 42.5 0.923076923076923 80 46 92.3 0 9 248 1401 1480 MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] diamond 240 54.7 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28207313 28207313 PRJNA1144090_P_NODE_42546_length_394_cov_3.501558_g42011_i0 PRJNA1144090 42546 394 3.501558 13.79613852 Thermoproteota archaeon 2056631 Archaea Archaea 48.5 0.00168   NR NPA85460.1 2056631 g42011 i0 27.6 0.746192893401015 98 71 74.6 0 93 386 13 110 NPA85460.1 acyl--CoA ligase [Thermoproteota archaeon] diamond 294 48.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28775763 28775763 PRJNA1144090_P_NODE_59187_length_330_cov_1.653696_g58652_i0 PRJNA1144090 59187 330 1.653696 5.4571968 Nitrososphaerota archaeon 2026795 Archaea Archaea 45.1 0.016   NR MDG6921989.1 2026795 g58652 i0 34.9 1.51818181818182 86 48 70.9 2 235 2 1388 1473 MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] diamond 501 45.1 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29091712 29091712 PRJNA1144090_P_NODE_77548_length_286_cov_2.169014_g77013_i0 PRJNA1144090 77548 286 2.169014 6.20338004 Desulfurococcales archaeon 2480821 Archaea Archaea 70.1 1.21e-11   NR MCD6340935.1 2480821 g77013 i0 43 3.9020979020979 93 50 97.6 2 8 286 26 115 MCD6340935.1 histone deacetylase [Desulfurococcales archaeon] diamond 1116 70.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales     Desulfurococcales archaeon
29849486 29849486 PRJNA1144090_P_NODE_90451_length_264_cov_1.497382_g89916_i0 PRJNA1144090 90451 264 1.497382 3.95308848 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 78.2 1.07e-14   NR MCW4041961.1 2026714 g89916 i0 55.6 13.4772727272727 72 32 81.8 0 3 218 12 83 MCW4041961.1 RNA 3'-terminal phosphate cyclase [Candidatus Bathyarchaeota archaeon] diamond 3558 78.2 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
30038817 30038817 PRJNA1144090_P_NODE_107011_length_246_cov_1.751445_g106476_i0 PRJNA1144090 107011 246 1.751445 4.3085547 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 53.5 6.74e-7   NR MEM2889529.1 3045160 g106476 i0 35.8 2.96341463414634 81 44 97.6 2 244 5 4 77 MEM2889529.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] diamond 729 53.5 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
30196695 30196695 PRJNA1144090_P_NODE_37832_length_421_cov_1.764368_g37297_i0 PRJNA1144090 37832 421 1.764368 7.42798928 Nitrososphaerota archaeon 2026795 Archaea Archaea 49.3 0.00135   NR MDG6921989.1 2026795 g37297 i0 40.4 0.370546318289786 52 31 37.1 0 230 385 500 551 MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] diamond 156 49.3 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
30386805 30386805 PRJNA1144090_P_NODE_12833_length_782_cov_5.111425_g12373_i0 PRJNA1144090 12833 782 5.111425 39.9713435 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 50.8 9.82e-4   NR MCJ7699859.1 2026714 g12373 i0 34.6 0.797953964194373 78 51 29.9 0 646 413 81 158 MCJ7699859.1 tRNA-intron lyase [Candidatus Bathyarchaeota archaeon] diamond 624 50.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
30386853 30386853 PRJNA1144090_P_NODE_51093_length_357_cov_1.355634_g50558_i0 PRJNA1144090 51093 357 1.355634 4.83961338 Nitrososphaerales archaeon 2268197 Archaea Archaea 78.2 1.62e-14   NR HEY4673260.1 2268197 g50558 i0 37.9 1.56302521008403 103 57 80.7 1 24 311 170 272 HEY4673260.1 tripartite tricarboxylate transporter TctB family protein [Nitrososphaerales archaeon] diamond 558 78.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
30860420 30860420 PRJNA1144090_P_NODE_5414_length_1228_cov_3.140260_g5114_i0 PRJNA1144090 5414 1228 3.14026 38.5623928 Candidatus Methanomethylicia archaeon 2268187 Archaea Archaea 52 0.00225   NR MEM0211596.1 2268187 g5114 i0 36.6 0.681596091205212 93 52 22.7 3 1120 842 84 169 MEM0211596.1 helix-hairpin-helix domain-containing protein [Candidatus Methanomethylicia archaeon] diamond 837 52 1 Archaea   Thermoproteati Thermoproteota Methanosuratincolia       Candidatus Methanomethylicia archaeon
30923820 30923820 PRJNA1144090_P_NODE_62614_length_320_cov_3.931174_g62079_i0 PRJNA1144090 62614 320 3.931174 12.5797568 Nitrososphaerota archaeon 2026795 Archaea Archaea 70.9 1.28e-11   NR MDG6921989.1 2026795 g62079 i0 37.5 0.975 104 65 97.5 0 312 1 1384 1487 MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] diamond 312 70.9 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
32093591 32093591 PRJNA1144090_P_NODE_38_length_5427_cov_8.702092_g29_i0 PRJNA1144090 38 5427 8.702092 472.26253284 Nitrososphaerota archaeon 2026795 Archaea Archaea 166 7.979999999999998e-37   NR MDG6921989.1 2026795 g29 i0 30.7 0.192924267551133 349 231 19 6 1048 17 1138 1480 MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] diamond 1047 166 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota 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);;