contig_metadata
25 rows where bioproject = "PRJNA867519" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8501025 | 8501025 | PRJNA867519_P_NODE_28067_length_248_cov_0.880000_g27913_i0 | PRJNA867519 | 28067 | 248 | 0.88 | 2.1824 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 381 | 2.519999999999999e-101 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g27913 | i0 | 94.355 | 10.6693548387097 | 248 | 14 | 100 | 0 | 1 | 248 | 2199354 | 2199107 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 2646 | 381 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 11051725 | 11051725 | PRJNA867519_P_NODE_10829_length_348_cov_0.756364_g10675_i0 | PRJNA867519 | 10829 | 348 | 0.756364 | 2.63214672 | Natrinema caseinilyticum | 2961570 | Archaea | Archaea | 54.7 | 0.009 | NTclustered | gi|2270264148|gb|CP100445.1| | 2961570 | g10675 | i0 | 88.889 | 0.129310344827586 | 45 | 3 | 13 | 1 | 279 | 323 | 1452581 | 1452539 | Natrinema caseinilyticum strain ZJ2 chromosome, complete genome | blastn | 45 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema caseinilyticum | |
| 13601861 | 13601861 | PRJNA867519_P_NODE_33691_length_241_cov_0.916667_g33537_i0 | PRJNA867519 | 33691 | 241 | 0.916667 | 2.20916747 | Halorubrum ruber | 2982524 | Archaea | Archaea | 58.4 | 4.66e-4 | NTclustered | gi|2031421124|gb|CP073695.1| | 2982524 | g33537 | i0 | 94.737 | 0.684647302904564 | 38 | 1 | 15 | 1 | 123 | 159 | 2731878 | 2731915 | Halorubrum ruber strain MBLA0099 chromosome, complete genome | blastn | 165 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum ruber | |
| 14876027 | 14876027 | PRJNA867519_P_NODE_14112_length_312_cov_1.610879_g13958_i0 | PRJNA867519 | 14112 | 312 | 1.610879 | 5.02594248 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 149 | 6.979999999999997e-42 | NR | MBH33411.1 | 2026739 | g13958 | i0 | 77.8 | 2.55769230769231 | 90 | 20 | 86.5 | 0 | 9 | 278 | 200 | 289 | MBH33411.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 798 | 149 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 26960050 | 26960050 | PRJNA867519_P_NODE_16022_length_295_cov_2.337838_g15868_i0 | PRJNA867519 | 16022 | 295 | 2.337838 | 6.8966221 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 92.4 | 2.56e-19 | NR | MBU38768.1 | 2026739 | g15868 | i0 | 50.6 | 0.905084745762712 | 89 | 44 | 90.5 | 0 | 294 | 28 | 2303 | 2391 | MBU38768.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 267 | 92.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27339762 | 27339762 | PRJNA867519_P_NODE_19823_length_276_cov_1.896552_g19669_i0 | PRJNA867519 | 19823 | 276 | 1.896552 | 5.23448352 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 84.7 | 1.01e-16 | NR | WP_292800363.1 | 66852 | g19669 | i0 | 39.6 | 1.04347826086957 | 96 | 53 | 98.9 | 2 | 276 | 4 | 906 | 1001 | WP_292800363.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 288 | 84.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27339777 | 27339777 | PRJNA867519_P_NODE_3103_length_586_cov_2.239766_g2952_i0 | PRJNA867519 | 3103 | 586 | 2.239766 | 13.12502876 | Candidatus Thalassarchaeum sp. | 3134679 | Archaea | Archaea | 80.9 | 7.1e-14 | NR | MCH2637131.1 | 3134679 | g2952 | i0 | 52.6 | 0.783276450511945 | 76 | 35 | 38.4 | 1 | 559 | 335 | 39 | 114 | MCH2637131.1 alpha-amylase family glycosyl hydrolase [Candidatus Thalassarchaeum sp.] | diamond | 459 | 80.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeum | Candidatus Thalassarchaeum sp. | ||
| 27624029 | 27624029 | PRJNA867519_P_NODE_324_length_1408_cov_2.946067_g247_i0 | PRJNA867519 | 324 | 1408 | 2.946067 | 41.48062336 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 203 | 9.84e-53 | NR | MCD4768356.1 | 2250255 | g247 | i0 | 39 | 2.26704545454545 | 362 | 199 | 75.4 | 10 | 2 | 1063 | 4 | 351 | MCD4768356.1 tandem-95 repeat protein [Methanosarcinales archaeon] | diamond | 3192 | 203 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28413242 | 28413242 | PRJNA867519_P_NODE_16506_length_292_cov_1.022831_g16352_i0 | PRJNA867519 | 16506 | 292 | 1.022831 | 2.98666652 | Archaeoglobales archaeon | 2250258 | Archaea | Archaea | 113 | 5.9000000000000005e-27 | NR | RLI79115.1 | 2250258 | g16352 | i0 | 56.7 | 8.10616438356164 | 104 | 33 | 99.7 | 2 | 292 | 2 | 156 | 254 | RLI79115.1 MAG: imidazole glycerol phosphate synthase HisHF [Archaeoglobales archaeon] | diamond | 2367 | 113 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobales archaeon | ||||
| 28791901 | 28791901 | PRJNA867519_P_NODE_8387_length_384_cov_1.745981_g8233_i0 | PRJNA867519 | 8387 | 384 | 1.745981 | 6.70456704 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 84.7 | 3.72e-16 | NR | MEW5936266.1 | 2806419 | g8233 | i0 | 50.6 | 2.0703125 | 89 | 44 | 69.5 | 0 | 2 | 268 | 605 | 693 | MEW5936266.1 putative Ig domain-containing protein [Thermoplasmatota archaeon] | diamond | 795 | 84.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28950139 | 28950139 | PRJNA867519_P_NODE_20548_length_273_cov_1.875000_g20394_i0 | PRJNA867519 | 20548 | 273 | 1.875 | 5.11875 | Salinigranum sp. | 1966351 | Archaea | Archaea | 46.6 | 8.6e-4 | NR | WP_372909564.1 | 1966351 | g20394 | i0 | 41.2 | 2.23076923076923 | 68 | 34 | 72.5 | 2 | 22 | 219 | 26 | 89 | WP_372909564.1 ester cyclase [Salinigranum sp.] | diamond | 609 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum sp. | |
| 29076406 | 29076406 | PRJNA867519_P_NODE_6768_length_421_cov_1.583333_g6614_i0 | PRJNA867519 | 6768 | 421 | 1.583333 | 6.66583193 | Methanocaldococcus indicus | 213231 | Archaea | Archaea | 45.1 | 0.032 | NR | XMY58652.1 | 213231 | g6614 | i0 | 34.5 | 0.847980997624703 | 119 | 64 | 81.9 | 6 | 57 | 401 | 172 | 280 | XMY58652.1 60S ribosomal export protein NMD3 [Methanocaldococcus indicus] | diamond | 357 | 45.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus indicus | |
| 29454751 | 29454751 | PRJNA867519_P_NODE_3310_length_571_cov_2.190763_g3159_i0 | PRJNA867519 | 3310 | 571 | 2.190763 | 12.50925673 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 91.7 | 1.95e-19 | NR | WP_297983794.1 | 253161 | g3159 | i0 | 34.6 | 0.956217162872154 | 182 | 111 | 93 | 5 | 1 | 531 | 3 | 181 | WP_297983794.1 translationally-controlled tumor protein [uncultured Methanobrevibacter sp.] | diamond | 546 | 91.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 29557785 | 29557785 | PRJNA867519_P_NODE_10550_length_351_cov_1.568345_g10396_i0 | PRJNA867519 | 10550 | 351 | 1.568345 | 5.50489095 | Methanobacteriati | 3366610 | Archaea | Archaea | 48.5 | 0.00101 | NR | MDP6626642.1 | 2599940 | g10396 | i0 | 30.5 | 3.13675213675214 | 95 | 63 | 78.6 | 2 | 32 | 307 | 206 | 300 | MDP6626642.1 mechanosensitive ion channel family protein [Methanopyri archaeon] | diamond | 1101 | 48.9 | 0.991820040899796 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanopyri | Methanopyri archaeon | ||||
| 29612641 | 29612641 | PRJNA867519_P_NODE_31050_length_244_cov_0.900585_g30896_i0 | PRJNA867519 | 31050 | 244 | 0.900585 | 2.1974274 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 53.5 | 1.34e-6 | NR | HJL96603.1 | 2666346 | g30896 | i0 | 60 | 1.94262295081967 | 40 | 16 | 49.2 | 0 | 243 | 124 | 99 | 138 | HJL96603.1 TM2 domain-containing protein [Candidatus Poseidoniaceae archaeon] | diamond | 474 | 53.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 30031746 | 30031746 | PRJNA867519_P_NODE_26211_length_250_cov_0.870056_g26057_i0 | PRJNA867519 | 26211 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0372 | NR | NYT17884.1 | 2184052 | g26057 | i0 | 41.5 | 1.476 | 53 | 31 | 63.6 | 0 | 240 | 82 | 65 | 117 | NYT17884.1 DNA double-strand break repair nuclease NurA [Methanomicrobiales archaeon] | diamond | 369 | 42.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 30221123 | 30221123 | PRJNA867519_P_NODE_22572_length_264_cov_1.581152_g22418_i0 | PRJNA867519 | 22572 | 264 | 1.581152 | 4.17424128 | Methanobacteriota | 28890 | Archaea | Archaea | 48.5 | 8.77e-5 | NR | MDG6244987.1 | 1874737 | g22418 | i0 | 45.5 | 2.78409090909091 | 44 | 24 | 50 | 0 | 209 | 78 | 1 | 44 | MDG6244987.1 DUF4870 domain-containing protein [Methanolobus sp.] | diamond | 735 | 48.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. | |
| 30528984 | 30528984 | PRJNA867519_P_NODE_16713_length_290_cov_1.419355_g16559_i0 | PRJNA867519 | 16713 | 290 | 1.419355 | 4.1161295 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 110 | 1.52e-26 | NR | RMF88911.1 | 2026739 | g16559 | i0 | 53.2 | 5.90689655172414 | 94 | 44 | 97.2 | 0 | 1 | 282 | 237 | 330 | RMF88911.1 MAG: molecular chaperone DnaJ, partial [Methanobacteriota archaeon] | diamond | 1713 | 110 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30655384 | 30655384 | PRJNA867519_P_NODE_6833_length_419_cov_2.017341_g6679_i0 | PRJNA867519 | 6833 | 419 | 2.017341 | 8.45265879 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 69.7 | 9.59e-11 | NR | HNJ81026.1 | 2485498 | g6679 | i0 | 53.3 | 0.429594272076372 | 60 | 26 | 43 | 1 | 203 | 382 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 180 | 69.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 31350793 | 31350793 | PRJNA867519_P_NODE_12656_length_327_cov_1.007874_g12502_i0 | PRJNA867519 | 12656 | 327 | 1.007874 | 3.29574798 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.9 | 0.0344 | NR | MCK5253513.1 | 1906666 | g12502 | i0 | 35.6 | 0.541284403669725 | 59 | 35 | 54.1 | 1 | 101 | 277 | 219 | 274 | MCK5253513.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 177 | 43.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31477404 | 31477404 | PRJNA867519_P_NODE_27576_length_249_cov_0.875000_g27422_i0 | PRJNA867519 | 27576 | 249 | 0.875 | 2.17875 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 50.8 | 5.57e-5 | NR | HID27252.1 | 2250255 | g27422 | i0 | 40.4 | 0.686746987951807 | 57 | 34 | 68.7 | 0 | 77 | 247 | 551 | 607 | HID27252.1 amino acid permease [Methanosarcinales archaeon] | diamond | 171 | 50.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 31951680 | 31951680 | PRJNA867519_P_NODE_9857_length_360_cov_1.212544_g9703_i0 | PRJNA867519 | 9857 | 360 | 1.212544 | 4.3651584 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 56.2 | 2.44e-6 | NR | MBT3441953.1 | 2026739 | g9703 | i0 | 49.2 | 4.29166666666667 | 61 | 30 | 50.8 | 1 | 118 | 300 | 154 | 213 | MBT3441953.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 1545 | 56.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32173422 | 32173422 | PRJNA867519_P_NODE_26318_length_250_cov_0.870056_g26164_i0 | PRJNA867519 | 26318 | 250 | 0.870056 | 2.17514 | Methanoregula sp. | 2052170 | Archaea | Archaea | 56.6 | 5.35e-7 | NR | MDD1700180.1 | 2052170 | g26164 | i0 | 40.3 | 0.924 | 77 | 46 | 92.4 | 0 | 20 | 250 | 333 | 409 | MDD1700180.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 231 | 56.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 32529587 | 32529587 | PRJNA867519_P_NODE_5199_length_473_cov_2.097500_g5045_i0 | PRJNA867519 | 5199 | 473 | 2.0975 | 9.921175 | Methanobacteriati | 3366610 | Archaea | Archaea | 67 | 1.64e-9 | NR | MAV07334.1 | 2026739 | g5045 | i0 | 56.4 | 1.3953488372093 | 55 | 23 | 34.9 | 1 | 12 | 176 | 53 | 106 | MAV07334.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 660 | 67 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32592615 | 32592615 | PRJNA867519_P_NODE_14319_length_310_cov_2.278481_g14165_i0 | PRJNA867519 | 14319 | 310 | 2.278481 | 7.0632911 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 1.39e-16 | NR | WP_232700914.1 | 2902623 | g14165 | i0 | 48.8 | 3.14516129032258 | 86 | 42 | 81.3 | 2 | 39 | 290 | 5 | 90 | WP_232700914.1 hydroxysqualene dehydroxylase [Halobacterium wangiae] | diamond | 975 | 84.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium wangiae |
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);;