contig_metadata
13 rows where bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27173347 | 27173347 | PRJNA556992_P_NODE_847842_length_243_cov_3.188235_g845652_i0 | PRJNA556992 | 847842 | 243 | 3.188235 | 7.74741105 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 82.8 | 2.27e-16 | NR | MCK5345783.1 | 2026747 | g845652 | i0 | 46.9 | 1 | 81 | 43 | 100 | 0 | 243 | 1 | 77 | 157 | MCK5345783.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 243 | 82.8 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 27204575 | 27204575 | PRJNA556992_P_NODE_156842_length_353_cov_3.403571_g154654_i0 | PRJNA556992 | 156842 | 353 | 3.403571 | 12.01460563 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.9 | 0.0276 | NR | MBD3405030.1 | 2053489 | g154654 | i0 | 50 | 0.339943342776204 | 40 | 19 | 34 | 1 | 69 | 188 | 60 | 98 | MBD3405030.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 120 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 27236769 | 27236769 | PRJNA556992_P_NODE_90943_length_417_cov_2.331395_g88760_i0 | PRJNA556992 | 90943 | 417 | 2.331395 | 9.72191715 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 45.8 | 0.0133 | NR | MDF1540320.1 | 2053491 | g88760 | i0 | 28.3 | 0.712230215827338 | 99 | 69 | 71.2 | 1 | 298 | 2 | 47 | 143 | MDF1540320.1 hypothetical protein [Candidatus Thorarchaeota archaeon] | diamond | 297 | 45.8 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 27868116 | 27868116 | PRJNA556992_P_NODE_520725_length_265_cov_2.989583_g518536_i0 | PRJNA556992 | 520725 | 265 | 2.989583 | 7.92239495 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 111 | 6.11e-28 | NR | TFG98576.1 | 2053491 | g518536 | i0 | 57.3 | 1.00754716981132 | 89 | 37 | 99.6 | 1 | 265 | 2 | 45 | 133 | TFG98576.1 MAG: hypothetical protein E4H12_05735 [Candidatus Thorarchaeota archaeon] | diamond | 267 | 111 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 28720794 | 28720794 | PRJNA556992_P_NODE_391987_length_277_cov_2.799020_g389798_i0 | PRJNA556992 | 391987 | 277 | 2.79902 | 7.7532854 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 87.8 | 7.65e-18 | NR | TFH10346.1 | 2053491 | g389798 | i0 | 47.2 | 0.963898916967509 | 89 | 47 | 96.4 | 0 | 275 | 9 | 244 | 332 | TFH10346.1 MAG: hypothetical protein E4H14_02735 [Candidatus Thorarchaeota archaeon] | diamond | 267 | 87.8 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 28752266 | 28752266 | PRJNA556992_P_NODE_48207_length_520_cov_1.854586_g46049_i0 | PRJNA556992 | 48207 | 520 | 1.854586 | 9.6438472 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 100 | 2.4399999999999999e-23 | NR | TFG95627.1 | 2053491 | g46049 | i0 | 40.2 | 1.45961538461538 | 122 | 68 | 68.1 | 2 | 82 | 435 | 1 | 121 | TFG95627.1 MAG: hypothetical protein E4H12_12900 [Candidatus Thorarchaeota archaeon] | diamond | 759 | 100 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 28910111 | 28910111 | PRJNA556992_P_NODE_965908_length_234_cov_2.695652_g963718_i0 | PRJNA556992 | 965908 | 234 | 2.695652 | 6.30782568 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 56.6 | 1.57e-7 | NR | MBN2229563.1 | 2053491 | g963718 | i0 | 49.2 | 5.03846153846154 | 61 | 25 | 75.6 | 2 | 7 | 183 | 127 | 183 | MBN2229563.1 50S ribosomal protein L6 [Candidatus Thorarchaeota archaeon] | diamond | 1179 | 56.6 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 28973263 | 28973263 | PRJNA556992_P_NODE_1173068_length_196_cov_6.577236_g1170877_i0 | PRJNA556992 | 1173068 | 196 | 6.577236 | 12.89138256 | Candidatus Odinarchaeota archaeon | 2053490 | Archaea | Archaea | 94.7 | 6.06e-22 | NR | MCD6485172.1 | 2053490 | g1170877 | i0 | 65.1 | 0.964285714285714 | 63 | 22 | 96.4 | 0 | 192 | 4 | 50 | 112 | MCD6485172.1 glycosyltransferase [Candidatus Odinarchaeota archaeon] | diamond | 189 | 94.7 | 1 | Archaea | Promethearchaeati | Candidatus Odinarchaeota | Candidatus Odinarchaeota archaeon | ||||||
| 29478000 | 29478000 | PRJNA556992_P_NODE_1167490_length_197_cov_9.967742_g1165299_i0 | PRJNA556992 | 1167490 | 197 | 9.967742 | 19.63645174 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 69.3 | 5.81e-12 | NR | TFH10500.1 | 2053491 | g1165299 | i0 | 51.7 | 4.56852791878173 | 60 | 28 | 89.8 | 1 | 1 | 177 | 251 | 310 | TFH10500.1 MAG: AAA family ATPase [Candidatus Thorarchaeota archaeon] | diamond | 900 | 69.3 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 30520697 | 30520697 | PRJNA556992_P_NODE_154173_length_355_cov_2.879433_g151985_i0 | PRJNA556992 | 154173 | 355 | 2.879433 | 10.22198715 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 80.1 | 1.06e-14 | NR | TFH10346.1 | 2053491 | g151985 | i0 | 45.8 | 0.904225352112676 | 107 | 51 | 85.4 | 4 | 303 | 1 | 140 | 245 | TFH10346.1 MAG: hypothetical protein E4H14_02735 [Candidatus Thorarchaeota archaeon] | diamond | 321 | 80.1 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 31058594 | 31058594 | PRJNA556992_P_NODE_921255_length_238_cov_6.012121_g919065_i0 | PRJNA556992 | 921255 | 238 | 6.012121 | 14.30884798 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 51.2 | 3.58e-5 | NR | NMC08204.1 | 2053489 | g919065 | i0 | 35.2 | 0.894957983193277 | 71 | 46 | 89.5 | 0 | 231 | 19 | 439 | 509 | NMC08204.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 213 | 51.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31215700 | 31215700 | PRJNA556992_P_NODE_716855_length_250_cov_2.237288_g714666_i0 | PRJNA556992 | 716855 | 250 | 2.237288 | 5.59322 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 48.1 | 4.91e-4 | NR | MBD3339177.1 | 2053489 | g714666 | i0 | 70.6 | 0.408 | 34 | 10 | 40.8 | 0 | 1 | 102 | 333 | 366 | MBD3339177.1 type III-B CRISPR module RAMP protein Cmr6 [Promethearchaeota archaeon] | diamond | 102 | 48.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31753600 | 31753600 | PRJNA556992_P_NODE_398857_length_277_cov_1.132353_g396668_i0 | PRJNA556992 | 398857 | 277 | 1.132353 | 3.13661781 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 50.8 | 2.45e-5 | NR | MBD3406177.1 | 2053489 | g396668 | i0 | 62.8 | 0.465703971119134 | 43 | 14 | 46.6 | 1 | 122 | 250 | 1 | 41 | MBD3406177.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 129 | 50.8 | 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);;