contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15260887 | 15260887 | PRJNA849172_P_NODE_73892_length_265_cov_5.291667_g73532_i0 | PRJNA849172 | 73892 | 265 | 5.291667 | 14.02291755 | Candidatus Poseidonia alphae | 1915863 | Archaea | Archaea | 66.6 | 1.81e-10 | NR | MDA7463480.1 | 1915863 | g73532 | i0 | 59.3 | 1.87924528301887 | 54 | 22 | 61.1 | 0 | 3 | 164 | 264 | 317 | MDA7463480.1 AAA family ATPase [Candidatus Poseidonia alphae] | diamond | 498 | 66.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 18688431 | 18688431 | PRJNA849172_P_NODE_70955_length_268_cov_5.497436_g70595_i0 | PRJNA849172 | 70955 | 268 | 5.497436 | 14.73312848 | root | 1 | Root_unresolved | Root_unresolved | 66.2 | 2.74e-10 | NR | WP_052279112.1 | 2214 | g70595 | i0 | 47.7 | 2.95522388059702 | 88 | 44 | 98.5 | 1 | 268 | 5 | 239 | 324 | WP_052279112.1 PAS domain S-box protein [Methanosarcina acetivorans] | diamond | 792 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina acetivorans | |
| 19961813 | 19961813 | PRJNA849172_P_NODE_146076_length_201_cov_4.500000_g145716_i0 | PRJNA849172 | 146076 | 201 | 4.5 | 9.045 | Halococcus sediminicola | 1264579 | Archaea | Archaea | 115 | 5.430000000000001e-29 | NR | WP_154019981.1 | 1264579 | g145716 | i0 | 90.2 | 0.91044776119403 | 61 | 6 | 91 | 0 | 200 | 18 | 111 | 171 | WP_154019981.1 IS630 family transposase [Halococcus sediminicola] | diamond | 183 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sediminicola | |
| 22512570 | 22512570 | PRJNA849172_P_NODE_24458_length_415_cov_23.581871_g24099_i0 | PRJNA849172 | 24458 | 415 | 23.581871 | 97.86476465 | Archaea | 2157 | Archaea | Archaea | 82.4 | 3.32e-15 | NR | OGS43500.1 | 1797977 | g24099 | i0 | 39.4 | 2.66746987951807 | 127 | 69 | 86.7 | 3 | 411 | 52 | 464 | 589 | OGS43500.1 MAG: hypothetical protein A3K76_00015 [Euryarchaeota archaeon RBG_13_57_23] | diamond | 1107 | 83.2 | 0.990384615384615 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon RBG_13_57_23 | ||||||
| 26865261 | 26865261 | PRJNA849172_P_NODE_149301_length_197_cov_12.169355_g148941_i0 | PRJNA849172 | 149301 | 197 | 12.169355 | 23.97362935 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 47 | 6.59e-4 | NR | MFL2951121.1 | 2670411 | g148941 | i0 | 43.1 | 1.52284263959391 | 51 | 27 | 76.1 | 2 | 8 | 157 | 569 | 618 | MFL2951121.1 S8 family serine peptidase [Candidatus Thalassarchaeaceae archaeon] | diamond | 300 | 47 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 26896873 | 26896873 | PRJNA849172_P_NODE_87581_length_253_cov_2.216667_g87221_i0 | PRJNA849172 | 87581 | 253 | 2.216667 | 5.60816751 | Thermoplasmata archaeon M8B2D | 1933278 | Archaea | Archaea | 62.4 | 4.87e-9 | NR | PNX50664.1 | 1933278 | g87221 | i0 | 42.2 | 0.758893280632411 | 64 | 37 | 75.9 | 0 | 45 | 236 | 521 | 584 | PNX50664.1 MAG: hypothetical protein BV456_05935 [Thermoplasmata archaeon M8B2D] | diamond | 192 | 62.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon M8B2D | |||||
| 26905090 | 26905090 | PRJNA849172_P_NODE_82941_length_257_cov_2.255435_g82581_i0 | PRJNA849172 | 82941 | 257 | 2.255435 | 5.79646795 | root | 1 | Root_unresolved | Root_unresolved | 66.6 | 1.71e-10 | NR | MCX8207589.1 | 90426 | g82581 | i0 | 36.5 | 5.96498054474708 | 85 | 54 | 99.2 | 0 | 257 | 3 | 293 | 377 | MCX8207589.1 PAS domain S-box protein [Methanothrix sp.] | diamond | 1533 | 66.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 27023242 | 27023242 | PRJNA849172_P_NODE_89562_length_252_cov_1.083799_g89202_i0 | PRJNA849172 | 89562 | 252 | 1.083799 | 2.73117348 | Halococcus salifodinae | 36738 | Archaea | Archaea | 51.6 | 3.25e-5 | NR | WP_241430264.1 | 36738 | g89202 | i0 | 60 | 0.833333333333333 | 35 | 14 | 41.7 | 0 | 252 | 148 | 954 | 988 | WP_241430264.1 VWA domain-containing protein [Halococcus salifodinae] | diamond | 210 | 51.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salifodinae | |
| 27781522 | 27781522 | PRJNA849172_P_NODE_59264_length_282_cov_1.712919_g58904_i0 | PRJNA849172 | 59264 | 282 | 1.712919 | 4.83043158 | Halococcus thailandensis | 335952 | Archaea | Archaea | 161 | 5.15e-44 | NR | WP_241431201.1 | 335952 | g58904 | i0 | 86.5 | 1.8936170212766 | 89 | 12 | 94.7 | 0 | 269 | 3 | 34 | 122 | WP_241431201.1 carboxypeptidase-like regulatory domain-containing protein [Halococcus thailandensis] | diamond | 534 | 161 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus thailandensis | |
| 27947631 | 27947631 | PRJNA849172_P_NODE_114505_length_236_cov_6.453988_g114145_i0 | PRJNA849172 | 114505 | 236 | 6.453988 | 15.23141168 | Halococcus | 2249 | Archaea | Archaea | 54.7 | 6.69e-7 | NR | PSQ64376.1 | 1919209 | g114145 | i0 | 73.2 | 4.71610169491525 | 41 | 11 | 52.1 | 0 | 8 | 130 | 129 | 169 | PSQ64376.1 MAG: TspO protein [Halobacteriales archaeon SW_9_67_24] | diamond | 1113 | 55.1 | 0.992740471869329 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon SW_9_67_24 | |||
| 28547751 | 28547751 | PRJNA849172_P_NODE_69827_length_270_cov_1.467005_g69467_i0 | PRJNA849172 | 69827 | 270 | 1.467005 | 3.9609135 | Methanomada group | 2283794 | Archaea | Archaea | 52.8 | 3.63e-6 | NR | MEN6292523.1 | 2164 | g69467 | i0 | 37.1 | 1.33333333333333 | 62 | 39 | 68.9 | 0 | 83 | 268 | 1 | 62 | MEN6292523.1 hypothetical protein [Methanobacterium sp.] | diamond | 360 | 53.1 | 0.994350282485876 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29233894 | 29233894 | PRJNA849172_P_NODE_34889_length_348_cov_3.323636_g34530_i0 | PRJNA849172 | 34889 | 348 | 3.323636 | 11.56625328 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 94 | 1.3e-19 | NR | MAD73129.1 | 2026739 | g34530 | i0 | 90.4 | 0.448275862068966 | 52 | 5 | 44.8 | 0 | 158 | 3 | 396 | 447 | MAD73129.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 156 | 94 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29360103 | 29360103 | PRJNA849172_P_NODE_100049_length_246_cov_1.907514_g99689_i0 | PRJNA849172 | 100049 | 246 | 1.907514 | 4.69248444 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 47 | 0.00125 | NR | HVL86810.1 | 2806419 | g99689 | i0 | 47.4 | 1.45121951219512 | 57 | 29 | 69.5 | 1 | 16 | 186 | 374 | 429 | HVL86810.1 helix-turn-helix domain-containing protein [Thermoplasmatota archaeon] | diamond | 357 | 47 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29589093 | 29589093 | PRJNA849172_P_NODE_101370_length_245_cov_3.953488_g101010_i0 | PRJNA849172 | 101370 | 245 | 3.953488 | 9.6860456 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 5.04e-7 | NR | WP_292345499.1 | 1811680 | g101010 | i0 | 70 | 3.64897959183673 | 50 | 14 | 61.2 | 1 | 231 | 82 | 215 | 263 | WP_292345499.1 PKD domain-containing protein [Methanoregula sp. PtaB.Bin085] | diamond | 894 | 56.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. PtaB.Bin085 | |
| 30497302 | 30497302 | PRJNA849172_P_NODE_55553_length_287_cov_1.448598_g55193_i0 | PRJNA849172 | 55553 | 287 | 1.448598 | 4.15747626 | Methanosarcina sp. | 2213 | Archaea | Archaea | 141 | 1.96e-40 | NR | HET8689243.1 | 2213 | g55193 | i0 | 71.3 | 0.982578397212544 | 94 | 27 | 98.3 | 0 | 287 | 6 | 68 | 161 | HET8689243.1 hypothetical protein [Methanosarcina sp.] | diamond | 282 | 141 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30623370 | 30623370 | PRJNA849172_P_NODE_31173_length_367_cov_5.061224_g30814_i0 | PRJNA849172 | 31173 | 367 | 5.061224 | 18.57469208 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 66.6 | 1.19e-10 | NR | MCI4354872.1 | 1906666 | g30814 | i0 | 60.7 | 1.00544959128065 | 61 | 23 | 49 | 1 | 367 | 188 | 130 | 190 | MCI4354872.1 oxidoreductase [Thermoplasmata archaeon] | diamond | 369 | 66.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30663480 | 30663480 | PRJNA849172_P_NODE_93333_length_250_cov_0.875706_g92973_i0 | PRJNA849172 | 93333 | 250 | 0.875706 | 2.189265 | root | 1 | Root_unresolved | Root_unresolved | 117 | 6.28e-30 | NR | MBR3140321.1 | 66852 | g92973 | i0 | 67.5 | 15.936 | 83 | 27 | 99.6 | 0 | 2 | 250 | 155 | 237 | MBR3140321.1 glucose-1-phosphate thymidylyltransferase RfbA [Methanobrevibacter sp.] | diamond | 3984 | 118 | 0.991525423728814 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31137131 | 31137131 | PRJNA849172_P_NODE_94155_length_249_cov_2.789773_g93795_i0 | PRJNA849172 | 94155 | 249 | 2.789773 | 6.94653477 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 6.3e-6 | NR | UCF08000.1 | 1906666 | g93795 | i0 | 53.8 | 3.20481927710843 | 52 | 21 | 59 | 1 | 188 | 42 | 431 | 482 | UCF08000.1 MAG: thrombospondin type 3 repeat-containing protein, partial [Thermoplasmata archaeon] | diamond | 798 | 53.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31382145 | 31382145 | PRJNA849172_P_NODE_148716_length_198_cov_5.688000_g148356_i0 | PRJNA849172 | 148716 | 198 | 5.688 | 11.26224 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 82.8 | 1.21e-16 | NR | HUR61904.1 | 2806419 | g148356 | i0 | 80.4 | 2.09090909090909 | 46 | 9 | 69.7 | 0 | 138 | 1 | 9 | 54 | HUR61904.1 ADP-forming succinate--CoA ligase subunit beta [Thermoplasmatota archaeon] | diamond | 414 | 82.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 31517087 | 31517087 | PRJNA849172_P_NODE_82996_length_257_cov_2.108696_g82636_i0 | PRJNA849172 | 82996 | 257 | 2.108696 | 5.41934872 | Halococcus | 2249 | Archaea | Archaea | 120 | 2.78e-29 | NR | WP_256686162.1 | 224402 | g82636 | i0 | 69.4 | 1.98443579766537 | 85 | 26 | 99.2 | 0 | 256 | 2 | 653 | 737 | WP_256686162.1 ABC transporter permease [Halococcus qingdaonensis] | diamond | 510 | 120 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 32077888 | 32077888 | PRJNA849172_P_NODE_101838_length_245_cov_2.575581_g101478_i0 | PRJNA849172 | 101838 | 245 | 2.575581 | 6.31017345 | Methanosarcina sp. | 2213 | Archaea | Archaea | 73.6 | 3.28e-14 | NR | HET8688272.1 | 2213 | g101478 | i0 | 64 | 0.612244897959184 | 50 | 18 | 61.2 | 0 | 95 | 244 | 3 | 52 | HET8688272.1 protein-tyrosine phosphatase family protein [Methanosarcina sp.] | diamond | 150 | 73.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 32141314 | 32141314 | PRJNA849172_P_NODE_30098_length_374_cov_2.956811_g29739_i0 | PRJNA849172 | 30098 | 374 | 2.956811 | 11.05847314 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 125 | 1.45e-30 | NR | MAD73129.1 | 2026739 | g29739 | i0 | 79.2 | 0.770053475935829 | 96 | 15 | 77 | 3 | 374 | 87 | 448 | 538 | MAD73129.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 288 | 125 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32521195 | 32521195 | PRJNA849172_P_NODE_122099_length_230_cov_3.343949_g121739_i0 | PRJNA849172 | 122099 | 230 | 3.343949 | 7.6910827 | Thermococcus sp. LS2 | 1638260 | Archaea | Archaea | 46.6 | 3.04e-4 | NR | WP_167916020.1 | 1638260 | g121739 | i0 | 70.4 | 1.40869565217391 | 27 | 8 | 35.2 | 0 | 145 | 225 | 4 | 30 | WP_167916020.1 IS607 family transposase, partial [Thermococcus sp. LS2] | diamond | 324 | 46.6 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. LS2 | ||
| 32772977 | 32772977 | PRJNA849172_P_NODE_62540_length_278_cov_1.795122_g62180_i0 | PRJNA849172 | 62540 | 278 | 1.795122 | 4.99043916 | Halococcus sp. PRR34 | 3020830 | Archaea | Archaea | 141 | 2.17e-39 | NR | WP_273838618.1 | 3020830 | g62180 | i0 | 94.6 | 0.798561151079137 | 74 | 4 | 79.9 | 0 | 55 | 276 | 7 | 80 | WP_273838618.1 hypothetical protein [Halococcus sp. PRR34] | diamond | 222 | 141 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. PRR34 |
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);;