contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA356682" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1672662 | 1672662 | PRJNA356682_P_NODE_5002_length_634_cov_2.247772_g4328_i0 | PRJNA356682 | 5002 | 634 | 2.247772 | 14.25087448 | archaeon | 1906665 | Archaea | Archaea | 176 | 6.22e-53 | NR | RYH29492.1 | 1906665 | g4328 | i0 | 76.9 | 0.553627760252366 | 117 | 22 | 53 | 1 | 36 | 371 | 1 | 117 | RYH29492.1 MAG: 50S ribosomal protein L30e [archaeon] | diamond | 351 | 176 | 1 | Archaea | archaeon | ||||||||
| 2948400 | 2948400 | PRJNA356682_P_NODE_38383_length_248_cov_0.880000_g37692_i0 | PRJNA356682 | 38383 | 248 | 0.88 | 2.1824 | Halopenitus sp. | 1979403 | Archaea | Archaea | 108 | 1.67e-25 | NR | MFB6236002.1 | 1979403 | g37692 | i0 | 69.1 | 1.13709677419355 | 94 | 17 | 99.2 | 1 | 248 | 3 | 1 | 94 | MFB6236002.1 helix-turn-helix transcriptional regulator [Halopenitus sp.] | diamond | 282 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus sp. | |
| 4225006 | 4225006 | PRJNA356682_P_NODE_39004_length_247_cov_2.022989_g38313_i0 | PRJNA356682 | 39004 | 247 | 2.022989 | 4.99678283 | archaeon | 1906665 | Archaea | Archaea | 103 | 2.17e-26 | NR | RYG67591.1 | 1906665 | g38313 | i0 | 78.8 | 0.801619433198381 | 66 | 14 | 80.2 | 0 | 198 | 1 | 2 | 67 | RYG67591.1 MAG: 50S ribosomal protein L23 [archaeon] | diamond | 198 | 103 | 1 | Archaea | archaeon | ||||||||
| 18249041 | 18249041 | PRJNA356682_P_NODE_22095_length_309_cov_1.394068_g21404_i0 | PRJNA356682 | 22095 | 309 | 1.394068 | 4.30767012 | archaeon | 1906665 | Archaea | Archaea | 191 | 5.899999999999999e-58 | NR | RYH04926.1 | 1906665 | g21404 | i0 | 93.1 | 0.990291262135922 | 102 | 7 | 99 | 0 | 2 | 307 | 72 | 173 | RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon] | diamond | 306 | 191 | 1 | Archaea | archaeon | ||||||||
| 27011476 | 27011476 | PRJNA356682_P_NODE_24402_length_296_cov_1.381166_g23711_i0 | PRJNA356682 | 24402 | 296 | 1.381166 | 4.08825136 | archaeon | 1906665 | Archaea | Archaea | 47 | 0.00233 | NR | RYG67462.1 | 1906665 | g23711 | i0 | 81.5 | 0.273648648648649 | 27 | 5 | 27.4 | 0 | 82 | 2 | 1 | 27 | RYG67462.1 MAG: hypothetical protein EON64_07385, partial [archaeon] | diamond | 81 | 47 | 1 | Archaea | archaeon | ||||||||
| 27169433 | 27169433 | PRJNA356682_P_NODE_39662_length_247_cov_0.885057_g38971_i0 | PRJNA356682 | 39662 | 247 | 0.885057 | 2.18609079 | archaeon | 1906665 | Archaea | Archaea | 152 | 4.38e-41 | NR | RYG66447.1 | 1906665 | g38971 | i0 | 87.7 | 0.983805668016194 | 81 | 10 | 98.4 | 0 | 245 | 3 | 347 | 427 | RYG66447.1 MAG: hypothetical protein EON64_09740 [archaeon] | diamond | 243 | 152 | 1 | Archaea | archaeon | ||||||||
| 27296109 | 27296109 | PRJNA356682_P_NODE_47663_length_199_cov_17.000000_g46972_i0 | PRJNA356682 | 47663 | 199 | 17 | 33.83 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 108 | 3.3600000000000003e-29 | NR | MCA9460427.1 | 2026764 | g46972 | i0 | 89.2 | 0.979899497487437 | 65 | 7 | 98 | 0 | 197 | 3 | 10 | 74 | MCA9460427.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 195 | 108 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27580303 | 27580303 | PRJNA356682_P_NODE_13204_length_388_cov_0.974603_g12514_i0 | PRJNA356682 | 13204 | 388 | 0.974603 | 3.78145964 | archaeon | 1906665 | Archaea | Archaea | 167 | 1.86e-49 | NR | RYG65124.1 | 1906665 | g12514 | i0 | 87.4 | 0.734536082474227 | 95 | 12 | 73.5 | 0 | 386 | 102 | 118 | 212 | RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon] | diamond | 285 | 167 | 1 | Archaea | archaeon | ||||||||
| 27580307 | 27580307 | PRJNA356682_P_NODE_19884_length_323_cov_2.376000_g19193_i0 | PRJNA356682 | 19884 | 323 | 2.376 | 7.67448 | archaeon | 1906665 | Archaea | Archaea | 177 | 1.1599999999999999e-54 | NR | RYG68742.1 | 1906665 | g19193 | i0 | 82.2 | 1.98761609907121 | 107 | 19 | 99.4 | 0 | 321 | 1 | 33 | 139 | RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] | diamond | 642 | 177 | 1 | Archaea | archaeon | ||||||||
| 27864397 | 27864397 | PRJNA356682_P_NODE_26225_length_287_cov_1.962617_g25534_i0 | PRJNA356682 | 26225 | 287 | 1.962617 | 5.63271079 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 58.2 | 2.3e-7 | NR | MFL2966465.1 | 2670411 | g25534 | i0 | 67.5 | 0.418118466898955 | 40 | 13 | 41.8 | 0 | 121 | 2 | 1 | 40 | MFL2966465.1 HAD-IA family hydrolase [Candidatus Thalassarchaeaceae archaeon] | diamond | 120 | 58.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 29222388 | 29222388 | PRJNA356682_P_NODE_43949_length_242_cov_0.911243_g43258_i0 | PRJNA356682 | 43949 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 150 | 3.6e-40 | NR | RYH31746.1 | 1906665 | g43258 | i0 | 87.5 | 1.98347107438017 | 80 | 10 | 99.2 | 0 | 1 | 240 | 722 | 801 | RYH31746.1 MAG: phospholipid-transporting ATPase [archaeon] | diamond | 480 | 150 | 1 | Archaea | archaeon | ||||||||
| 29411563 | 29411563 | PRJNA356682_P_NODE_40149_length_246_cov_0.890173_g39458_i0 | PRJNA356682 | 40149 | 246 | 0.890173 | 2.18982558 | archaeon | 1906665 | Archaea | Archaea | 114 | 1.11e-29 | NR | RYG70158.1 | 1906665 | g39458 | i0 | 63.8 | 1.92682926829268 | 80 | 29 | 97.6 | 0 | 244 | 5 | 51 | 130 | RYG70158.1 MAG: hypothetical protein EON64_00885 [archaeon] | diamond | 474 | 114 | 1 | Archaea | archaeon | ||||||||
| 29411565 | 29411565 | PRJNA356682_P_NODE_41289_length_245_cov_0.895349_g40598_i0 | PRJNA356682 | 41289 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 58.5 | 9e-8 | NR | RYG95241.1 | 1906665 | g40598 | i0 | 48.5 | 0.808163265306122 | 66 | 32 | 80.8 | 1 | 46 | 243 | 7 | 70 | RYG95241.1 MAG: hypothetical protein EON65_56280, partial [archaeon] | diamond | 198 | 58.5 | 1 | Archaea | archaeon | ||||||||
| 29727115 | 29727115 | PRJNA356682_P_NODE_42110_length_244_cov_0.900585_g41419_i0 | PRJNA356682 | 42110 | 244 | 0.900585 | 2.1974274 | archaeon | 1906665 | Archaea | Archaea | 77.8 | 1.63e-14 | NR | RYG70205.1 | 1906665 | g41419 | i0 | 50 | 1.00819672131148 | 82 | 38 | 97.1 | 1 | 239 | 3 | 31 | 112 | RYG70205.1 MAG: nitrile hydratase subunit beta [archaeon] | diamond | 246 | 77.8 | 1 | Archaea | archaeon | ||||||||
| 29744269 | 29744269 | PRJNA356682_P_NODE_43870_length_242_cov_0.911243_g43179_i0 | PRJNA356682 | 43870 | 242 | 0.911243 | 2.20520806 | Methanobrevibacter | 2172 | Archaea | Archaea | 156 | 2.7799999999999992e-43 | NR | MEE1149620.1 | 66852 | g43179 | i0 | 97.5 | 3.96694214876033 | 80 | 2 | 99.2 | 0 | 3 | 242 | 118 | 197 | MEE1149620.1 AAA family ATPase [Methanobrevibacter sp.] | diamond | 960 | 156 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30391276 | 30391276 | PRJNA356682_P_NODE_5653_length_593_cov_2.065385_g4975_i0 | PRJNA356682 | 5653 | 593 | 2.065385 | 12.24773305 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 56.6 | 5.83e-6 | NR | TFH07295.1 | 2053491 | g4975 | i0 | 50.8 | 0.328836424957841 | 65 | 30 | 32.4 | 2 | 592 | 401 | 98 | 161 | TFH07295.1 MAG: hypothetical protein E4H14_08830 [Candidatus Thorarchaeota archaeon] | diamond | 195 | 56.6 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 30422776 | 30422776 | PRJNA356682_P_NODE_19773_length_324_cov_2.195219_g19082_i0 | PRJNA356682 | 19773 | 324 | 2.195219 | 7.11250956 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 65.1 | 1.29e-9 | NR | MCS6785098.1 | 2972665 | g19082 | i0 | 42.6 | 0.87037037037037 | 94 | 50 | 86.1 | 2 | 316 | 38 | 121 | 211 | MCS6785098.1 hypothetical protein [Candidatus Caldarchaeum sp.] | diamond | 282 | 65.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 30454240 | 30454240 | PRJNA356682_P_NODE_40253_length_246_cov_0.890173_g39562_i0 | PRJNA356682 | 40253 | 246 | 0.890173 | 2.18982558 | Methanosarcina sp. | 2213 | Archaea | Archaea | 114 | 9.979999999999999e-30 | NR | HET8688789.1 | 2213 | g39562 | i0 | 65.8 | 0.890243902439024 | 73 | 24 | 87.8 | 1 | 21 | 236 | 8 | 80 | HET8688789.1 hypothetical protein [Methanosarcina sp.] | diamond | 219 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30770065 | 30770065 | PRJNA356682_P_NODE_32654_length_261_cov_2.031915_g31963_i0 | PRJNA356682 | 32654 | 261 | 2.031915 | 5.30329815 | archaeon | 1906665 | Archaea | Archaea | 117 | 1.43e-31 | NR | RYG63904.1 | 1906665 | g31963 | i0 | 83.3 | 0.827586206896552 | 72 | 12 | 82.8 | 0 | 3 | 218 | 55 | 126 | RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] | diamond | 216 | 117 | 1 | Archaea | archaeon | ||||||||
| 30864647 | 30864647 | PRJNA356682_P_NODE_38774_length_248_cov_0.880000_g38083_i0 | PRJNA356682 | 38774 | 248 | 0.88 | 2.1824 | archaeon | 1906665 | Archaea | Archaea | 135 | 1.9399999999999997e-37 | NR | RYH15649.1 | 1906665 | g38083 | i0 | 84.1 | 0.991935483870968 | 82 | 13 | 99.2 | 0 | 1 | 246 | 96 | 177 | RYH15649.1 MAG: hypothetical protein EON65_31430 [archaeon] | diamond | 246 | 135 | 1 | Archaea | archaeon | ||||||||
| 31402253 | 31402253 | PRJNA356682_P_NODE_44996_length_241_cov_0.916667_g44305_i0 | PRJNA356682 | 44996 | 241 | 0.916667 | 2.20916747 | uncultured Nitrososphaera sp. | 759874 | Archaea | Archaea | 53.1 | 1.09e-6 | NR | WP_294807835.1 | 759874 | g44305 | i0 | 100 | 0.572614107883817 | 46 | 0 | 57.3 | 0 | 140 | 3 | 68 | 113 | WP_294807835.1 hypothetical protein [uncultured Nitrososphaera sp.] | diamond | 138 | 53.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | uncultured Nitrososphaera sp. | ||
| 31592024 | 31592024 | PRJNA356682_P_NODE_46236_length_231_cov_2.088608_g45545_i0 | PRJNA356682 | 46236 | 231 | 2.088608 | 4.82468448 | archaeon | 1906665 | Archaea | Archaea | 80.9 | 7.85e-18 | NR | RYH04918.1 | 1906665 | g45545 | i0 | 66.2 | 0.883116883116883 | 68 | 21 | 88.3 | 1 | 229 | 26 | 32 | 97 | RYH04918.1 MAG: 50S ribosomal protein L24 [archaeon] | diamond | 204 | 80.9 | 1 | Archaea | archaeon | ||||||||
| 31939665 | 31939665 | PRJNA356682_P_NODE_19017_length_330_cov_0.972763_g18326_i0 | PRJNA356682 | 19017 | 330 | 0.972763 | 3.2101179 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 44.3 | 0.0206 | NR | MCW3996493.1 | 2026714 | g18326 | i0 | 60 | 0.363636363636364 | 40 | 12 | 36.4 | 2 | 186 | 67 | 165 | 200 | MCW3996493.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 120 | 44.3 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32051849 | 32051849 | PRJNA356682_P_NODE_43738_length_242_cov_0.911243_g43047_i0 | PRJNA356682 | 43738 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 106 | 8.43e-25 | NR | MBX7076496.1 | 2099680 | g43047 | i0 | 82.3 | 1.53719008264463 | 62 | 11 | 76.9 | 0 | 1 | 186 | 452 | 513 | MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon] | diamond | 372 | 106 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 32319841 | 32319841 | PRJNA356682_P_NODE_36919_length_250_cov_0.870056_g36228_i0 | PRJNA356682 | 36919 | 250 | 0.870056 | 2.17514 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 150 | 7.429999999999998e-42 | NR | MCR5026642.1 | 66852 | g36228 | i0 | 91.6 | 0.996 | 83 | 7 | 99.6 | 0 | 249 | 1 | 44 | 126 | MCR5026642.1 MFS transporter [Methanobrevibacter sp.] | diamond | 249 | 150 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32319846 | 32319846 | PRJNA356682_P_NODE_43079_length_243_cov_0.905882_g42388_i0 | PRJNA356682 | 43079 | 243 | 0.905882 | 2.20129326 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 113 | 8.82e-30 | NR | HEX2014916.1 | 1971748 | g42388 | i0 | 64.6 | 0.975308641975309 | 79 | 28 | 97.5 | 0 | 2 | 238 | 62 | 140 | HEX2014916.1 PepSY domain-containing protein [Nitrososphaera sp.] | diamond | 237 | 113 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32382765 | 32382765 | PRJNA356682_P_NODE_32339_length_262_cov_2.370370_g31648_i0 | PRJNA356682 | 32339 | 262 | 2.37037 | 6.2103694 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 46.2 | 0.00107 | NR | MCL5681076.1 | 2806419 | g31648 | i0 | 38.9 | 0.824427480916031 | 72 | 39 | 76.7 | 2 | 240 | 40 | 46 | 117 | MCL5681076.1 OB-fold nucleic acid binding domain-containing protein [Thermoplasmatota archaeon] | diamond | 216 | 46.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota 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);;