contig_metadata
18 rows where bioproject = "PRJEB14664" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8638820 | 8638820 | PRJEB14664_P_NODE_11667_length_217_cov_1.538462_g11537_i0 | PRJEB14664 | 11667 | 217 | 1.538462 | 3.33846254 | archaeon | 1906665 | Archaea | Archaea | 118 | 3.6e-29 | NR | MDP2437013.1 | 1906665 | g11537 | i0 | 72.2 | 8.95852534562212 | 72 | 20 | 99.5 | 0 | 216 | 1 | 306 | 377 | MDP2437013.1 adenosylhomocysteinase [archaeon] | diamond | 1944 | 118 | 1 | Archaea | archaeon | ||||||||
| 9913921 | 9913921 | PRJEB14664_P_NODE_16768_length_170_cov_1.051852_g16638_i0 | PRJEB14664 | 16768 | 170 | 1.051852 | 1.7881484 | archaeon | 1906665 | Archaea | Archaea | 89.7 | 2.68e-19 | NR | MDP2434733.1 | 1906665 | g16638 | i0 | 73.2 | 0.988235294117647 | 56 | 15 | 98.8 | 0 | 3 | 170 | 321 | 376 | MDP2434733.1 60S ribosomal protein L3 [archaeon] | diamond | 168 | 89.7 | 1 | Archaea | archaeon | ||||||||
| 22973207 | 22973207 | PRJEB14664_P_NODE_2559_length_570_cov_3.228037_g2445_i0 | PRJEB14664 | 2559 | 570 | 3.228037 | 18.3998109 | root | 1 | Root_unresolved | Root_unresolved | 275 | 2.0100000000000006e-91 | NR | MCQ2821492.1 | 1906665 | g2445 | i0 | 73 | 5.96842105263158 | 189 | 51 | 99.5 | 0 | 568 | 2 | 2 | 190 | MCQ2821492.1 50S ribosomal protein L15e [archaeon] | diamond | 3402 | 275 | 1 | Archaea | archaeon | ||||||||
| 26652926 | 26652926 | PRJEB14664_P_NODE_9581_length_249_cov_1.985981_g9451_i0 | PRJEB14664 | 9581 | 249 | 1.985981 | 4.94509269 | archaeon | 1906665 | Archaea | Archaea | 61.2 | 6.04e-9 | NR | RYH14964.1 | 1906665 | g9451 | i0 | 45.8 | 4.62650602409639 | 83 | 35 | 88 | 3 | 220 | 2 | 13 | 95 | RYH14964.1 MAG: glutathione S-transferase family protein [archaeon] | diamond | 1152 | 61.2 | 1 | Archaea | archaeon | ||||||||
| 26716082 | 26716082 | PRJEB14664_P_NODE_15061_length_182_cov_1.897959_g14931_i0 | PRJEB14664 | 15061 | 182 | 1.897959 | 3.45428538 | halophilic archaeon J | 29295 | Archaea | Archaea | 48.1 | 2.02e-4 | NR | ERH09861.1 | 1085028 | g14931 | i0 | 49 | 2.55494505494505 | 49 | 23 | 80.8 | 1 | 173 | 27 | 185 | 231 | ERH09861.1 MAG: hypothetical protein J07HX64_01624 [halophilic archaeon J07HX64] | diamond | 465 | 48.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic archaeon J07HX64 | |||
| 26843382 | 26843382 | PRJEB14664_P_NODE_17261_length_166_cov_1.312977_g17131_i0 | PRJEB14664 | 17261 | 166 | 1.312977 | 2.17954182 | archaeon | 1906665 | Archaea | Archaea | 79 | 2.94e-17 | NR | RYY86504.1 | 1906665 | g17131 | i0 | 66 | 0.903614457831325 | 50 | 17 | 90.4 | 0 | 15 | 164 | 41 | 90 | RYY86504.1 MAG: hypothetical protein EON63_05640 [archaeon] | diamond | 150 | 79 | 1 | Archaea | archaeon | ||||||||
| 27096197 | 27096197 | PRJEB14664_P_NODE_12702_length_204_cov_2.573964_g12572_i0 | PRJEB14664 | 12702 | 204 | 2.573964 | 5.25088656 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 56.2 | 3.77e-7 | NR | MDG6996308.1 | 2026795 | g12572 | i0 | 69.4 | 0.529411764705882 | 36 | 11 | 52.9 | 0 | 194 | 87 | 422 | 457 | MDG6996308.1 cupredoxin domain-containing protein [Nitrososphaerota archaeon] | diamond | 108 | 56.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 27444212 | 27444212 | PRJEB14664_P_NODE_18243_length_160_cov_1.280000_g18113_i0 | PRJEB14664 | 18243 | 160 | 1.28 | 2.048 | archaeon | 1906665 | Archaea | Archaea | 47.4 | 5.74e-5 | NR | MDP2439853.1 | 1906665 | g18113 | i0 | 42.9 | 0.91875 | 49 | 28 | 91.9 | 0 | 149 | 3 | 3 | 51 | MDP2439853.1 hypothetical protein [archaeon] | diamond | 147 | 47.4 | 1 | Archaea | archaeon | ||||||||
| 27665110 | 27665110 | PRJEB14664_P_NODE_7804_length_286_cov_2.768924_g7674_i0 | PRJEB14664 | 7804 | 286 | 2.768924 | 7.91912264 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 65.9 | 2.92e-11 | NR | OLS12533.1 | 1849166 | g7674 | i0 | 38.2 | 0.933566433566434 | 89 | 53 | 93.4 | 2 | 18 | 284 | 7 | 93 | OLS12533.1 MAG: hypothetical protein RBG13Loki_3844 [Promethearchaeota archaeon CR_4] | diamond | 267 | 65.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 | ||||||
| 28479544 | 28479544 | PRJEB14664_P_NODE_5706_length_350_cov_1.568254_g5576_i0 | PRJEB14664 | 5706 | 350 | 1.568254 | 5.488889 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 1.43e-6 | NR | MCK9298840.1 | 90427 | g5576 | i0 | 37.8 | 3.19714285714286 | 90 | 36 | 77.1 | 3 | 345 | 76 | 172 | 241 | MCK9298840.1 exo-alpha-sialidase [Methanoculleus sp.] | diamond | 1119 | 57 | 0.992982456140351 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 28706971 | 28706971 | PRJEB14664_P_NODE_18807_length_157_cov_1.311475_g18677_i0 | PRJEB14664 | 18807 | 157 | 1.311475 | 2.05901575 | archaeon | 1906665 | Archaea | Archaea | 102 | 3.38e-26 | NR | RYG68742.1 | 1906665 | g18677 | i0 | 88.2 | 0.974522292993631 | 51 | 6 | 97.5 | 0 | 155 | 3 | 5 | 55 | RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] | diamond | 153 | 102 | 1 | Archaea | archaeon | ||||||||
| 29212197 | 29212197 | PRJEB14664_P_NODE_13929_length_192_cov_1.757962_g13799_i0 | PRJEB14664 | 13929 | 192 | 1.757962 | 3.37528704 | Haloferax sp. YSMS24 | 3388425 | Archaea | Archaea | 40.4 | 0.0444 | NR | WP_411966181.1 | 3388425 | g13799 | i0 | 57.1 | 0.546875 | 35 | 7 | 42.2 | 2 | 46 | 126 | 62 | 96 | WP_411966181.1 hypothetical protein [Haloferax sp. YSMS24] | diamond | 105 | 40.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. YSMS24 | |
| 29432740 | 29432740 | PRJEB14664_P_NODE_14470_length_188_cov_1.215686_g14340_i0 | PRJEB14664 | 14470 | 188 | 1.215686 | 2.28548968 | archaeon | 1906665 | Archaea | Archaea | 64.7 | 4.61e-11 | NR | MDP2438822.1 | 1906665 | g14340 | i0 | 88.6 | 0.558510638297872 | 35 | 4 | 55.9 | 0 | 168 | 64 | 128 | 162 | MDP2438822.1 50S ribosomal protein L11 [archaeon] | diamond | 105 | 64.7 | 1 | Archaea | archaeon | ||||||||
| 30033167 | 30033167 | PRJEB14664_P_NODE_19211_length_155_cov_1.333333_g19081_i0 | PRJEB14664 | 19211 | 155 | 1.333333 | 2.06666615 | archaeon | 1906665 | Archaea | Archaea | 49.3 | 5.41e-5 | NR | MDP2436786.1 | 1906665 | g19081 | i0 | 46.8 | 1.2 | 62 | 22 | 98.7 | 1 | 3 | 155 | 55 | 116 | MDP2436786.1 hypothetical protein [archaeon] | diamond | 186 | 49.3 | 1 | Archaea | archaeon | ||||||||
| 30064532 | 30064532 | PRJEB14664_P_NODE_14612_length_186_cov_1.854305_g14482_i0 | PRJEB14664 | 14612 | 186 | 1.854305 | 3.4490073 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 87.4 | 1.81e-18 | NR | MDD1714532.1 | 2485498 | g14482 | i0 | 61 | 0.951612903225806 | 59 | 23 | 95.2 | 0 | 185 | 9 | 255 | 313 | MDD1714532.1 PQQ-dependent sugar dehydrogenase [Methanoregulaceae archaeon] | diamond | 177 | 87.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 31107172 | 31107172 | PRJEB14664_P_NODE_11195_length_224_cov_1.253968_g11065_i0 | PRJEB14664 | 11195 | 224 | 1.253968 | 2.80888832 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 109 | 3.96e-26 | NR | HIK01832.1 | 2756142 | g11065 | i0 | 68.5 | 0.977678571428571 | 73 | 23 | 97.8 | 0 | 4 | 222 | 204 | 276 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 219 | 109 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | ||||
| 31107180 | 31107180 | PRJEB14664_P_NODE_15755_length_177_cov_1.126761_g15625_i0 | PRJEB14664 | 15755 | 177 | 1.126761 | 1.99436697 | archaeon | 1906665 | Archaea | Archaea | 68.6 | 1.23e-11 | NR | MDP2436218.1 | 1906665 | g15625 | i0 | 59.3 | 1 | 59 | 24 | 100 | 0 | 177 | 1 | 477 | 535 | MDP2436218.1 acyl-CoA dehydrogenase C-terminal domain-containing protein [archaeon] | diamond | 177 | 68.6 | 1 | Archaea | archaeon | ||||||||
| 31518492 | 31518492 | PRJEB14664_P_NODE_1336_length_802_cov_2.092568_g1242_i0 | PRJEB14664 | 1336 | 802 | 2.092568 | 16.78239536 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 48.9 | 0.00403 | NR | MBD3187111.1 | 2026714 | g1242 | i0 | 23.3 | 0.673316708229426 | 180 | 110 | 63.6 | 6 | 748 | 239 | 8 | 169 | MBD3187111.1 GTP-binding protein [Candidatus Bathyarchaeota archaeon] | diamond | 540 | 48.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota 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);;