contig_metadata
15 rows where bioproject = "PRJNA1204310" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25271226 | 25271226 | PRJNA1204310_P_NODE_59320_length_245_cov_0.906977_g59023_i0 | PRJNA1204310 | 59320 | 245 | 0.906977 | 2.22209365 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 95.9 | 5.9400000000000005e-21 | NR | MEE6246135.1 | 2056631 | g59023 | i0 | 64.2 | 0.991836734693878 | 81 | 26 | 99.2 | 1 | 244 | 2 | 201 | 278 | MEE6246135.1 IMP dehydrogenase [Thermoproteota archaeon] | diamond | 243 | 95.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 26648128 | 26648128 | PRJNA1204310_P_NODE_63141_length_227_cov_2.532468_g62844_i0 | PRJNA1204310 | 63141 | 227 | 2.532468 | 5.74870236 | root | 1 | Root_unresolved | Root_unresolved | 99.8 | 1.9e-22 | NR | WP_011752483.1 | 2269 | g62844 | i0 | 62.2 | 18.5550660792952 | 74 | 28 | 97.8 | 0 | 6 | 227 | 57 | 130 | WP_011752483.1 proline--tRNA ligase [Thermofilum pendens] | diamond | 4212 | 100 | 0.998 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilum | Thermofilum pendens | ||
| 26882901 | 26882901 | PRJNA1204310_P_NODE_14341_length_468_cov_1.946835_g14044_i0 | PRJNA1204310 | 14341 | 468 | 1.946835 | 9.1111878 | Pyrobaculum calidifontis | 181486 | Archaea | Archaea | 62 | 5.35e-9 | NR | WP_011850782.1 | 181486 | g14044 | i0 | 30.7 | 1.67948717948718 | 127 | 86 | 80.8 | 2 | 62 | 439 | 3 | 128 | WP_011850782.1 universal stress protein [Pyrobaculum calidifontis] | diamond | 786 | 62 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum calidifontis | ||
| 27091510 | 27091510 | PRJNA1204310_P_NODE_26142_length_361_cov_1.083333_g25845_i0 | PRJNA1204310 | 26142 | 361 | 1.083333 | 3.91083213 | root | 1 | Root_unresolved | Root_unresolved | 202 | 1.02e-59 | NR | MEM3061973.1 | 2026795 | g25845 | i0 | 78.5 | 4.02216066481994 | 121 | 25 | 99.7 | 1 | 2 | 361 | 160 | 280 | MEM3061973.1 major capsid protein [Nitrososphaerota archaeon] | diamond | 1452 | 202 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28777798 | 28777798 | PRJNA1204310_P_NODE_40207_length_292_cov_1.369863_g39910_i0 | PRJNA1204310 | 40207 | 292 | 1.369863 | 3.99999996 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 42 | 0.0212 | NR | MDH3825587.1 | 2024843 | g39910 | i0 | 60 | 0.513698630136986 | 25 | 10 | 25.7 | 0 | 24 | 98 | 40 | 64 | MDH3825587.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 150 | 42 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28840998 | 28840998 | PRJNA1204310_P_NODE_62028_length_242_cov_1.384615_g61731_i0 | PRJNA1204310 | 62028 | 242 | 1.384615 | 3.3507683 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 103 | 1e-23 | NR | RJX16259.1 | 2026714 | g61731 | i0 | 59 | 0.966942148760331 | 78 | 32 | 96.7 | 0 | 239 | 6 | 392 | 469 | RJX16259.1 MAG: molecular chaperone DnaK [Candidatus Bathyarchaeota archaeon] | diamond | 234 | 103 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29125539 | 29125539 | PRJNA1204310_P_NODE_51569_length_252_cov_1.743017_g51272_i0 | PRJNA1204310 | 51569 | 252 | 1.743017 | 4.39240284 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 48.9 | 2.83e-4 | NR | MDG6921989.1 | 2026795 | g51272 | i0 | 36.6 | 0.976190476190476 | 82 | 48 | 96.4 | 2 | 245 | 3 | 1307 | 1385 | MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 246 | 48.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29125557 | 29125557 | PRJNA1204310_P_NODE_909_length_1454_cov_4.047791_g800_i0 | PRJNA1204310 | 909 | 1454 | 4.047791 | 58.85488114 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 50.8 | 0.00261 | NR | MCJ7699859.1 | 2026714 | g800 | i0 | 34.6 | 0.429160935350757 | 78 | 51 | 16.1 | 0 | 921 | 1154 | 81 | 158 | MCJ7699859.1 tRNA-intron lyase [Candidatus Bathyarchaeota archaeon] | diamond | 624 | 50.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29238922 | 29238922 | PRJNA1204310_P_NODE_28709_length_346_cov_1.428571_g28412_i0 | PRJNA1204310 | 28709 | 346 | 1.428571 | 4.94285566 | root | 1 | Root_unresolved | Root_unresolved | 103 | 2.3599999999999998e-23 | NR | WP_011278960.1 | 2285 | g28412 | i0 | 41.2 | 2.91329479768786 | 114 | 65 | 98.8 | 1 | 5 | 346 | 30 | 141 | WP_011278960.1 amidase [Sulfolobus acidocaldarius] | diamond | 1008 | 104 | 0.990384615384615 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobus | Sulfolobus acidocaldarius | ||
| 29377842 | 29377842 | PRJNA1204310_P_NODE_14509_length_466_cov_1.147583_g14212_i0 | PRJNA1204310 | 14509 | 466 | 1.147583 | 5.34773678 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 79 | 9.06e-15 | NR | MEM3062863.1 | 2026795 | g14212 | i0 | 45.3 | 1.7381974248927 | 86 | 36 | 54.1 | 4 | 187 | 438 | 15 | 91 | MEM3062863.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 810 | 79 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29756600 | 29756600 | PRJNA1204310_P_NODE_45651_length_273_cov_1.365000_g45354_i0 | PRJNA1204310 | 45651 | 273 | 1.365 | 3.72645 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 73.9 | 1.55e-14 | NR | MDA4120452.1 | 2026795 | g45354 | i0 | 65.6 | 1.35164835164835 | 61 | 21 | 67 | 0 | 89 | 271 | 19 | 79 | MDA4120452.1 30S ribosomal protein S12 [Nitrososphaerota archaeon] | diamond | 369 | 73.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30009584 | 30009584 | PRJNA1204310_P_NODE_3351_length_895_cov_3.785888_g3119_i0 | PRJNA1204310 | 3351 | 895 | 3.785888 | 33.8836976 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 301 | 3.7e-96 | NR | MBA3283645.1 | 2024843 | g3119 | i0 | 50.9 | 0.968715083798883 | 289 | 137 | 96.2 | 4 | 35 | 895 | 22 | 307 | MBA3283645.1 histidine--tRNA ligase [Nitrosopumilus sp.] | diamond | 867 | 301 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 30135442 | 30135442 | PRJNA1204310_P_NODE_32492_length_327_cov_1.842520_g32195_i0 | PRJNA1204310 | 32492 | 327 | 1.84252 | 6.0250404 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 63.9 | 3.69e-9 | NR | MDH5793100.1 | 2026714 | g32195 | i0 | 38 | 1.53211009174312 | 108 | 56 | 94.5 | 4 | 327 | 19 | 462 | 563 | MDH5793100.1 heavy metal translocating P-type ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 501 | 63.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31589757 | 31589757 | PRJNA1204310_P_NODE_27936_length_350_cov_1.689531_g27639_i0 | PRJNA1204310 | 27936 | 350 | 1.689531 | 5.9133585 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 106 | 3.31e-24 | NR | MBA3283645.1 | 2024843 | g27639 | i0 | 49.5 | 0.9 | 105 | 51 | 88.3 | 1 | 22 | 330 | 330 | 434 | MBA3283645.1 histidine--tRNA ligase [Nitrosopumilus sp.] | diamond | 315 | 106 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 32063990 | 32063990 | PRJNA1204310_P_NODE_10698_length_536_cov_3.097192_g10403_i0 | PRJNA1204310 | 10698 | 536 | 3.097192 | 16.60094912 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 48.1 | 0.00553 | NR | MCJ7636034.1 | 2169593 | g10403 | i0 | 33.7 | 0.498134328358209 | 89 | 56 | 48.7 | 2 | 20 | 280 | 63 | 150 | MCJ7636034.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 267 | 48.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae 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);;