contig_metadata
17 rows where bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9435643 | 9435643 | PRJNA533623_P_NODE_79748_length_188_cov_9.102362_g77967_i0 | PRJNA533623 | 79748 | 188 | 9.102362 | 17.11244056 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 307 | 3.1100000000000005e-79 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g77967 | i0 | 100 | 0.882978723404255 | 166 | 0 | 88 | 0 | 1 | 166 | 1134550 | 1134385 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 166 | 307 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 14534712 | 14534712 | PRJNA533623_P_NODE_15272_length_603_cov_9.924354_g13567_i0 | PRJNA533623 | 15272 | 603 | 9.924354 | 59.84385462 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 994 | 0 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g13567 | i0 | 97.284 | 0.976782752902156 | 589 | 11 | 97 | 3 | 20 | 603 | 172624 | 172036 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 589 | 994 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 14535898 | 14535898 | PRJNA533623_P_NODE_65952_length_233_cov_2.261628_g64171_i0 | PRJNA533623 | 65952 | 233 | 2.261628 | 5.26959324 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 322 | 1.44e-83 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g64171 | i0 | 96.41 | 0.836909871244635 | 195 | 7 | 84 | 0 | 22 | 216 | 230470 | 230664 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 195 | 322 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 26888147 | 26888147 | PRJNA533623_P_NODE_42341_length_331_cov_18.240741_g40567_i0 | PRJNA533623 | 42341 | 331 | 18.240741 | 60.37685271 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 198 | 2.35e-61 | NR | MDP9305909.1 | 2056631 | g40567 | i0 | 92.9 | 0.88821752265861 | 98 | 7 | 88.8 | 0 | 22 | 315 | 29 | 126 | MDP9305909.1 AmmeMemoRadiSam system protein B [Thermoproteota archaeon] | diamond | 294 | 198 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27187366 | 27187366 | PRJNA533623_P_NODE_11462_length_695_cov_8.572555_g9849_i0 | PRJNA533623 | 11462 | 695 | 8.572555 | 59.57925725 | root | 1 | Root_unresolved | Root_unresolved | 191 | 1.26e-56 | NR | MDW7641098.1 | 2026886 | g9849 | i0 | 68.5 | 1.10503597122302 | 127 | 40 | 54.8 | 0 | 481 | 101 | 1 | 127 | MDW7641098.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 768 | 192 | 0.994791666666667 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 27503727 | 27503727 | PRJNA533623_P_NODE_39883_length_345_cov_6.387324_g38109_i0 | PRJNA533623 | 39883 | 345 | 6.387324 | 22.0362678 | Candidatus Nitrosotenuis | 1825023 | Archaea | Archaea | 160 | 1.51e-44 | NR | WP_048195502.1 | 1407055 | g38109 | i0 | 98.6 | 3.04347826086957 | 70 | 1 | 60.9 | 0 | 322 | 113 | 214 | 283 | WP_048195502.1 threonine synthase [Candidatus Nitrosotenuis uzonensis] | diamond | 1050 | 160 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis uzonensis | |||||
| 27615006 | 27615006 | PRJNA533623_P_NODE_33944_length_383_cov_1.937888_g32173_i0 | PRJNA533623 | 33944 | 383 | 1.937888 | 7.42211104 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 162 | 1.0800000000000001e-44 | NR | MBN1682629.1 | 2026714 | g32173 | i0 | 59.5 | 0.986945169712794 | 126 | 49 | 98.7 | 1 | 381 | 4 | 412 | 535 | MBN1682629.1 gamma-glutamyltransferase [Candidatus Bathyarchaeota archaeon] | diamond | 378 | 162 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27646651 | 27646651 | PRJNA533623_P_NODE_78104_length_198_cov_2.846715_g76323_i0 | PRJNA533623 | 78104 | 198 | 2.846715 | 5.6364957 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 45.4 | 0.00222 | NR | HYP43473.1 | 2109671 | g76323 | i0 | 38.7 | 0.939393939393939 | 62 | 36 | 90.9 | 1 | 182 | 3 | 224 | 285 | HYP43473.1 PD-(D/E)XK nuclease family protein [Candidatus Nitrosocosmicus sp.] | diamond | 186 | 45.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 28025387 | 28025387 | PRJNA533623_P_NODE_56465_length_267_cov_4.762136_g54685_i0 | PRJNA533623 | 56465 | 267 | 4.762136 | 12.71490312 | Thermofilaceae archaeon | 2268203 | Archaea | Archaea | 87 | 2.8e-19 | NR | MEM2592530.1 | 2268203 | g54685 | i0 | 100 | 0.471910112359551 | 42 | 0 | 47.2 | 0 | 21 | 146 | 125 | 166 | MEM2592530.1 DUF2750 domain-containing protein [Thermofilaceae archaeon] | diamond | 126 | 87 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilaceae archaeon | |||
| 28814387 | 28814387 | PRJNA533623_P_NODE_43368_length_326_cov_5.154717_g41594_i0 | PRJNA533623 | 43368 | 326 | 5.154717 | 16.80437742 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 81.6 | 2.17e-15 | NR | HEX7257689.1 | 2169593 | g41594 | i0 | 43.8 | 0.883435582822086 | 96 | 48 | 86.5 | 4 | 23 | 304 | 300 | 391 | HEX7257689.1 DUF4185 domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 288 | 81.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29004563 | 29004563 | PRJNA533623_P_NODE_38088_length_356_cov_13.484746_g36316_i0 | PRJNA533623 | 38088 | 356 | 13.484746 | 48.00569576 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 105 | 1.0099999999999999e-23 | NR | MEM3365499.1 | 2282146 | g36316 | i0 | 77.9 | 0.573033707865168 | 68 | 15 | 57.3 | 0 | 233 | 30 | 203 | 270 | MEM3365499.1 hypothetical protein [Candidatus Methanomethyliaceae archaeon] | diamond | 204 | 105 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 30520083 | 30520083 | PRJNA533623_P_NODE_3113_length_1228_cov_11.529563_g2173_i0 | PRJNA533623 | 3113 | 1228 | 11.529563 | 141.58303364 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 67 | 5.16e-8 | NR | MEM3833456.1 | 2250277 | g2173 | i0 | 22.2 | 0.759771986970684 | 311 | 210 | 72.1 | 7 | 1203 | 319 | 34 | 328 | MEM3833456.1 amino acid ABC transporter substrate-binding protein [Thermoprotei archaeon] | diamond | 933 | 67 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 30614800 | 30614800 | PRJNA533623_P_NODE_62173_length_246_cov_2.513514_g60393_i0 | PRJNA533623 | 62173 | 246 | 2.513514 | 6.18324444 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 165 | 2.4899999999999996e-47 | NR | MEM1953507.1 | 2972665 | g60393 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 2 | 244 | 171 | 251 | MEM1953507.1 flippase [Candidatus Caldarchaeum sp.] | diamond | 243 | 165 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 30787846 | 30787846 | PRJNA533623_P_NODE_4314_length_1080_cov_5.240432_g3197_i0 | PRJNA533623 | 4314 | 1080 | 5.240432 | 56.5966656 | Candidatus Nitrosocaldaceae | 1968910 | Archaea | Archaea | 347 | 7.019999999999998e-116 | NR | MEM3101651.1 | 2507556 | g3197 | i0 | 68.1 | 2.81944444444444 | 254 | 81 | 70.6 | 0 | 21 | 782 | 3 | 256 | MEM3101651.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Nitrosotenuis sp.] | diamond | 3045 | 347 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 31373520 | 31373520 | PRJNA533623_P_NODE_70456_length_218_cov_10.700637_g68675_i0 | PRJNA533623 | 70456 | 218 | 10.700637 | 23.32738866 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 128 | 8.679999999999998e-35 | NR | MDW0315201.1 | 2169593 | g68675 | i0 | 94.1 | 1.85779816513761 | 68 | 4 | 93.6 | 0 | 215 | 12 | 147 | 214 | MDW0315201.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 405 | 128 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31847706 | 31847706 | PRJNA533623_P_NODE_14877_length_611_cov_16.369091_g13179_i0 | PRJNA533623 | 14877 | 611 | 16.369091 | 100.01514601 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 59.3 | 2.15e-6 | NR | MCE9653374.1 | 2026886 | g13179 | i0 | 32 | 0.736497545008183 | 150 | 80 | 67.8 | 5 | 543 | 130 | 494 | 633 | MCE9653374.1 polysaccharide deacetylase family protein [Nitrosarchaeum sp.] | diamond | 450 | 59.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 32575706 | 32575706 | PRJNA533623_P_NODE_19699_length_527_cov_6.946352_g17956_i0 | PRJNA533623 | 19699 | 527 | 6.946352 | 36.60727504 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 254 | 2.08e-80 | NR | MEM4204517.1 | 3058293 | g17956 | i0 | 82.1 | 0.79696394686907 | 140 | 25 | 79.7 | 0 | 525 | 106 | 275 | 414 | MEM4204517.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 420 | 254 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae 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);;