contig_metadata
12 rows where bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370180 | 370180 | PRJNA270367_P_NODE_44861_length_164_cov_0.904348_g44656_i0 | PRJNA270367 | 44861 | 164 | 0.904348 | 1.48313072 | Thermococcus sp. 9oN-7 | 103799 | Archaea | Archaea | 298 | 1.59e-76 | NTclustered | gi|1197451|gb|U47108.1|TSU47108 | 103799 | g44656 | i0 | 99.39 | 26.6463414634146 | 164 | 1 | 100 | 0 | 1 | 164 | 1144 | 981 | Thermococcus sp. DNA polymerase A (PolA) gene, complete cds | blastn | 4370 | 298 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 9oN-7 | ||
| 7435549 | 7435549 | PRJNA270367_P_NODE_13866_length_348_cov_1.565217_g13661_i0 | PRJNA270367 | 13866 | 348 | 1.565217 | 5.44695516 | root | 1 | Root_unresolved | Root_unresolved | 139 | 1.69e-36 | NR | MBN1134025.1 | 1945595 | g13661 | i0 | 71.6 | 2.0948275862069 | 81 | 23 | 69.8 | 0 | 2 | 244 | 337 | 417 | MBN1134025.1 deoxyribodipyrimidine photo-lyase [Methanosarcinaceae archaeon] | diamond | 729 | 139 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcinaceae archaeon | ||
| 27042441 | 27042441 | PRJNA270367_P_NODE_2842_length_820_cov_5.133593_g2666_i0 | PRJNA270367 | 2842 | 820 | 5.133593 | 42.0954626 | Haloarculaceae archaeon | 2497615 | Archaea | Archaea | 87 | 7.38e-16 | NR | MFB6074683.1 | 2497615 | g2666 | i0 | 34 | 0.581707317073171 | 159 | 99 | 56.7 | 4 | 66 | 530 | 49 | 205 | MFB6074683.1 DUF4397 domain-containing protein [Haloarculaceae archaeon] | diamond | 477 | 87 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarculaceae archaeon | ||
| 27105453 | 27105453 | PRJNA270367_P_NODE_33002_length_191_cov_1.464789_g32797_i0 | PRJNA270367 | 33002 | 191 | 1.464789 | 2.79774699 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 43.5 | 0.00976 | NR | MEE3419418.1 | 2666342 | g32797 | i0 | 48.6 | 0.958115183246073 | 35 | 18 | 55 | 0 | 107 | 3 | 73 | 107 | MEE3419418.1 phospholipid scramblase-related protein [Methanosphaera sp.] | diamond | 183 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 27168658 | 27168658 | PRJNA270367_P_NODE_36442_length_179_cov_0.861538_g36237_i0 | PRJNA270367 | 36442 | 179 | 0.861538 | 1.54215302 | unclassified Halobellus | 2638438 | Archaea | Archaea | 59.7 | 1.14e-8 | NR | WP_313689274.1 | 2638438 | g36237 | i0 | 51.7 | 4.72625698324022 | 58 | 28 | 97.2 | 0 | 175 | 2 | 36 | 93 | WP_313689274.1 MULTISPECIES: DUF4397 domain-containing protein [unclassified Halobellus] | diamond | 846 | 59.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | ||
| 27453469 | 27453469 | PRJNA270367_P_NODE_38483_length_172_cov_0.861789_g38278_i0 | PRJNA270367 | 38483 | 172 | 0.861789 | 1.48227708 | Natronorubrum sediminis | 640943 | Archaea | Archaea | 48.9 | 8.52e-5 | NR | WP_090508439.1 | 640943 | g38278 | i0 | 42.4 | 2.07558139534884 | 59 | 30 | 95.9 | 1 | 8 | 172 | 82 | 140 | WP_090508439.1 SDR family NAD(P)-dependent oxidoreductase [Natronorubrum sediminis] | diamond | 357 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum sediminis | |
| 27502732 | 27502732 | PRJNA270367_P_NODE_41183_length_167_cov_1.542373_g40978_i0 | PRJNA270367 | 41183 | 167 | 1.542373 | 2.57576291 | Methanobacteriati | 3366610 | Archaea | Archaea | 64.7 | 2.37e-10 | NR | MBI20538.1 | 2026739 | g40978 | i0 | 60.4 | 1.90419161676647 | 53 | 20 | 95.2 | 1 | 167 | 9 | 438 | 489 | MBI20538.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 318 | 64.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29189984 | 29189984 | PRJNA270367_P_NODE_33309_length_190_cov_1.255319_g33104_i0 | PRJNA270367 | 33309 | 190 | 1.255319 | 2.3851061 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 67 | 2.55e-11 | NR | MED5308108.1 | 2806419 | g33104 | i0 | 55.2 | 8.24210526315789 | 58 | 26 | 91.6 | 0 | 9 | 182 | 194 | 251 | MED5308108.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 1566 | 67 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 31496344 | 31496344 | PRJNA270367_P_NODE_27876_length_214_cov_1.260606_g27671_i0 | PRJNA270367 | 27876 | 214 | 1.260606 | 2.69769684 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 53.5 | 3.87e-6 | NR | MBR68958.1 | 2026739 | g27671 | i0 | 42 | 0.967289719626168 | 69 | 39 | 96.7 | 1 | 1 | 207 | 159 | 226 | MBR68958.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 207 | 53.5 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31559624 | 31559624 | PRJNA270367_P_NODE_7396_length_497_cov_2.301339_g7198_i0 | PRJNA270367 | 7396 | 497 | 2.301339 | 11.43765483 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 64.7 | 1.07e-8 | NR | WP_231582917.1 | 1434100 | g7198 | i0 | 43.7 | 0.428571428571429 | 71 | 39 | 42.9 | 1 | 220 | 432 | 380 | 449 | WP_231582917.1 DUF4139 domain-containing protein [Methanosarcina sp. MTP4] | diamond | 213 | 64.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 32445483 | 32445483 | PRJNA270367_P_NODE_30879_length_200_cov_1.046358_g30674_i0 | PRJNA270367 | 30879 | 200 | 1.046358 | 2.092716 | Thermoplasmatales archaeon BRNA1 | 1054217 | Archaea | Archaea | 53.1 | 3.07e-6 | NR | AGI48002.1 | 1054217 | g30674 | i0 | 41.5 | 0.795 | 53 | 31 | 79.5 | 0 | 193 | 35 | 142 | 194 | AGI48002.1 Sel1 repeat protein [Thermoplasmatales archaeon BRNA1] | diamond | 159 | 53.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon BRNA1 | ||||
| 32697612 | 32697612 | PRJNA270367_P_NODE_45240_length_163_cov_0.929825_g45035_i0 | PRJNA270367 | 45240 | 163 | 0.929825 | 1.51561475 | Halosimplex carlsbadense | 171164 | Archaea | Archaea | 60.8 | 5.17e-9 | NR | WP_082223303.1 | 171164 | g45035 | i0 | 47.2 | 1.89570552147239 | 53 | 28 | 97.5 | 0 | 162 | 4 | 424 | 476 | WP_082223303.1 G8 domain-containing protein [Halosimplex carlsbadense] | diamond | 309 | 60.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex carlsbadense |
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);;