contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26641421 | 26641421 | PRJNA758088_P_NODE_301441_length_249_cov_0.875000_g294470_i0 | PRJNA758088 | 301441 | 249 | 0.875 | 2.17875 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 116 | 3.63e-28 | NR | MFB5612793.1 | 2026886 | g294470 | i0 | 73.2 | 0.987951807228916 | 82 | 22 | 98.8 | 0 | 3 | 248 | 505 | 586 | MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.] | diamond | 246 | 116 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 26736070 | 26736070 | PRJNA758088_P_NODE_310661_length_248_cov_0.874286_g303690_i0 | PRJNA758088 | 310661 | 248 | 0.874286 | 2.16822928 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 87.8 | 5.47e-18 | NR | MDT8781956.1 | 2026714 | g303690 | i0 | 57.7 | 2.47983870967742 | 71 | 28 | 85.9 | 1 | 246 | 34 | 563 | 631 | MDT8781956.1 N-6 DNA methylase [Candidatus Bathyarchaeota archaeon] | diamond | 615 | 87.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 26736074 | 26736074 | PRJNA758088_P_NODE_334021_length_245_cov_0.895349_g327050_i0 | PRJNA758088 | 334021 | 245 | 0.895349 | 2.19360505 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 70.5 | 3.71e-12 | NR | MCA9485851.1 | 2026764 | g327050 | i0 | 52.5 | 2.03265306122449 | 80 | 33 | 98 | 2 | 4 | 243 | 210 | 284 | MCA9485851.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 498 | 70.5 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 26768152 | 26768152 | PRJNA758088_P_NODE_359461_length_242_cov_0.875740_g352490_i0 | PRJNA758088 | 359461 | 242 | 0.87574 | 2.1192908 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 62.4 | 4.26e-9 | NR | HET6457666.1 | 2202732 | g352490 | i0 | 58.7 | 2.24380165289256 | 46 | 19 | 57 | 0 | 219 | 82 | 366 | 411 | HET6457666.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 543 | 62.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27179205 | 27179205 | PRJNA758088_P_NODE_126962_length_373_cov_0.993333_g119991_i0 | PRJNA758088 | 126962 | 373 | 0.993333 | 3.70513209 | archaeon | 1906665 | Archaea | Archaea | 108 | 2.63e-25 | NR | MCQ2053080.1 | 1906665 | g119991 | i0 | 48.2 | 0.900804289544236 | 112 | 58 | 90.1 | 0 | 37 | 372 | 1 | 112 | MCQ2053080.1 phage DNA encapsidation protein [archaeon] | diamond | 336 | 108 | 1 | Archaea | archaeon | ||||||||
| 27274262 | 27274262 | PRJNA758088_P_NODE_149983_length_344_cov_1.136531_g143012_i0 | PRJNA758088 | 149983 | 344 | 1.136531 | 3.90966664 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 98.2 | 1.64e-24 | NR | MCY1156862.1 | 1971748 | g143012 | i0 | 96.1 | 0.444767441860465 | 51 | 2 | 44.5 | 0 | 153 | 1 | 1 | 51 | MCY1156862.1 hypothetical protein [Nitrososphaera sp.] | diamond | 153 | 98.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 27369382 | 27369382 | PRJNA758088_P_NODE_314143_length_247_cov_0.885057_g307172_i0 | PRJNA758088 | 314143 | 247 | 0.885057 | 2.18609079 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 56.6 | 4.67e-7 | NR | MAH97924.1 | 2026739 | g307172 | i0 | 33.3 | 0.874493927125506 | 72 | 48 | 87.4 | 0 | 31 | 246 | 189 | 260 | MAH97924.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 216 | 56.6 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27590266 | 27590266 | PRJNA758088_P_NODE_218824_length_288_cov_1.116279_g211853_i0 | PRJNA758088 | 218824 | 288 | 1.116279 | 3.21488352 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 99.4 | 3.0799999999999994e-24 | NR | WP_407454095.1 | 66852 | g211853 | i0 | 92.2 | 1.03125 | 51 | 4 | 53.1 | 0 | 155 | 3 | 1 | 51 | WP_407454095.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 297 | 99.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27874248 | 27874248 | PRJNA758088_P_NODE_345745_length_243_cov_0.905882_g338774_i0 | PRJNA758088 | 345745 | 243 | 0.905882 | 2.20129326 | Methanocorpusculum sp. | 2058474 | Archaea | Archaea | 155 | 1.87e-45 | NR | HJJ69380.1 | 2058474 | g338774 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 242 | 3 | 43 | 122 | HJJ69380.1 hypothetical protein [Methanocorpusculum sp.] | diamond | 240 | 155 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. | |
| 28199582 | 28199582 | PRJNA758088_P_NODE_321906_length_246_cov_0.890173_g314935_i0 | PRJNA758088 | 321906 | 246 | 0.890173 | 2.18982558 | Methanosarcina | 2207 | Archaea | Archaea | 140 | 5.8e-39 | NR | WP_229390002.1 | 2605639 | g314935 | i0 | 87.8 | 3 | 82 | 10 | 100 | 0 | 1 | 246 | 90 | 171 | WP_229390002.1 YihY/virulence factor BrkB family protein [Methanosarcina sp. DH2] | diamond | 738 | 141 | 0.99290780141844 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. DH2 | |
| 28389169 | 28389169 | PRJNA758088_P_NODE_316886_length_247_cov_0.885057_g309915_i0 | PRJNA758088 | 316886 | 247 | 0.885057 | 2.18609079 | Archaea | 2157 | Archaea | Archaea | 45.8 | 0.00265 | NR | MBI2444871.1 | 2250274 | g309915 | i0 | 36.6 | 2.46558704453441 | 71 | 37 | 86.2 | 1 | 4 | 216 | 106 | 168 | MBI2444871.1 aquaporin [Candidatus Micrarchaeota archaeon] | diamond | 609 | 45.8 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 28568831 | 28568831 | PRJNA758088_P_NODE_331947_length_245_cov_0.895349_g324976_i0 | PRJNA758088 | 331947 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 82.4 | 3.78e-16 | NR | RYG64032.1 | 1906665 | g324976 | i0 | 48.1 | 0.96734693877551 | 79 | 41 | 96.7 | 0 | 240 | 4 | 279 | 357 | RYG64032.1 MAG: hypothetical protein EON64_14800 [archaeon] | diamond | 237 | 82.4 | 1 | Archaea | archaeon | ||||||||
| 28789776 | 28789776 | PRJNA758088_P_NODE_358167_length_242_cov_0.911243_g351196_i0 | PRJNA758088 | 358167 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 69.3 | 1.65e-13 | NR | RYH13002.1 | 1906665 | g351196 | i0 | 76.3 | 0.942148760330578 | 38 | 9 | 47.1 | 0 | 240 | 127 | 27 | 64 | RYH13002.1 MAG: hypothetical protein EON65_36730 [archaeon] | diamond | 228 | 69.3 | 1 | Archaea | archaeon | ||||||||
| 28821174 | 28821174 | PRJNA758088_P_NODE_300288_length_249_cov_0.875000_g293317_i0 | PRJNA758088 | 300288 | 249 | 0.875 | 2.17875 | Candidatus Micrarchaeia archaeon | 3018267 | Archaea | Archaea | 78.2 | 1.03e-14 | NR | MFA5106219.1 | 3018267 | g293317 | i0 | 44.9 | 5.6144578313253 | 78 | 43 | 94 | 0 | 236 | 3 | 26 | 103 | MFA5106219.1 acetylornithine transaminase [Candidatus Micrarchaeia archaeon] | diamond | 1398 | 78.2 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeia archaeon | |||||
| 29895139 | 29895139 | PRJNA758088_P_NODE_252831_length_267_cov_1.190722_g245860_i0 | PRJNA758088 | 252831 | 267 | 1.190722 | 3.17922774 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.9 | 0.0118 | NR | TFG02163.1 | 2053489 | g245860 | i0 | 73.1 | 0.292134831460674 | 26 | 7 | 29.2 | 0 | 78 | 1 | 144 | 169 | TFG02163.1 MAG: GTP-binding protein, partial [Promethearchaeota archaeon] | diamond | 78 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30242678 | 30242678 | PRJNA758088_P_NODE_332952_length_245_cov_0.895349_g325981_i0 | PRJNA758088 | 332952 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 124 | 5.88e-32 | NR | RYG70026.1 | 1906665 | g325981 | i0 | 77.8 | 0.991836734693878 | 81 | 18 | 99.2 | 0 | 3 | 245 | 265 | 345 | RYG70026.1 MAG: hypothetical protein EON64_01255 [archaeon] | diamond | 243 | 124 | 1 | Archaea | archaeon | ||||||||
| 30653131 | 30653131 | PRJNA758088_P_NODE_323913_length_246_cov_0.890173_g316942_i0 | PRJNA758088 | 323913 | 246 | 0.890173 | 2.18982558 | archaeon | 1906665 | Archaea | Archaea | 98.2 | 2.83e-22 | NR | RYH28565.1 | 1906665 | g316942 | i0 | 92.2 | 0.621951219512195 | 51 | 4 | 62.2 | 0 | 154 | 2 | 214 | 264 | RYH28565.1 MAG: tetratricopeptide repeat protein [archaeon] | diamond | 153 | 98.2 | 1 | Archaea | archaeon | ||||||||
| 30684767 | 30684767 | PRJNA758088_P_NODE_316933_length_247_cov_0.885057_g309962_i0 | PRJNA758088 | 316933 | 247 | 0.885057 | 2.18609079 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 165 | 7e-47 | NR | MCJ7637739.1 | 2169593 | g309962 | i0 | 98.8 | 5.90283400809717 | 81 | 1 | 98.4 | 0 | 3 | 245 | 380 | 460 | MCJ7637739.1 VWA domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 1458 | 165 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30906258 | 30906258 | PRJNA758088_P_NODE_361834_length_241_cov_0.916667_g354863_i0 | PRJNA758088 | 361834 | 241 | 0.916667 | 2.20916747 | archaeon | 1906665 | Archaea | Archaea | 123 | 1.7999999999999998e-33 | NR | MDP2438646.1 | 1906665 | g354863 | i0 | 77.2 | 1.9792531120332 | 79 | 18 | 98.3 | 0 | 241 | 5 | 75 | 153 | MDP2438646.1 Rab family GTPase [archaeon] | diamond | 477 | 123 | 1 | Archaea | archaeon | ||||||||
| 30969404 | 30969404 | PRJNA758088_P_NODE_140554_length_355_cov_1.092199_g133583_i0 | PRJNA758088 | 140554 | 355 | 1.092199 | 3.87730645 | archaeon | 1906665 | Archaea | Archaea | 85.9 | 2.25e-17 | NR | RYH29451.1 | 1906665 | g133583 | i0 | 86.4 | 0.371830985915493 | 44 | 6 | 37.2 | 0 | 223 | 354 | 212 | 255 | RYH29451.1 MAG: solute carrier family 25 protein [archaeon] | diamond | 132 | 85.9 | 1 | Archaea | archaeon | ||||||||
| 31601775 | 31601775 | PRJNA758088_P_NODE_86156_length_455_cov_1.206806_g79187_i0 | PRJNA758088 | 86156 | 455 | 1.206806 | 5.4909673 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 47.8 | 0.005 | NR | HKO41141.1 | 2169593 | g79187 | i0 | 28.6 | 0.646153846153846 | 98 | 64 | 64.6 | 2 | 81 | 374 | 231 | 322 | HKO41141.1 M28 family metallopeptidase [Nitrososphaeraceae archaeon] | diamond | 294 | 47.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31822852 | 31822852 | PRJNA758088_P_NODE_295637_length_249_cov_1.312500_g288666_i0 | PRJNA758088 | 295637 | 249 | 1.3125 | 3.268125 | archaeon | 1906665 | Archaea | Archaea | 145 | 3.51e-42 | NR | RYG66505.1 | 1906665 | g288666 | i0 | 84.1 | 1.97590361445783 | 82 | 13 | 98.8 | 0 | 248 | 3 | 19 | 100 | RYG66505.1 MAG: acetyl-CoA C-acyltransferase, partial [archaeon] | diamond | 492 | 145 | 1 | Archaea | archaeon | ||||||||
| 31854554 | 31854554 | PRJNA758088_P_NODE_221837_length_286_cov_1.187793_g214866_i0 | PRJNA758088 | 221837 | 286 | 1.187793 | 3.39708798 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 132 | 1.7399999999999997e-35 | NR | MCY1154899.1 | 1971748 | g214866 | i0 | 97 | 1.40559440559441 | 67 | 2 | 70.3 | 0 | 86 | 286 | 1 | 67 | MCY1154899.1 nadA [Nitrososphaera sp.] | diamond | 402 | 132 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32361127 | 32361127 | PRJNA758088_P_NODE_186879_length_311_cov_0.970588_g179908_i0 | PRJNA758088 | 186879 | 311 | 0.970588 | 3.01852868 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 72.8 | 2.23e-12 | NR | MDW3615091.1 | 2169593 | g179908 | i0 | 35.6 | 3.02893890675241 | 104 | 66 | 99.4 | 1 | 3 | 311 | 284 | 387 | MDW3615091.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] | diamond | 942 | 72.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32456022 | 32456022 | PRJNA758088_P_NODE_246119_length_271_cov_1.166667_g239148_i0 | PRJNA758088 | 246119 | 271 | 1.166667 | 3.16166757 | archaeon | 1906665 | Archaea | Archaea | 143 | 5.48e-38 | NR | RYG65186.1 | 1906665 | g239148 | i0 | 81.1 | 0.996309963099631 | 90 | 16 | 99.6 | 1 | 2 | 271 | 442 | 530 | RYG65186.1 MAG: hypothetical protein EON64_12455 [archaeon] | diamond | 270 | 143 | 1 | Archaea | archaeon | ||||||||
| 32551060 | 32551060 | PRJNA758088_P_NODE_350659_length_243_cov_0.905882_g343688_i0 | PRJNA758088 | 350659 | 243 | 0.905882 | 2.20129326 | archaeon | 1906665 | Archaea | Archaea | 84.7 | 4.45e-17 | NR | MDP2438644.1 | 1906665 | g343688 | i0 | 53.8 | 0.987654320987654 | 80 | 33 | 98.8 | 1 | 3 | 242 | 263 | 338 | MDP2438644.1 hypothetical protein [archaeon] | diamond | 240 | 84.7 | 1 | Archaea | archaeon | ||||||||
| 32623427 | 32623427 | PRJNA758088_P_NODE_361520_length_241_cov_0.916667_g354549_i0 | PRJNA758088 | 361520 | 241 | 0.916667 | 2.20916747 | Thermoproteati | 1783275 | Archaea | Archaea | 121 | 3.38e-30 | NR | HJU33531.1 | 1971748 | g354549 | i0 | 86.8 | 4.23236514522822 | 68 | 9 | 84.6 | 0 | 239 | 36 | 432 | 499 | HJU33531.1 tRNA guanosine(15) transglycosylase TgtA [Nitrososphaera sp.] | diamond | 1020 | 121 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32834136 | 32834136 | PRJNA758088_P_NODE_350480_length_243_cov_0.905882_g343509_i0 | PRJNA758088 | 350480 | 243 | 0.905882 | 2.20129326 | archaeon | 1906665 | Archaea | Archaea | 71.6 | 8.46e-13 | NR | MCQ2821138.1 | 1906665 | g343509 | i0 | 57.1 | 0.691358024691358 | 56 | 24 | 69.1 | 0 | 194 | 27 | 112 | 167 | MCQ2821138.1 protein kinase [archaeon] | diamond | 168 | 71.6 | 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);;