contig_metadata
25 rows where bioproject = "PRJNA781196" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2035695 | 2035695 | PRJNA781196_P_NODE_61362_length_246_cov_0.867052_g60985_i0 | PRJNA781196 | 61362 | 246 | 0.867052 | 2.13294792 | archaeon | 1906665 | Archaea | Archaea | 97.4 | 3e-24 | NR | MDP2439593.1 | 1906665 | g60985 | i0 | 70.3 | 0.902439024390244 | 74 | 22 | 90.2 | 0 | 223 | 2 | 11 | 84 | MDP2439593.1 hypothetical protein [archaeon] | diamond | 222 | 97.4 | 1 | Archaea | archaeon | ||||||||
| 9687464 | 9687464 | PRJNA781196_P_NODE_17508_length_399_cov_1.331288_g17131_i0 | PRJNA781196 | 17508 | 399 | 1.331288 | 5.31183912 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 208 | 8.79e-62 | NR | MBN2228639.1 | 2053491 | g17131 | i0 | 78.1 | 0.962406015037594 | 128 | 28 | 96.2 | 0 | 394 | 11 | 383 | 510 | MBN2228639.1 DDE-type integrase/transposase/recombinase [Candidatus Thorarchaeota archaeon] | diamond | 384 | 208 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 20337805 | 20337805 | PRJNA781196_P_NODE_6816_length_598_cov_1.714286_g6442_i0 | PRJNA781196 | 6816 | 598 | 1.714286 | 10.25143028 | archaeon | 1906665 | Archaea | Archaea | 332 | 1.2099999999999997e-110 | NR | MDP2436715.1 | 1906665 | g6442 | i0 | 82.3 | 0.993311036789298 | 198 | 34 | 99.3 | 1 | 3 | 596 | 106 | 302 | MDP2436715.1 hypothetical protein [archaeon] | diamond | 594 | 332 | 1 | Archaea | archaeon | ||||||||
| 22436630 | 22436630 | PRJNA781196_P_NODE_39558_length_284_cov_1.568720_g39181_i0 | PRJNA781196 | 39558 | 284 | 1.56872 | 4.4551648 | archaeon | 1906665 | Archaea | Archaea | 143 | 4.3499999999999997e-39 | NR | MDP2437063.1 | 1906665 | g39181 | i0 | 70.5 | 4.94366197183099 | 95 | 27 | 99.3 | 1 | 2 | 283 | 101 | 195 | MDP2437063.1 hypothetical protein [archaeon] | diamond | 1404 | 143 | 1 | Archaea | archaeon | ||||||||
| 24162842 | 24162842 | PRJNA781196_P_NODE_24619_length_347_cov_1.138686_g24242_i0 | PRJNA781196 | 24619 | 347 | 1.138686 | 3.95124042 | archaeon | 1906665 | Archaea | Archaea | 174 | 1.8e-50 | NR | MDP2436715.1 | 1906665 | g24242 | i0 | 72.2 | 0.994236311239193 | 115 | 31 | 99.4 | 1 | 3 | 347 | 178 | 291 | MDP2436715.1 hypothetical protein [archaeon] | diamond | 345 | 174 | 1 | Archaea | archaeon | ||||||||
| 27053618 | 27053618 | PRJNA781196_P_NODE_9302_length_522_cov_1.216036_g8927_i0 | PRJNA781196 | 9302 | 522 | 1.216036 | 6.34770792 | archaeon | 1906665 | Archaea | Archaea | 45.4 | 0.0183 | NR | MDP2436403.1 | 1906665 | g8927 | i0 | 40.7 | 0.339080459770115 | 59 | 32 | 33.9 | 1 | 179 | 3 | 6 | 61 | MDP2436403.1 hypothetical protein [archaeon] | diamond | 177 | 45.4 | 1 | Archaea | archaeon | ||||||||
| 27085195 | 27085195 | PRJNA781196_P_NODE_60402_length_246_cov_0.901734_g60025_i0 | PRJNA781196 | 60402 | 246 | 0.901734 | 2.21826564 | archaeon | 1906665 | Archaea | Archaea | 73.6 | 3.2e-15 | NR | RYY87459.1 | 1906665 | g60025 | i0 | 69.4 | 0.597560975609756 | 49 | 15 | 59.8 | 0 | 32 | 178 | 3 | 51 | RYY87459.1 MAG: HVA22/TB2/DP1 family protein [archaeon] | diamond | 147 | 73.6 | 1 | Archaea | archaeon | ||||||||
| 27179726 | 27179726 | PRJNA781196_P_NODE_52522_length_251_cov_2.039326_g52145_i0 | PRJNA781196 | 52522 | 251 | 2.039326 | 5.11870826 | archaeon | 1906665 | Archaea | Archaea | 132 | 9.11e-38 | NR | MDP2434118.1 | 1906665 | g52145 | i0 | 77.4 | 3 | 84 | 18 | 99.2 | 1 | 249 | 1 | 23 | 106 | MDP2434118.1 30S ribosomal protein S17 [archaeon] | diamond | 753 | 132 | 1 | Archaea | archaeon | ||||||||
| 27653938 | 27653938 | PRJNA781196_P_NODE_42804_length_274_cov_1.164179_g42427_i0 | PRJNA781196 | 42804 | 274 | 1.164179 | 3.18985046 | Halorutilus salinus | 2487751 | Archaea | Archaea | 57.4 | 3.76e-7 | NR | WP_266086963.1 | 2487751 | g42427 | i0 | 35.6 | 3.03284671532847 | 90 | 56 | 97.4 | 2 | 274 | 8 | 52 | 140 | WP_266086963.1 DUF4397 domain-containing protein [Halorutilus salinus] | diamond | 831 | 57.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halorutilales | Halorutilaceae | Halorutilus | Halorutilus salinus | |
| 27811862 | 27811862 | PRJNA781196_P_NODE_6564_length_608_cov_1.166355_g6193_i0 | PRJNA781196 | 6564 | 608 | 1.166355 | 7.0914384 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 125 | 2.5699999999999997e-30 | NR | UCF13766.1 | 2268204 | g6193 | i0 | 38.9 | 1.04111842105263 | 211 | 103 | 95.2 | 6 | 3 | 581 | 57 | 259 | UCF13766.1 MAG: serpin family protein [Thermoplasmatales archaeon] | diamond | 633 | 125 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 28421132 | 28421132 | PRJNA781196_P_NODE_44346_length_269_cov_1.193878_g43969_i0 | PRJNA781196 | 44346 | 269 | 1.193878 | 3.21153182 | Methanobacteriati | 3366610 | Archaea | Archaea | 135 | 5.7e-37 | NR | NDB64457.1 | 2026739 | g43969 | i0 | 69.7 | 6.94795539033457 | 89 | 27 | 99.3 | 0 | 267 | 1 | 89 | 177 | NDB64457.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 1869 | 135 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28443317 | 28443317 | PRJNA781196_P_NODE_53206_length_251_cov_0.876404_g52829_i0 | PRJNA781196 | 53206 | 251 | 0.876404 | 2.19977404 | archaeon | 1906665 | Archaea | Archaea | 95.9 | 8.06e-22 | NR | MDP2437799.1 | 1906665 | g52829 | i0 | 63.8 | 0.956175298804781 | 80 | 29 | 95.6 | 0 | 2 | 241 | 171 | 250 | MDP2437799.1 hypothetical protein [archaeon] | diamond | 240 | 95.9 | 1 | Archaea | archaeon | ||||||||
| 28768158 | 28768158 | PRJNA781196_P_NODE_13787_length_441_cov_2.065217_g13410_i0 | PRJNA781196 | 13787 | 441 | 2.065217 | 9.10760697 | root | 1 | Root_unresolved | Root_unresolved | 99 | 7.550000000000001e-21 | NR | MCK5217385.1 | 2250255 | g13410 | i0 | 52.8 | 1.61224489795918 | 123 | 55 | 83 | 3 | 74 | 439 | 388 | 508 | MCK5217385.1 PKD domain-containing protein [Methanosarcinales archaeon] | diamond | 711 | 99.4 | 0.995975855130785 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28980042 | 28980042 | PRJNA781196_P_NODE_16588_length_408_cov_1.164179_g16211_i0 | PRJNA781196 | 16588 | 408 | 1.164179 | 4.74985032 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 60.1 | 2.07e-7 | NR | MDG6921989.1 | 2026795 | g16211 | i0 | 31.9 | 0.830882352941177 | 113 | 64 | 75.7 | 3 | 316 | 8 | 501 | 610 | MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 339 | 60.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29011791 | 29011791 | PRJNA781196_P_NODE_43068_length_273_cov_1.215000_g42691_i0 | PRJNA781196 | 43068 | 273 | 1.215 | 3.31695 | Methanospirillum sp. | 45200 | Archaea | Archaea | 44.7 | 0.00941 | NR | HWQ67247.1 | 45200 | g42691 | i0 | 50.8 | 0.648351648351648 | 59 | 20 | 62.6 | 2 | 50 | 220 | 184 | 235 | HWQ67247.1 hypothetical protein [Methanospirillum sp.] | diamond | 177 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 29021168 | 29021168 | PRJNA781196_P_NODE_62388_length_245_cov_0.906977_g62011_i0 | PRJNA781196 | 62388 | 245 | 0.906977 | 2.22209365 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 8.28e-7 | NR | MFA5764489.1 | 1906665 | g62011 | i0 | 57.5 | 1.43265306122449 | 40 | 15 | 49 | 1 | 168 | 49 | 229 | 266 | MFA5764489.1 hypothetical protein [archaeon] | diamond | 351 | 56.2 | 0.99288256227758 | Archaea | archaeon | ||||||||
| 29115657 | 29115657 | PRJNA781196_P_NODE_59168_length_247_cov_0.896552_g58791_i0 | PRJNA781196 | 59168 | 247 | 0.896552 | 2.21448344 | root | 1 | Root_unresolved | Root_unresolved | 63.2 | 2.51e-9 | NR | RAH14746.1 | 2026739 | g58791 | i0 | 57.1 | 1.20242914979757 | 49 | 21 | 59.5 | 0 | 245 | 99 | 240 | 288 | RAH14746.1 MAG: hypothetical protein CMB56_004690 [Methanobacteriota archaeon] | diamond | 297 | 63.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29737430 | 29737430 | PRJNA781196_P_NODE_8990_length_529_cov_1.236842_g8615_i0 | PRJNA781196 | 8990 | 529 | 1.236842 | 6.54289418 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 57.4 | 6.31e-7 | NR | MBN2477751.1 | 2250274 | g8615 | i0 | 40.7 | 1.93383742911153 | 81 | 42 | 45.9 | 1 | 528 | 286 | 52 | 126 | MBN2477751.1 ankyrin repeat domain-containing protein [Candidatus Micrarchaeota archaeon] | diamond | 1023 | 57.4 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 29895673 | 29895673 | PRJNA781196_P_NODE_63371_length_244_cov_0.912281_g62994_i0 | PRJNA781196 | 63371 | 244 | 0.912281 | 2.22596564 | archaeon | 1906665 | Archaea | Archaea | 64.7 | 1.19e-11 | NR | RYG56852.1 | 1906665 | g62994 | i0 | 49.3 | 0.872950819672131 | 71 | 36 | 87.3 | 0 | 15 | 227 | 1 | 71 | RYG56852.1 MAG: hypothetical protein EON66_01850 [archaeon] | diamond | 213 | 64.7 | 1 | Archaea | archaeon | ||||||||
| 30401545 | 30401545 | PRJNA781196_P_NODE_53533_length_251_cov_0.876404_g53156_i0 | PRJNA781196 | 53533 | 251 | 0.876404 | 2.19977404 | archaeon | 1906665 | Archaea | Archaea | 101 | 1.28e-25 | NR | MDP2434962.1 | 1906665 | g53156 | i0 | 57.5 | 1.91235059760956 | 80 | 34 | 95.6 | 0 | 241 | 2 | 37 | 116 | MDP2434962.1 hypothetical protein [archaeon] | diamond | 480 | 101 | 1 | Archaea | archaeon | ||||||||
| 30811772 | 30811772 | PRJNA781196_P_NODE_57534_length_248_cov_0.891429_g57157_i0 | PRJNA781196 | 57534 | 248 | 0.891429 | 2.21074392 | archaeon | 1906665 | Archaea | Archaea | 58.9 | 7.66e-8 | NR | MDP2436570.1 | 1906665 | g57157 | i0 | 30 | 1.93548387096774 | 160 | 29 | 93.1 | 4 | 15 | 245 | 74 | 233 | MDP2436570.1 alpha/beta hydrolase [archaeon] | diamond | 480 | 58.9 | 1 | Archaea | archaeon | ||||||||
| 30938346 | 30938346 | PRJNA781196_P_NODE_45894_length_264_cov_1.633508_g45517_i0 | PRJNA781196 | 45894 | 264 | 1.633508 | 4.31246112 | archaeon | 1906665 | Archaea | Archaea | 107 | 3.81e-27 | NR | MDP2438646.1 | 1906665 | g45517 | i0 | 64.1 | 1.04545454545455 | 92 | 27 | 98.9 | 2 | 2 | 262 | 89 | 179 | MDP2438646.1 Rab family GTPase [archaeon] | diamond | 276 | 107 | 1 | Archaea | archaeon | ||||||||
| 31539032 | 31539032 | PRJNA781196_P_NODE_55376_length_250_cov_0.881356_g54999_i0 | PRJNA781196 | 55376 | 250 | 0.881356 | 2.20339 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 60.8 | 1.31e-8 | NR | RZD32614.1 | 2026795 | g54999 | i0 | 41.8 | 3.36 | 67 | 36 | 80.4 | 1 | 241 | 41 | 66 | 129 | RZD32614.1 MAG: hypothetical protein CXT79_05995 [Nitrososphaerota archaeon] | diamond | 840 | 60.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 32708717 | 32708717 | PRJNA781196_P_NODE_63760_length_244_cov_0.912281_g63383_i0 | PRJNA781196 | 63760 | 244 | 0.912281 | 2.22596564 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 93.2 | 6.71e-20 | NR | HDH27971.1 | 2026739 | g63383 | i0 | 59.2 | 1.74590163934426 | 71 | 29 | 87.3 | 0 | 240 | 28 | 428 | 498 | HDH27971.1 calcium-transporting P-type ATPase, PMR1-type [Methanobacteriota archaeon] | diamond | 426 | 93.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32803150 | 32803150 | PRJNA781196_P_NODE_40180_length_282_cov_1.866029_g39803_i0 | PRJNA781196 | 40180 | 282 | 1.866029 | 5.26220178 | Salinirussus sp. | 2036002 | Archaea | Archaea | 48.1 | 7.34e-4 | NR | MFB6297149.1 | 2036002 | g39803 | i0 | 33.3 | 0.861702127659574 | 81 | 46 | 77.7 | 1 | 46 | 264 | 150 | 230 | MFB6297149.1 diaminopimelate decarboxylase [Salinirussus sp.] | diamond | 243 | 48.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinirussus | Salinirussus sp. |
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);;