contig_metadata
18 rows where bioproject = "PRJNA438111" and tax_kingdom = "Promethearchaeati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 433805 | 433805 | PRJNA438111_P_NODE_1481_length_777_cov_10.905080_g1137_i0 | PRJNA438111 | 1481 | 777 | 10.90508 | 84.7324716 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 72 | 5.42e-12 | NR | MBD3228655.1 | 2053489 | g1137 | i0 | 54.8 | 0.281853281853282 | 73 | 30 | 28.2 | 2 | 777 | 559 | 7 | 76 | MBD3228655.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 219 | 72 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 4260806 | 4260806 | PRJNA438111_P_NODE_1664_length_737_cov_10.148305_g1137_i1 | PRJNA438111 | 1664 | 737 | 10.148305 | 74.79300785 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 72 | 4.3e-12 | NR | MBD3228655.1 | 2053489 | g1137 | i1 | 54.8 | 0.297150610583446 | 73 | 30 | 29.7 | 2 | 737 | 519 | 7 | 76 | MBD3228655.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 219 | 72 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 26981008 | 26981008 | PRJNA438111_P_NODE_78502_length_159_cov_2.184615_g77877_i0 | PRJNA438111 | 78502 | 159 | 2.184615 | 3.47353785 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 68.6 | 9.11e-12 | NR | NHJ86113.1 | 2591838 | g77877 | i0 | 64.7 | 4.81132075471698 | 51 | 18 | 96.2 | 0 | 3 | 155 | 298 | 348 | NHJ86113.1 elongation factor 1-alpha [Promethearchaeati archaeon] | diamond | 765 | 68.6 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 27833938 | 27833938 | PRJNA438111_P_NODE_16124_length_262_cov_36.982833_g15499_i0 | PRJNA438111 | 16124 | 262 | 36.982833 | 96.89502246 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 98.2 | 1.54e-21 | NR | TFG24093.1 | 2053489 | g15499 | i0 | 57.5 | 4.98091603053435 | 87 | 36 | 99.6 | 1 | 261 | 1 | 365 | 450 | TFG24093.1 MAG: hypothetical protein EU529_05205 [Promethearchaeota archaeon] | diamond | 1305 | 98.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28339290 | 28339290 | PRJNA438111_P_NODE_65766_length_167_cov_3.355072_g65141_i0 | PRJNA438111 | 65766 | 167 | 3.355072 | 5.60297024 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 59.3 | 1.88e-8 | NR | MDH5647635.1 | 2026747 | g65141 | i0 | 55.6 | 1.94011976047904 | 54 | 24 | 97 | 0 | 163 | 2 | 121 | 174 | MDH5647635.1 Zn-dependent oligopeptidase [Candidatus Heimdallarchaeota archaeon] | diamond | 324 | 59.3 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 29191838 | 29191838 | PRJNA438111_P_NODE_26929_length_211_cov_4.230769_g26304_i0 | PRJNA438111 | 26929 | 211 | 4.230769 | 8.92692259 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 49.3 | 1.12e-4 | NR | NHI93731.1 | 2053489 | g26304 | i0 | 46 | 1.35071090047393 | 50 | 27 | 71.1 | 0 | 158 | 9 | 245 | 294 | NHI93731.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 285 | 49.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29191858 | 29191858 | PRJNA438111_P_NODE_48249_length_183_cov_5.448052_g47624_i0 | PRJNA438111 | 48249 | 183 | 5.448052 | 9.96993516 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 55.8 | 3.89e-7 | NR | NHI91346.1 | 2053489 | g47624 | i0 | 60.5 | 1.88524590163934 | 38 | 14 | 62.3 | 1 | 182 | 69 | 313 | 349 | NHI91346.1 galactose oxidase [Promethearchaeota archaeon] | diamond | 345 | 55.8 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29902865 | 29902865 | PRJNA438111_P_NODE_731_length_1070_cov_9.560999_g537_i0 | PRJNA438111 | 731 | 1070 | 9.560999 | 102.3026893 | Promethearchaeati | 1935183 | Archaea | Archaea | 387 | 6.239999999999999e-128 | NR | NHJ04299.1 | 2026747 | g537 | i0 | 56.7 | 2.77570093457944 | 330 | 142 | 92.5 | 1 | 4 | 993 | 203 | 531 | NHJ04299.1 elongation factor 1-alpha [Candidatus Heimdallarchaeota archaeon] | diamond | 2970 | 389 | 0.994858611825193 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30233889 | 30233889 | PRJNA438111_P_NODE_14512_length_274_cov_8.718367_g13887_i0 | PRJNA438111 | 14512 | 274 | 8.718367 | 23.88832558 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 95.5 | 9.6e-21 | NR | TFF87028.1 | 2053491 | g13887 | i0 | 50.5 | 2.98905109489051 | 91 | 43 | 98.5 | 2 | 272 | 3 | 329 | 418 | TFF87028.1 MAG: saccharopine dehydrogenase [Candidatus Thorarchaeota archaeon] | diamond | 819 | 95.5 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 30313977 | 30313977 | PRJNA438111_P_NODE_22412_length_228_cov_3.050251_g21787_i0 | PRJNA438111 | 22412 | 228 | 3.050251 | 6.95457228 | Archaea | 2157 | Archaea | Archaea | 97.4 | 1.59e-21 | NR | MBD3192667.1 | 2026747 | g21787 | i0 | 63.2 | 2 | 76 | 28 | 100 | 0 | 1 | 228 | 37 | 112 | MBD3192667.1 elongation factor 1-alpha [Candidatus Heimdallarchaeota archaeon] | diamond | 456 | 97.4 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30392359 | 30392359 | PRJNA438111_P_NODE_24773_length_218_cov_7.095238_g24148_i0 | PRJNA438111 | 24773 | 218 | 7.095238 | 15.46761884 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 105 | 2.38e-24 | NR | NHJ49193.1 | 2591838 | g24148 | i0 | 72.2 | 2.97247706422018 | 72 | 19 | 99.1 | 1 | 2 | 217 | 128 | 198 | NHJ49193.1 elongation factor 1-alpha [Promethearchaeati archaeon] | diamond | 648 | 105 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 30960679 | 30960679 | PRJNA438111_P_NODE_13654_length_282_cov_2.778656_g13029_i0 | PRJNA438111 | 13654 | 282 | 2.778656 | 7.83580992 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 73.9 | 5.83e-13 | NR | UCC20174.1 | 2053489 | g13029 | i0 | 42 | 1.87234042553191 | 88 | 51 | 93.6 | 0 | 1 | 264 | 305 | 392 | UCC20174.1 MAG: NAD(P)/FAD-dependent oxidoreductase [Promethearchaeota archaeon] | diamond | 528 | 73.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31498212 | 31498212 | PRJNA438111_P_NODE_55096_length_176_cov_3.503401_g54471_i0 | PRJNA438111 | 55096 | 176 | 3.503401 | 6.16598576 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 69.3 | 6.07e-12 | NR | MBN1328457.1 | 2026747 | g54471 | i0 | 54.4 | 0.971590909090909 | 57 | 26 | 97.2 | 0 | 172 | 2 | 251 | 307 | MBN1328457.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Heimdallarchaeota archaeon] | diamond | 171 | 69.3 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 31577739 | 31577739 | PRJNA438111_P_NODE_44136_length_188_cov_6.150943_g43511_i0 | PRJNA438111 | 44136 | 188 | 6.150943 | 11.56377284 | root | 1 | Root_unresolved | Root_unresolved | 62.4 | 8.52e-10 | NR | TFF90919.1 | 2053489 | g43511 | i0 | 51.8 | 3.47872340425532 | 56 | 27 | 89.4 | 0 | 13 | 180 | 83 | 138 | TFF90919.1 MAG: hypothetical protein EU548_00525 [Promethearchaeota archaeon] | diamond | 654 | 62.8 | 0.993630573248408 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31656026 | 31656026 | PRJNA438111_P_NODE_71417_length_163_cov_5.164179_g70792_i0 | PRJNA438111 | 71417 | 163 | 5.164179 | 8.41761177 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 54.7 | 7.66e-7 | NR | TFF99897.1 | 2053489 | g70792 | i0 | 56.1 | 5.22699386503067 | 41 | 18 | 75.5 | 0 | 28 | 150 | 57 | 97 | TFF99897.1 MAG: MFS transporter [Promethearchaeota archaeon] | diamond | 852 | 54.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31687773 | 31687773 | PRJNA438111_P_NODE_56257_length_175_cov_2.691781_g55632_i0 | PRJNA438111 | 56257 | 175 | 2.691781 | 4.71061675 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 85.5 | 1.31e-18 | NR | MBN1803085.1 | 2053489 | g55632 | i0 | 66.1 | 3.73714285714286 | 56 | 19 | 96 | 0 | 173 | 6 | 150 | 205 | MBN1803085.1 ribose 5-phosphate isomerase A [Promethearchaeota archaeon] | diamond | 654 | 85.5 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32383834 | 32383834 | PRJNA438111_P_NODE_36459_length_201_cov_2.476744_g35834_i0 | PRJNA438111 | 36459 | 201 | 2.476744 | 4.97825544 | Promethearchaeati archaeon | 2591838 | Archaea | Archaea | 77 | 1.72e-14 | NR | NHJ49193.1 | 2591838 | g35834 | i0 | 54 | 0.940298507462687 | 63 | 29 | 94 | 0 | 3 | 191 | 28 | 90 | NHJ49193.1 elongation factor 1-alpha [Promethearchaeati archaeon] | diamond | 189 | 77 | 1 | Archaea | Promethearchaeati | Promethearchaeati archaeon | |||||||
| 32731175 | 32731175 | PRJNA438111_P_NODE_16580_length_259_cov_38.004348_g15955_i0 | PRJNA438111 | 16580 | 259 | 38.004348 | 98.43126132 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 98.2 | 1.48e-21 | NR | TFG24093.1 | 2053489 | g15955 | i0 | 58.1 | 0.996138996138996 | 86 | 35 | 99.6 | 1 | 2 | 259 | 1577 | 1661 | TFG24093.1 MAG: hypothetical protein EU529_05205 [Promethearchaeota archaeon] | diamond | 258 | 98.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon |
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);;