contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA849646" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9766231 | 9766231 | PRJNA849646_P_NODE_24308_length_260_cov_2.080214_g24190_i0 | PRJNA849646 | 24308 | 260 | 2.080214 | 5.4085564 | archaeon | 1906665 | Archaea | Archaea | 101 | 5.219999999999999e-23 | NR | NCQ52188.1 | 1906665 | g24190 | i0 | 62.8 | 0.992307692307692 | 86 | 31 | 99.2 | 1 | 260 | 3 | 102 | 186 | NCQ52188.1 DNA repair protein RadA [archaeon] | diamond | 258 | 101 | 1 | Archaea | archaeon | ||||||||
| 13591897 | 13591897 | PRJNA849646_P_NODE_26051_length_257_cov_1.342391_g25933_i0 | PRJNA849646 | 26051 | 257 | 1.342391 | 3.44994487 | Halorussus salinisoli | 2558242 | Archaea | Archaea | 143 | 3.3599999999999998e-40 | NR | WP_137287559.1 | 2558242 | g25933 | i0 | 75.3 | 0.992217898832685 | 85 | 21 | 99.2 | 0 | 3 | 257 | 9 | 93 | WP_137287559.1 arylamine N-acetyltransferase family protein [Halorussus salinisoli] | diamond | 255 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus salinisoli | |
| 14866217 | 14866217 | PRJNA849646_P_NODE_2832_length_339_cov_1.157895_g2714_i0 | PRJNA849646 | 2832 | 339 | 1.157895 | 3.92526405 | archaeon | 1906665 | Archaea | Archaea | 169 | 3.2399999999999998e-46 | NR | NCQ51755.1 | 1906665 | g2714 | i0 | 74.8 | 0.982300884955752 | 111 | 28 | 98.2 | 0 | 337 | 5 | 640 | 750 | NCQ51755.1 DNA mismatch repair protein MutS [archaeon] | diamond | 333 | 169 | 1 | Archaea | archaeon | ||||||||
| 16140915 | 16140915 | PRJNA849646_P_NODE_23333_length_262_cov_1.629630_g23215_i0 | PRJNA849646 | 23333 | 262 | 1.62963 | 4.2696306 | Halomicrobium zhouii | 767519 | Archaea | Archaea | 115 | 1.32e-27 | NR | WP_143117730.1 | 767519 | g23215 | i0 | 63.5 | 1.94656488549618 | 85 | 31 | 97.3 | 0 | 7 | 261 | 230 | 314 | WP_143117730.1 FAD-dependent oxidoreductase [Halomicrobium zhouii] | diamond | 510 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halomicrobium | Halomicrobium zhouii | |
| 19964802 | 19964802 | PRJNA849646_P_NODE_40296_length_234_cov_2.645963_g40178_i0 | PRJNA849646 | 40296 | 234 | 2.645963 | 6.19155342 | root | 1 | Root_unresolved | Root_unresolved | 116 | 3.9199999999999995e-30 | NR | NCP72581.1 | 1906665 | g40178 | i0 | 70.1 | 24.6666666666667 | 77 | 23 | 98.7 | 0 | 3 | 233 | 74 | 150 | NCP72581.1 UMP kinase [archaeon] | diamond | 5772 | 117 | 0.991452991452991 | Archaea | archaeon | ||||||||
| 26833459 | 26833459 | PRJNA849646_P_NODE_29741_length_250_cov_3.457627_g29623_i0 | PRJNA849646 | 29741 | 250 | 3.457627 | 8.6440675 | archaeon | 1906665 | Archaea | Archaea | 78.6 | 3e-15 | NR | NCP98219.1 | 1906665 | g29623 | i0 | 45.3 | 0.9 | 75 | 41 | 90 | 0 | 21 | 245 | 1 | 75 | NCP98219.1 hypothetical protein [archaeon] | diamond | 225 | 78.6 | 1 | Archaea | archaeon | ||||||||
| 26968207 | 26968207 | PRJNA849646_P_NODE_19842_length_269_cov_1.183673_g19724_i0 | PRJNA849646 | 19842 | 269 | 1.183673 | 3.18408037 | Methanobacterium | 2160 | Archaea | Archaea | 95.1 | 9.94e-21 | NR | MEN4017723.1 | 2164 | g19724 | i0 | 56.3 | 2.86617100371747 | 87 | 30 | 97 | 1 | 269 | 9 | 93 | 171 | MEN4017723.1 MnmC family methyltransferase [Methanobacterium sp.] | diamond | 771 | 95.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 27402655 | 27402655 | PRJNA849646_P_NODE_22663_length_263_cov_2.047368_g22545_i0 | PRJNA849646 | 22663 | 263 | 2.047368 | 5.38457784 | archaeon | 1906665 | Archaea | Archaea | 73.6 | 1.17e-13 | NR | NCQ51857.1 | 1906665 | g22545 | i0 | 66.7 | 1.24334600760456 | 54 | 18 | 61.6 | 0 | 165 | 4 | 3 | 56 | NCQ51857.1 DUF285 domain-containing protein [archaeon] | diamond | 327 | 73.6 | 1 | Archaea | archaeon | ||||||||
| 27600496 | 27600496 | PRJNA849646_P_NODE_8184_length_292_cov_2.018265_g8066_i0 | PRJNA849646 | 8184 | 292 | 2.018265 | 5.8933338 | root | 1 | Root_unresolved | Root_unresolved | 57.8 | 3.37e-7 | NR | HET8689327.1 | 2213 | g8066 | i0 | 44 | 1.73630136986301 | 84 | 44 | 83.2 | 2 | 2 | 244 | 359 | 442 | HET8689327.1 hypothetical protein [Methanosarcina sp.] | diamond | 507 | 58.2 | 0.993127147766323 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 27655359 | 27655359 | PRJNA849646_P_NODE_28144_length_253_cov_1.516667_g28026_i0 | PRJNA849646 | 28144 | 253 | 1.516667 | 3.83716751 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 117 | 9.14e-29 | NR | MBT6072449.1 | 2026739 | g28026 | i0 | 66.7 | 0.960474308300395 | 81 | 27 | 96 | 0 | 4 | 246 | 334 | 414 | MBT6072449.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 243 | 117 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28191654 | 28191654 | PRJNA849646_P_NODE_2826_length_339_cov_1.624060_g2708_i0 | PRJNA849646 | 2826 | 339 | 1.62406 | 5.5055634 | Halocatena salina | 2934340 | Archaea | Archaea | 56.2 | 1.95e-6 | NR | WP_247993589.1 | 2934340 | g2708 | i0 | 60.9 | 0.814159292035398 | 46 | 18 | 40.7 | 0 | 200 | 337 | 1 | 46 | WP_247993589.1 GTPase HflX [Halocatena salina] | diamond | 276 | 56.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena salina | |
| 28665660 | 28665660 | PRJNA849646_P_NODE_9427_length_289_cov_1.425926_g9309_i0 | PRJNA849646 | 9427 | 289 | 1.425926 | 4.12092614 | Halocatena marina | 2934937 | Archaea | Archaea | 71.2 | 3.9e-12 | NR | WP_248909452.1 | 2934937 | g9309 | i0 | 56.5 | 0.716262975778547 | 69 | 29 | 71.6 | 1 | 210 | 4 | 1 | 68 | WP_248909452.1 ABC transporter permease [Halocatena marina] | diamond | 207 | 71.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena marina | |
| 28949908 | 28949908 | PRJNA849646_P_NODE_27348_length_254_cov_2.348066_g27230_i0 | PRJNA849646 | 27348 | 254 | 2.348066 | 5.96408764 | Haloglomus halophilum | 2962672 | Archaea | Archaea | 105 | 3.8200000000000005e-27 | NR | WP_254822153.1 | 2962672 | g27230 | i0 | 83.6 | 0.720472440944882 | 61 | 10 | 72 | 0 | 71 | 253 | 14 | 74 | WP_254822153.1 winged helix-turn-helix transcriptional regulator [Haloglomus halophilum] | diamond | 183 | 105 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Haloglomus | Haloglomus halophilum | |
| 29170832 | 29170832 | PRJNA849646_P_NODE_24009_length_261_cov_1.340426_g23891_i0 | PRJNA849646 | 24009 | 261 | 1.340426 | 3.49851186 | Halocatena marina | 2934937 | Archaea | Archaea | 136 | 5.709999999999998e-35 | NR | WP_264554989.1 | 2934937 | g23891 | i0 | 80.2 | 2.96551724137931 | 86 | 17 | 98.9 | 0 | 261 | 4 | 94 | 179 | WP_264554989.1 ArnT family glycosyltransferase [Halocatena marina] | diamond | 774 | 136 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena marina | |
| 29265221 | 29265221 | PRJNA849646_P_NODE_34229_length_246_cov_0.890173_g34111_i0 | PRJNA849646 | 34229 | 246 | 0.890173 | 2.18982558 | uncultured archaeon A | 115547 | Archaea | Archaea | 182 | 6.51e-57 | NR | ESS04286.1 | 1412871 | g34111 | i0 | 98.8 | 1 | 82 | 1 | 100 | 0 | 1 | 246 | 40 | 121 | ESS04286.1 MAG: thioredoxin [uncultured archaeon A07HR67] | diamond | 246 | 182 | 1 | Archaea | uncultured archaeon A07HR67 | ||||||||
| 29265222 | 29265222 | PRJNA849646_P_NODE_40769_length_232_cov_2.672956_g40651_i0 | PRJNA849646 | 40769 | 232 | 2.672956 | 6.20125792 | Halococcus | 2249 | Archaea | Archaea | 150 | 2.0299999999999994e-42 | NR | WP_005042596.1 | 2249 | g40651 | i0 | 93.5 | 0.995689655172414 | 77 | 5 | 99.6 | 0 | 2 | 232 | 226 | 302 | WP_005042596.1 MULTISPECIES: DUF2332 domain-containing protein [Halococcus] | diamond | 231 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | ||
| 29675533 | 29675533 | PRJNA849646_P_NODE_30650_length_249_cov_3.284091_g30532_i0 | PRJNA849646 | 30650 | 249 | 3.284091 | 8.17738659 | archaeon | 1906665 | Archaea | Archaea | 50.4 | 7.45e-6 | NR | NCQ51540.1 | 1906665 | g30532 | i0 | 38 | 1.93975903614458 | 71 | 43 | 85.5 | 1 | 7 | 219 | 1 | 70 | NCQ51540.1 BspA family leucine-rich repeat surface protein [archaeon] | diamond | 483 | 50.4 | 1 | Archaea | archaeon | ||||||||
| 29738759 | 29738759 | PRJNA849646_P_NODE_37250_length_242_cov_1.822485_g37132_i0 | PRJNA849646 | 37250 | 242 | 1.822485 | 4.4104137 | archaeon | 1906665 | Archaea | Archaea | 82.8 | 2.08e-16 | NR | NCQ52224.1 | 1906665 | g37132 | i0 | 52.7 | 0.91735537190082606 | 74 | 33 | 91.7 | 1 | 20 | 241 | 5 | 76 | NCQ52224.1 RNA ligase, T4 RnlA family [archaeon] | diamond | 222 | 82.8 | 1 | Archaea | archaeon | ||||||||
| 29897052 | 29897052 | PRJNA849646_P_NODE_34091_length_246_cov_0.890173_g33973_i0 | PRJNA849646 | 34091 | 246 | 0.890173 | 2.18982558 | archaeon | 1906665 | Archaea | Archaea | 61.6 | 8.24e-9 | NR | NCQ51474.1 | 1906665 | g33973 | i0 | 34.1 | 1 | 82 | 52 | 97.6 | 1 | 3 | 242 | 354 | 435 | NCQ51474.1 AAA domain-containing protein [archaeon] | diamond | 246 | 61.6 | 1 | Archaea | archaeon | ||||||||
| 30244594 | 30244594 | PRJNA849646_P_NODE_34632_length_245_cov_1.790698_g34514_i0 | PRJNA849646 | 34632 | 245 | 1.790698 | 4.3872101 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 164 | 1.68e-45 | NR | HKX81644.1 | 1971748 | g34514 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 244 | 2 | 81 | 161 | HKX81644.1 hypothetical protein [Nitrososphaera sp.] | diamond | 243 | 164 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 30623428 | 30623428 | PRJNA849646_P_NODE_13973_length_280_cov_1.487923_g13855_i0 | PRJNA849646 | 13973 | 280 | 1.487923 | 4.1661844 | Natrinema halophilum | 1699371 | Archaea | Archaea | 144 | 4.6099999999999997e-38 | NR | WP_179262033.1 | 1699371 | g13855 | i0 | 78.4 | 0.942857142857143 | 88 | 19 | 94.3 | 0 | 266 | 3 | 241 | 328 | WP_179262033.1 hypothetical protein [Natrinema halophilum] | diamond | 264 | 144 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema halophilum | |
| 30939734 | 30939734 | PRJNA849646_P_NODE_25414_length_258_cov_1.664865_g25296_i0 | PRJNA849646 | 25414 | 258 | 1.664865 | 4.2953517 | archaeon | 1906665 | Archaea | Archaea | 131 | 2.75e-34 | NR | NCQ52134.1 | 1906665 | g25296 | i0 | 72.6 | 0.976744186046512 | 84 | 23 | 97.7 | 0 | 257 | 6 | 191 | 274 | NCQ52134.1 AAA domain-containing protein [archaeon] | diamond | 252 | 131 | 1 | Archaea | archaeon | ||||||||
| 30939745 | 30939745 | PRJNA849646_P_NODE_6314_length_310_cov_2.527426_g6196_i0 | PRJNA849646 | 6314 | 310 | 2.527426 | 7.8350206 | Halomarina oriensis | 671145 | Archaea | Archaea | 67.4 | 2.75e-12 | NR | WP_158204443.1 | 671145 | g6196 | i0 | 76.9 | 0.37741935483871 | 39 | 9 | 37.7 | 0 | 194 | 310 | 1 | 39 | WP_158204443.1 helix-turn-helix domain-containing protein [Halomarina oriensis] | diamond | 117 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina oriensis | |
| 31066190 | 31066190 | PRJNA849646_P_NODE_26855_length_255_cov_2.241758_g26737_i0 | PRJNA849646 | 26855 | 255 | 2.241758 | 5.7164829 | Halobacteriales archaeon QH_6_64_2 | 1904752 | Archaea | Archaea | 50.8 | 9.45e-6 | NR | PSP44550.1 | 1919154 | g26737 | i0 | 65.7 | 0.411764705882353 | 35 | 12 | 41.2 | 0 | 105 | 1 | 3 | 37 | PSP44550.1 MAG: hypothetical protein BRC68_02340 [Halobacteriales archaeon QH_6_64_20] | diamond | 105 | 50.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon QH_6_64_20 | |||
| 31066196 | 31066196 | PRJNA849646_P_NODE_42575_length_219_cov_4.136986_g42457_i0 | PRJNA849646 | 42575 | 219 | 4.136986 | 9.05999934 | Halocatena marina | 2934937 | Archaea | Archaea | 55.8 | 3.73e-7 | NR | WP_264555414.1 | 2934937 | g42457 | i0 | 56 | 0.684931506849315 | 50 | 20 | 65.8 | 1 | 22 | 165 | 170 | 219 | WP_264555414.1 DUF7344 domain-containing protein [Halocatena marina] | diamond | 150 | 55.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena marina | |
| 31382217 | 31382217 | PRJNA849646_P_NODE_8036_length_292_cov_3.278539_g7918_i0 | PRJNA849646 | 8036 | 292 | 3.278539 | 9.57333388 | archaeon | 1906665 | Archaea | Archaea | 65.1 | 1.19e-10 | NR | NCQ51858.1 | 1906665 | g7918 | i0 | 60.4 | 0.986301369863014 | 48 | 19 | 49.3 | 0 | 3 | 146 | 5 | 52 | NCQ51858.1 BspA family leucine-rich repeat surface protein [archaeon] | diamond | 288 | 65.1 | 1 | Archaea | archaeon | ||||||||
| 31666674 | 31666674 | PRJNA849646_P_NODE_36657_length_243_cov_0.905882_g36539_i0 | PRJNA849646 | 36657 | 243 | 0.905882 | 2.20129326 | Haloarculaceae archaeon | 2497615 | Archaea | Archaea | 101 | 1.5e-23 | NR | MFB6309245.1 | 2497615 | g36539 | i0 | 65.7 | 1.72839506172839 | 70 | 24 | 86.4 | 0 | 3 | 212 | 283 | 352 | MFB6309245.1 hypothetical protein [Haloarculaceae archaeon] | diamond | 420 | 101 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarculaceae archaeon | ||
| 32363042 | 32363042 | PRJNA849646_P_NODE_33899_length_246_cov_1.427746_g33781_i0 | PRJNA849646 | 33899 | 246 | 1.427746 | 3.51225516 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 44.7 | 0.0082 | NR | WP_331001769.1 | 1971748 | g33781 | i0 | 80.8 | 0.317073170731707 | 26 | 5 | 31.7 | 0 | 169 | 246 | 1 | 26 | WP_331001769.1 ATP-binding protein [Nitrososphaera sp.] | diamond | 78 | 44.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32426138 | 32426138 | PRJNA849646_P_NODE_36619_length_243_cov_0.905882_g36501_i0 | PRJNA849646 | 36619 | 243 | 0.905882 | 2.20129326 | archaeon | 1906665 | Archaea | Archaea | 44.7 | 0.00785 | NR | NCP98117.1 | 1906665 | g36501 | i0 | 30.5 | 1.61728395061728 | 82 | 47 | 92.6 | 3 | 241 | 17 | 1097 | 1175 | NCP98117.1 DNA polymerase III subunit alpha [archaeon] | diamond | 393 | 44.7 | 1 | Archaea | 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);;