contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax_clade = "Stenosarchaea group"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23434575 | 23434575 | PRJNA498309_S_NODE_27699_length_330_cov_2.755932_g25531_i0 | PRJNA498309 | 27699 | 330 | 2.755932 | 9.0945756 | Halalkalicoccus subterraneus | 2675002 | Archaea | Archaea | 146 | 1.17e-40 | NR | WP_245998556.1 | 2675002 | g25531 | i0 | 82 | 0.809090909090909 | 89 | 16 | 80.9 | 0 | 327 | 61 | 222 | 310 | WP_245998556.1 transposase [Halalkalicoccus subterraneus] | diamond | 267 | 146 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus subterraneus | |
| 26855780 | 26855780 | PRJNA498309_S_NODE_20061_length_456_cov_59.503563_g17956_i0 | PRJNA498309 | 20061 | 456 | 59.503563 | 271.33624728 | Halalkalicoccus subterraneus | 2675002 | Archaea | Archaea | 80.5 | 4.18e-17 | NR | WP_162993962.1 | 2675002 | g17956 | i0 | 75.6 | 0.598684210526316 | 45 | 11 | 29.6 | 0 | 191 | 57 | 1 | 45 | WP_162993962.1 DUF7563 family protein [Halalkalicoccus subterraneus] | diamond | 273 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus subterraneus | |
| 27330060 | 27330060 | PRJNA498309_S_NODE_41003_length_207_cov_1.982558_g38835_i0 | PRJNA498309 | 41003 | 207 | 1.982558 | 4.10389506 | Halalkalicoccus tibetensis | 175632 | Archaea | Archaea | 135 | 7.75e-37 | NR | WP_340602647.1 | 175632 | g38835 | i0 | 95.5 | 3.84057971014493 | 66 | 3 | 95.7 | 0 | 10 | 207 | 130 | 195 | WP_340602647.1 zinc-dependent metalloprotease [Halalkalicoccus tibetensis] | diamond | 795 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus tibetensis | |
| 27393282 | 27393282 | PRJNA498309_S_NODE_28523_length_319_cov_2.433099_g26355_i0 | PRJNA498309 | 28523 | 319 | 2.433099 | 7.76158581 | Halalkalicoccus sp. | 1973143 | Archaea | Archaea | 129 | 1.35e-36 | NR | MCL7418433.1 | 1973143 | g26355 | i0 | 72.7 | 1.44827586206897 | 77 | 21 | 72.4 | 0 | 28 | 258 | 1 | 77 | MCL7418433.1 hypothetical protein [Halalkalicoccus sp.] | diamond | 462 | 129 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus sp. | |
| 27772216 | 27772216 | PRJNA498309_P_NODE_94064_length_208_cov_29.953216_g91915_i0 | PRJNA498309 | 94064 | 208 | 29.953216 | 62.30268928 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 42 | 0.0315 | NR | MCJ7445187.1 | 2595067 | g91915 | i0 | 46.2 | 0.5625 | 39 | 21 | 56.3 | 0 | 117 | 1 | 107 | 145 | MCJ7445187.1 imidazoleglycerol-phosphate dehydratase [Methanotrichaceae archaeon] | diamond | 117 | 42 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 28056087 | 28056087 | PRJNA498309_S_NODE_54205_length_150_cov_3.182609_g52037_i0 | PRJNA498309 | 54205 | 150 | 3.182609 | 4.7739135 | Halococcus salifodinae | 36738 | Archaea | Archaea | 41.6 | 0.00724 | NR | WP_005042062.1 | 36738 | g52037 | i0 | 88.9 | 0.72 | 18 | 2 | 36 | 0 | 148 | 95 | 74 | 91 | WP_005042062.1 hypothetical protein [Halococcus salifodinae] | diamond | 108 | 41.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salifodinae | |
| 28308810 | 28308810 | PRJNA498309_P_NODE_122246_length_152_cov_1.017391_g120097_i0 | PRJNA498309 | 122246 | 152 | 1.017391 | 1.54643432 | Haloferacaceae archaeon | 2080321 | Archaea | Archaea | 65.9 | 7.44e-11 | NR | MFB6097346.1 | 2080321 | g120097 | i0 | 77.8 | 0.710526315789474 | 36 | 8 | 71.1 | 0 | 150 | 43 | 572 | 607 | MFB6097346.1 thiamine pyrophosphate-binding protein [Haloferacaceae archaeon] | diamond | 108 | 65.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon | ||
| 28924003 | 28924003 | PRJNA498309_S_NODE_26788_length_342_cov_56.557003_g24620_i0 | PRJNA498309 | 26788 | 342 | 56.557003 | 193.42495026 | Halobacteriales | 2235 | Archaea | Archaea | 69.3 | 1.14e-11 | NR | WP_227778749.1 | 1008152 | g24620 | i0 | 70.5 | 2.31578947368421 | 44 | 13 | 38.6 | 0 | 26 | 157 | 134 | 177 | WP_227778749.1 helix-turn-helix domain-containing protein [Haladaptatus pallidirubidus] | diamond | 792 | 69.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus pallidirubidus | |
| 28924005 | 28924005 | PRJNA498309_S_NODE_35288_length_247_cov_2.707547_g33120_i0 | PRJNA498309 | 35288 | 247 | 2.707547 | 6.68764109 | Natrialbaceae | 1644061 | Archaea | Archaea | 117 | 1.48e-29 | NR | WP_076147264.1 | 301967 | g33120 | i0 | 81.1 | 8.10121457489879 | 74 | 14 | 89.9 | 0 | 223 | 2 | 215 | 288 | WP_076147264.1 KaiC domain-containing protein [Natrinema saccharevitans] | diamond | 2001 | 117 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema saccharevitans | |
| 29319031 | 29319031 | PRJNA498309_P_NODE_100809_length_192_cov_1.948387_g98660_i0 | PRJNA498309 | 100809 | 192 | 1.948387 | 3.74090304 | Halalkalicoccus | 332246 | Archaea | Archaea | 125 | 5.26e-32 | NR | WP_332097912.1 | 332246 | g98660 | i0 | 88.9 | 0.984375 | 63 | 7 | 98.4 | 0 | 190 | 2 | 367 | 429 | WP_332097912.1 MULTISPECIES: polysaccharide deacetylase family protein [Halalkalicoccus] | diamond | 189 | 125 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | ||
| 29666058 | 29666058 | PRJNA498309_P_NODE_72050_length_278_cov_2.112033_g69901_i0 | PRJNA498309 | 72050 | 278 | 2.112033 | 5.87145174 | Halococcus thailandensis | 335952 | Archaea | Archaea | 112 | 2.95e-29 | NR | WP_007736893.1 | 335952 | g69901 | i0 | 67.1 | 0.884892086330935 | 82 | 27 | 88.5 | 0 | 8 | 253 | 26 | 107 | WP_007736893.1 hypothetical protein [Halococcus thailandensis] | diamond | 246 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus thailandensis | |
| 29697565 | 29697565 | PRJNA498309_P_NODE_32710_length_494_cov_4.844639_g30686_i0 | PRJNA498309 | 32710 | 494 | 4.844639 | 23.93251666 | Candidatus Nanohaloarchaea archaeon | 2594798 | Archaea | Archaea | 45.4 | 0.0496 | NR | MFB6209555.1 | 2594798 | g30686 | i0 | 27 | 0.965587044534413 | 159 | 93 | 88.7 | 8 | 489 | 52 | 148 | 296 | MFB6209555.1 helicase C-terminal domain-containing protein [Candidatus Nanohaloarchaea archaeon] | diamond | 477 | 45.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Nanohaloarchaea | Candidatus Nanohaloarchaea archaeon | ||||
| 30045306 | 30045306 | PRJNA498309_P_NODE_74651_length_269_cov_1.487069_g72502_i0 | PRJNA498309 | 74651 | 269 | 1.487069 | 4.00021561 | Natronorarus salvus | 3117733 | Archaea | Archaea | 58.5 | 8.15e-8 | NR | WP_331235731.1 | 3117733 | g72502 | i0 | 80 | 0.33457249070632 | 30 | 6 | 33.5 | 0 | 91 | 2 | 1 | 30 | WP_331235731.1 helix-turn-helix domain-containing protein [Natronorarus salvus] | diamond | 90 | 58.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halalkalicoccaceae | Natronorarus | Natronorarus salvus | |
| 30787650 | 30787650 | PRJNA498309_P_NODE_74294_length_270_cov_2.210300_g72145_i0 | PRJNA498309 | 74294 | 270 | 2.2103 | 5.96781 | Halobacteriales | 2235 | Archaea | Archaea | 81.6 | 1.05e-15 | NR | WP_129113618.1 | 2071624 | g72145 | i0 | 48.1 | 3.51111111111111 | 81 | 42 | 90 | 0 | 251 | 9 | 481 | 561 | WP_129113618.1 hydantoinase/oxoprolinase family protein [Halegenticoccus tardaugens] | diamond | 948 | 82 | 0.995121951219512 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halegenticoccus | Halegenticoccus tardaugens | |
| 30961814 | 30961814 | PRJNA498309_S_NODE_30014_length_300_cov_787.618868_g27846_i0 | PRJNA498309 | 30014 | 300 | 787.618868 | 2362.856604 | Halococcus thailandensis | 335952 | Archaea | Archaea | 112 | 5.52e-29 | NR | WP_007736893.1 | 335952 | g27846 | i0 | 65.9 | 0.85 | 85 | 29 | 85 | 0 | 12 | 266 | 23 | 107 | WP_007736893.1 hypothetical protein [Halococcus thailandensis] | diamond | 255 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus thailandensis | |
| 30993383 | 30993383 | PRJNA498309_P_NODE_83434_length_239_cov_28.183168_g81285_i0 | PRJNA498309 | 83434 | 239 | 28.183168 | 67.35777152 | Natrialba sp. SSL1 | 1869245 | Archaea | Archaea | 130 | 3.41e-33 | NR | WP_071401651.1 | 1869245 | g81285 | i0 | 96.7 | 0.765690376569038 | 61 | 2 | 76.6 | 0 | 22 | 204 | 7 | 67 | WP_071401651.1 heavy metal translocating P-type ATPase [Natrialba sp. SSL1] | diamond | 183 | 130 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba sp. SSL1 | |
| 31594234 | 31594234 | PRJNA498309_P_NODE_52696_length_362_cov_4.196923_g50548_i0 | PRJNA498309 | 52696 | 362 | 4.196923 | 15.19286126 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 115 | 6.410000000000001e-27 | NR | MFA5559254.1 | 2666341 | g50548 | i0 | 80.6 | 1.11049723756906 | 67 | 13 | 55.5 | 0 | 208 | 8 | 120 | 186 | MFA5559254.1 DNA polymerase III subunit alpha [Methanofastidiosum sp.] | diamond | 402 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 31641081 | 31641081 | PRJNA498309_S_NODE_30016_length_300_cov_411.215094_g27848_i0 | PRJNA498309 | 30016 | 300 | 411.215094 | 1233.645282 | Halobacteriales | 2235 | Archaea | Archaea | 81.6 | 1.6e-15 | NR | WP_129113618.1 | 2071624 | g27848 | i0 | 48.1 | 3.95 | 81 | 42 | 81 | 0 | 279 | 37 | 481 | 561 | WP_129113618.1 hydantoinase/oxoprolinase family protein [Halegenticoccus tardaugens] | diamond | 1185 | 82 | 0.995121951219512 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halegenticoccus | Halegenticoccus tardaugens | |
| 31910359 | 31910359 | PRJNA498309_P_NODE_89917_length_220_cov_2.000000_g87768_i0 | PRJNA498309 | 89917 | 220 | 2 | 4.4 | Halocatena salina | 2934340 | Archaea | Archaea | 54.3 | 1.46e-6 | NR | WP_247995607.1 | 2934340 | g87768 | i0 | 67.6 | 0.504545454545455 | 37 | 12 | 50.5 | 0 | 35 | 145 | 181 | 217 | WP_247995607.1 helix-turn-helix domain-containing protein [Halocatena salina] | diamond | 111 | 54.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena salina | |
| 32416756 | 32416756 | PRJNA498309_S_NODE_42639_length_198_cov_1.674847_g40471_i0 | PRJNA498309 | 42639 | 198 | 1.674847 | 3.31619706 | Halococcus salifodinae | 36738 | Archaea | Archaea | 78.6 | 4.01e-17 | NR | WP_005042062.1 | 36738 | g40471 | i0 | 68.5 | 1.59090909090909 | 54 | 17 | 81.8 | 0 | 9 | 170 | 3 | 56 | WP_005042062.1 hypothetical protein [Halococcus salifodinae] | diamond | 315 | 78.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salifodinae | |
| 32732351 | 32732351 | PRJNA498309_S_NODE_28240_length_322_cov_251.073171_g26072_i0 | PRJNA498309 | 28240 | 322 | 251.073171 | 808.45561062 | Natronorarus salvus | 3117733 | Archaea | Archaea | 70.5 | 5.46e-12 | NR | WP_331235731.1 | 3117733 | g26072 | i0 | 78.4 | 0.34472049689441 | 37 | 8 | 34.5 | 0 | 120 | 10 | 1 | 37 | WP_331235731.1 helix-turn-helix domain-containing protein [Natronorarus salvus] | diamond | 111 | 70.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halalkalicoccaceae | Natronorarus | Natronorarus salvus | |
| 32841993 | 32841993 | PRJNA498309_S_NODE_27760_length_329_cov_3.098639_g25592_i0 | PRJNA498309 | 27760 | 329 | 3.098639 | 10.19452231 | Natronomonas | 63743 | Archaea | Archaea | 171 | 3.83e-49 | NR | WP_268105892.1 | 1046043 | g25592 | i0 | 76.9 | 1.89665653495441 | 104 | 24 | 94.8 | 0 | 314 | 3 | 165 | 268 | WP_268105892.1 acyl-CoA dehydrogenase family protein [Natronomonas gomsonensis] | diamond | 624 | 171 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas gomsonensis |
Advanced export
JSON shape: default, array, newline-delimited
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);;