contig_metadata
24 rows where bioproject = "PRJNA909412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7268800 | 7268800 | PRJNA909412_P_NODE_1406_length_464_cov_26.127059_g1267_i0 | PRJNA909412 | 1406 | 464 | 26.127059 | 121.22955376 | archaeon | 1906665 | Archaea | Archaea | 259 | 8.69e-86 | NR | MCQ2821492.1 | 1906665 | g1267 | i0 | 82.1 | 3.91810344827586 | 151 | 27 | 97.6 | 0 | 7 | 459 | 1 | 151 | MCQ2821492.1 50S ribosomal protein L15e [archaeon] | diamond | 1818 | 259 | 1 | Archaea | archaeon | ||||||||
| 14918617 | 14918617 | PRJNA909412_P_NODE_1392_length_467_cov_29.735981_g1253_i0 | PRJNA909412 | 1392 | 467 | 29.735981 | 138.86703127 | archaeon | 1906665 | Archaea | Archaea | 260 | 6.380000000000001e-86 | NR | MCQ2821492.1 | 1906665 | g1253 | i0 | 82.1 | 3.89935760171306 | 151 | 27 | 97 | 0 | 458 | 6 | 1 | 151 | MCQ2821492.1 50S ribosomal protein L15e [archaeon] | diamond | 1821 | 260 | 1 | Archaea | archaeon | ||||||||
| 18742211 | 18742211 | PRJNA909412_P_NODE_2215_length_358_cov_3.034483_g2075_i0 | PRJNA909412 | 2215 | 358 | 3.034483 | 10.86344914 | archaeon | 1906665 | Archaea | Archaea | 160 | 8.25e-46 | NR | MDP2439039.1 | 1906665 | g2075 | i0 | 66.7 | 2.79888268156425 | 111 | 37 | 93 | 0 | 3 | 335 | 205 | 315 | MDP2439039.1 4-hydroxyphenylpyruvate dioxygenase [archaeon] | diamond | 1002 | 160 | 1 | Archaea | archaeon | ||||||||
| 22567812 | 22567812 | PRJNA909412_P_NODE_2098_length_371_cov_2.626506_g1958_i0 | PRJNA909412 | 2098 | 371 | 2.626506 | 9.74433726 | archaeon | 1906665 | Archaea | Archaea | 114 | 8.42e-29 | NR | MCQ2818700.1 | 1906665 | g1958 | i0 | 56.1 | 0.865229110512129 | 107 | 30 | 82.5 | 3 | 370 | 65 | 134 | 228 | MCQ2818700.1 30S ribosomal protein S3 [archaeon] | diamond | 321 | 114 | 1 | Archaea | archaeon | ||||||||
| 26644352 | 26644352 | PRJNA909412_P_NODE_2861_length_312_cov_1.673993_g2721_i0 | PRJNA909412 | 2861 | 312 | 1.673993 | 5.22285816 | archaeon | 1906665 | Archaea | Archaea | 63.5 | 4.05e-9 | NR | MCQ2820996.1 | 1906665 | g2721 | i0 | 34.9 | 0.798076923076923 | 83 | 53 | 78.8 | 1 | 280 | 35 | 88 | 170 | MCQ2820996.1 SAPS family protein [archaeon] | diamond | 249 | 63.5 | 1 | Archaea | archaeon | ||||||||
| 26675927 | 26675927 | PRJNA909412_P_NODE_3681_length_274_cov_1.914894_g3540_i0 | PRJNA909412 | 3681 | 274 | 1.914894 | 5.24680956 | archaeon | 1906665 | Archaea | Archaea | 104 | 5.75e-25 | NR | RYH28348.1 | 1906665 | g3540 | i0 | 48.4 | 0.996350364963504 | 91 | 46 | 99.6 | 1 | 1 | 273 | 86 | 175 | RYH28348.1 MAG: aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [archaeon] | diamond | 273 | 104 | 1 | Archaea | archaeon | ||||||||
| 26834662 | 26834662 | PRJNA909412_P_NODE_5701_length_219_cov_1.194444_g5560_i0 | PRJNA909412 | 5701 | 219 | 1.194444 | 2.61583236 | archaeon | 1906665 | Archaea | Archaea | 63.2 | 1.94e-10 | NR | RYH29693.1 | 1906665 | g5560 | i0 | 53.7 | 5.45205479452055 | 54 | 23 | 74 | 1 | 56 | 217 | 94 | 145 | RYH29693.1 MAG: hypothetical protein EON65_07650 [archaeon] | diamond | 1194 | 63.2 | 1 | Archaea | archaeon | ||||||||
| 27087745 | 27087745 | PRJNA909412_P_NODE_17582_length_150_cov_2.603604_g17441_i0 | PRJNA909412 | 17582 | 150 | 2.603604 | 3.905406 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 65.5 | 1.04e-11 | NR | NLE05266.1 | 2056631 | g17441 | i0 | 57.4 | 3.74 | 47 | 20 | 94 | 0 | 2 | 142 | 104 | 150 | NLE05266.1 hypothetical protein [Thermoproteota archaeon] | diamond | 561 | 65.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27403846 | 27403846 | PRJNA909412_P_NODE_3723_length_272_cov_2.965665_g3582_i0 | PRJNA909412 | 3723 | 272 | 2.965665 | 8.0666088 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 44.3 | 0.00304 | NR | MCK4552789.1 | 2026773 | g3582 | i0 | 47.9 | 0.529411764705882 | 48 | 23 | 50.7 | 1 | 28 | 165 | 17 | 64 | MCK4552789.1 RNA-binding protein [Candidatus Pacearchaeota archaeon] | diamond | 144 | 44.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 27656477 | 27656477 | PRJNA909412_P_NODE_8444_length_183_cov_2.604167_g8303_i0 | PRJNA909412 | 8444 | 183 | 2.604167 | 4.76562561 | archaeon | 1906665 | Archaea | Archaea | 54.3 | 2e-7 | NR | RYG61585.1 | 1906665 | g8303 | i0 | 56 | 0.819672131147541 | 50 | 21 | 82 | 1 | 157 | 8 | 47 | 95 | RYG61585.1 MAG: hypothetical protein EON64_18460, partial [archaeon] | diamond | 150 | 54.3 | 1 | Archaea | archaeon | ||||||||
| 28319287 | 28319287 | PRJNA909412_P_NODE_16146_length_152_cov_2.283186_g16005_i0 | PRJNA909412 | 16146 | 152 | 2.283186 | 3.47044272 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 48.5 | 9.71e-5 | NR | HLC50456.1 | 2910166 | g16005 | i0 | 54.2 | 0.947368421052632 | 48 | 22 | 94.7 | 0 | 150 | 7 | 41 | 88 | HLC50456.1 NAD-dependent succinate-semialdehyde dehydrogenase [Candidatus Nanoarchaeia archaeon] | diamond | 144 | 48.5 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 28951043 | 28951043 | PRJNA909412_P_NODE_7328_length_195_cov_1.884615_g7187_i0 | PRJNA909412 | 7328 | 195 | 1.884615 | 3.67499925 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 61.6 | 4.25e-9 | NR | MBN2422940.1 | 2026803 | g7187 | i0 | 70.7 | 0.630769230769231 | 41 | 11 | 63.1 | 1 | 71 | 193 | 2 | 41 | MBN2422940.1 alanine--tRNA ligase [Candidatus Woesearchaeota archaeon] | diamond | 123 | 61.6 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 29424255 | 29424255 | PRJNA909412_P_NODE_15089_length_155_cov_1.034483_g14948_i0 | PRJNA909412 | 15089 | 155 | 1.034483 | 1.60344865 | Candidatus Mnemosynella bozhongmuii | 3072938 | Archaea | Archaea | 40 | 0.0181 | NR | MBC7115033.1 | 3072938 | g14948 | i0 | 36.6 | 0.793548387096774 | 41 | 26 | 79.4 | 0 | 150 | 28 | 28 | 68 | MBC7115033.1 tetratricopeptide repeat protein [Candidatus Mnemosynella bozhongmuii] | diamond | 123 | 40 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Candidatus Mnemosynellales | Candidatus Mnemosynellaceae | Candidatus Mnemosynella | Candidatus Mnemosynella bozhongmuii | ||
| 29898190 | 29898190 | PRJNA909412_P_NODE_1091_length_537_cov_3.146586_g959_i0 | PRJNA909412 | 1091 | 537 | 3.146586 | 16.89716682 | archaeon | 1906665 | Archaea | Archaea | 129 | 4.09e-34 | NR | RYH12636.1 | 1906665 | g959 | i0 | 52.4 | 0.82122905027933 | 147 | 56 | 79.3 | 6 | 454 | 29 | 3 | 140 | RYH12636.1 MAG: glutathione transferase GstA [archaeon] | diamond | 441 | 129 | 1 | Archaea | archaeon | ||||||||
| 29992954 | 29992954 | PRJNA909412_P_NODE_1851_length_400_cov_2.853186_g1711_i0 | PRJNA909412 | 1851 | 400 | 2.853186 | 11.412744 | archaeon | 1906665 | Archaea | Archaea | 118 | 6.09e-29 | NR | RYG68741.1 | 1906665 | g1711 | i0 | 51.5 | 1.005 | 134 | 53 | 98.3 | 5 | 1 | 393 | 165 | 289 | RYG68741.1 MAG: serine/threonine-protein kinase [archaeon] | diamond | 402 | 118 | 1 | Archaea | archaeon | ||||||||
| 30031971 | 30031971 | PRJNA909412_P_NODE_3651_length_275_cov_2.093220_g3510_i0 | PRJNA909412 | 3651 | 275 | 2.09322 | 5.756355 | Methanomicrobiales | 2191 | Archaea | Archaea | 50.1 | 1.41e-4 | NR | WP_346733691.1 | 90427 | g3510 | i0 | 37.2 | 4.45090909090909 | 86 | 31 | 90.5 | 3 | 21 | 269 | 201 | 266 | WP_346733691.1 kelch repeat-containing protein [Methanoculleus sp.] | diamond | 1224 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 30340926 | 30340926 | PRJNA909412_P_NODE_3992_length_263_cov_3.223214_g3851_i0 | PRJNA909412 | 3992 | 263 | 3.223214 | 8.47705282 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 61.6 | 5.3299999999999996e-9 | NR | MFC1697897.1 | 2026764 | g3851 | i0 | 41.1 | 0.832699619771863 | 73 | 33 | 82.1 | 2 | 229 | 14 | 121 | 184 | MFC1697897.1 Kazal-type serine protease inhibitor domain-containing protein [Nanoarchaeota archaeon] | diamond | 219 | 61.6 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30624626 | 30624626 | PRJNA909412_P_NODE_11333_length_170_cov_1.893130_g11192_i0 | PRJNA909412 | 11333 | 170 | 1.89313 | 3.218321 | archaeon | 1906665 | Archaea | Archaea | 71.6 | 7.1e-13 | NR | RYH23920.1 | 1906665 | g11192 | i0 | 56.4 | 0.970588235294118 | 55 | 24 | 97.1 | 0 | 2 | 166 | 136 | 190 | RYH23920.1 MAG: hypothetical protein EON65_17335 [archaeon] | diamond | 165 | 71.6 | 1 | Archaea | archaeon | ||||||||
| 30972421 | 30972421 | PRJNA909412_P_NODE_4334_length_252_cov_0.981221_g4193_i0 | PRJNA909412 | 4334 | 252 | 0.981221 | 2.47267692 | archaeon | 1906665 | Archaea | Archaea | 58.2 | 7.49e-8 | NR | RYG43956.1 | 1906665 | g4193 | i0 | 47.3 | 0.880952380952381 | 74 | 38 | 88.1 | 1 | 10 | 231 | 27 | 99 | RYG43956.1 MAG: hypothetical protein EON67_12300 [archaeon] | diamond | 222 | 58.2 | 1 | Archaea | archaeon | ||||||||
| 31067295 | 31067295 | PRJNA909412_P_NODE_16955_length_151_cov_1.955357_g16814_i0 | PRJNA909412 | 16955 | 151 | 1.955357 | 2.95258907 | archaeon | 1906665 | Archaea | Archaea | 89.7 | 1.15e-20 | NR | RYH10724.1 | 1906665 | g16814 | i0 | 77.6 | 0.973509933774834 | 49 | 11 | 97.4 | 0 | 3 | 149 | 106 | 154 | RYH10724.1 MAG: hypothetical protein EON65_39345 [archaeon] | diamond | 147 | 89.7 | 1 | Archaea | archaeon | ||||||||
| 31161578 | 31161578 | PRJNA909412_P_NODE_14295_length_158_cov_1.823529_g14154_i0 | PRJNA909412 | 14295 | 158 | 1.823529 | 2.88117582 | archaeon | 1906665 | Archaea | Archaea | 45.4 | 0.0013 | NR | RYG69019.1 | 1906665 | g14154 | i0 | 43.8 | 0.911392405063291 | 48 | 27 | 91.1 | 0 | 8 | 151 | 104 | 151 | RYG69019.1 MAG: AAA family ATPase [archaeon] | diamond | 144 | 45.4 | 1 | Archaea | archaeon | ||||||||
| 31478319 | 31478319 | PRJNA909412_P_NODE_10676_length_172_cov_2.759398_g10535_i0 | PRJNA909412 | 10676 | 172 | 2.759398 | 4.74616456 | archaeon | 1906665 | Archaea | Archaea | 45.4 | 6.02e-4 | NR | RYG62994.1 | 1906665 | g10535 | i0 | 42.9 | 1.09883720930233 | 63 | 28 | 95.9 | 1 | 2 | 166 | 37 | 99 | RYG62994.1 MAG: hypothetical protein EON64_16830 [archaeon] | diamond | 189 | 45.4 | 1 | Archaea | archaeon | ||||||||
| 32490689 | 32490689 | PRJNA909412_P_NODE_13019_length_161_cov_1.368852_g12878_i0 | PRJNA909412 | 13019 | 161 | 1.368852 | 2.20385172 | Thermofilum sp. | 1961369 | Archaea | Archaea | 48.1 | 1.53e-4 | NR | MCC6039536.1 | 1961369 | g12878 | i0 | 52.5 | 0.745341614906832 | 40 | 19 | 74.5 | 0 | 121 | 2 | 16 | 55 | MCC6039536.1 leucine--tRNA ligase [Thermofilum sp.] | diamond | 120 | 48.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilum | Thermofilum sp. | ||
| 32711215 | 32711215 | PRJNA909412_P_NODE_17040_length_151_cov_1.500000_g16899_i0 | PRJNA909412 | 17040 | 151 | 1.5 | 2.265 | archaeon | 1906665 | Archaea | Archaea | 73.6 | 1.38e-13 | NR | RYH31690.1 | 1906665 | g16899 | i0 | 61.2 | 0.973509933774834 | 49 | 19 | 97.4 | 0 | 3 | 149 | 6036 | 6084 | RYH31690.1 MAG: hypothetical protein EON65_02100 [archaeon] | diamond | 147 | 73.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);;