contig_metadata
26 rows where bioproject = "PRJNA498309", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8135068 | 8135068 | PRJNA498309_S_NODE_20287_length_451_cov_11.425481_g18178_i0 | PRJNA498309 | 20287 | 451 | 11.425481 | 51.52891931 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 750 | 0 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g18178 | i0 | 100 | 0.900221729490022 | 406 | 0 | 90 | 0 | 24 | 429 | 1078415 | 1078820 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 406 | 750 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 10037887 | 10037887 | PRJNA498309_S_NODE_13648_length_632_cov_137.234506_g11727_i0 | PRJNA498309 | 13648 | 632 | 137.234506 | 867.32207792 | Thermoproteati | 1783275 | Archaea | Archaea | 787 | 0 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g11727 | i0 | 90.099 | 41.8860759493671 | 606 | 60 | 96 | 0 | 1 | 606 | 40831 | 41436 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 26472 | 791 | 0.994943109987358 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 14509187 | 14509187 | PRJNA498309_P_NODE_22912_length_604_cov_11.608466_g21024_i0 | PRJNA498309 | 22912 | 604 | 11.608466 | 70.11513464 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 267 | 5.41e-84 | NR | MEM3368575.1 | 2056631 | g21024 | i0 | 92.1 | 0.695364238410596 | 140 | 10 | 69 | 1 | 598 | 182 | 356 | 495 | MEM3368575.1 hypothetical protein [Thermoproteota archaeon] | diamond | 420 | 267 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 15782696 | 15782696 | PRJNA498309_P_NODE_10873_length_913_cov_3.133562_g9414_i0 | PRJNA498309 | 10873 | 913 | 3.133562 | 28.60942106 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 307 | 1.82e-102 | NR | MEM3369232.1 | 2056631 | g9414 | i0 | 99.4 | 0.522453450164294 | 159 | 1 | 52.2 | 0 | 417 | 893 | 19 | 177 | MEM3369232.1 hypothetical protein [Thermoproteota archaeon] | diamond | 477 | 307 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 16412245 | 16412245 | PRJNA498309_S_NODE_31013_length_289_cov_4.149606_g28845_i0 | PRJNA498309 | 31013 | 289 | 4.149606 | 11.99236134 | Thermoproteati | 1783275 | Archaea | Archaea | 267 | 8.77e-67 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g28845 | i0 | 83.448 | 62.6712802768166 | 290 | 44 | 100 | 4 | 1 | 289 | 40553 | 40839 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 18112 | 267 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 18332421 | 18332421 | PRJNA498309_P_NODE_42635_length_420_cov_1.610966_g40518_i0 | PRJNA498309 | 42635 | 420 | 1.610966 | 6.7660572 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 737 | 0 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g40518 | i0 | 100 | 0.95 | 399 | 0 | 95 | 0 | 1 | 399 | 1078813 | 1078415 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 399 | 737 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 23433537 | 23433537 | PRJNA498309_P_NODE_61619_length_320_cov_6.512367_g59471_i0 | PRJNA498309 | 61619 | 320 | 6.512367 | 20.8395744 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 191 | 1.81e-57 | NR | MEM3368576.1 | 2056631 | g59471 | i0 | 96 | 0.928125 | 99 | 4 | 92.8 | 0 | 315 | 19 | 1 | 99 | MEM3368576.1 hypothetical protein [Thermoproteota archaeon] | diamond | 297 | 191 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 26665283 | 26665283 | PRJNA498309_P_NODE_52261_length_364_cov_11.951070_g50113_i0 | PRJNA498309 | 52261 | 364 | 11.95107 | 43.5018948 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 134 | 3.22e-37 | NR | MEM3368590.1 | 2056631 | g50113 | i0 | 88 | 0.618131868131868 | 75 | 9 | 61.8 | 0 | 1 | 225 | 53 | 127 | MEM3368590.1 N-acetylmuramoyl-L-alanine amidase [Thermoproteota archaeon] | diamond | 225 | 134 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 26760437 | 26760437 | PRJNA498309_P_NODE_86441_length_230_cov_2.984456_g84292_i0 | PRJNA498309 | 86441 | 230 | 2.984456 | 6.8642488 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 85.1 | 3.75e-17 | NR | MEM3368511.1 | 2056631 | g84292 | i0 | 90.7 | 0.560869565217391 | 43 | 4 | 56.1 | 0 | 62 | 190 | 469 | 511 | MEM3368511.1 hypothetical protein [Thermoproteota archaeon] | diamond | 129 | 85.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 26887415 | 26887415 | PRJNA498309_P_NODE_69901_length_286_cov_2.457831_g67752_i0 | PRJNA498309 | 69901 | 286 | 2.457831 | 7.02939666 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 127 | 1.99e-33 | NR | MEM3368607.1 | 2056631 | g67752 | i0 | 71.4 | 0.954545454545455 | 91 | 26 | 95.5 | 0 | 3 | 275 | 209 | 299 | MEM3368607.1 hypothetical protein [Thermoproteota archaeon] | diamond | 273 | 127 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27013673 | 27013673 | PRJNA498309_P_NODE_120462_length_154_cov_2.000000_g118313_i0 | PRJNA498309 | 120462 | 154 | 2 | 3.08 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 87.8 | 9.71e-20 | NR | MEM3368515.1 | 2056631 | g118313 | i0 | 91.3 | 0.896103896103896 | 46 | 4 | 89.6 | 0 | 140 | 3 | 89 | 134 | MEM3368515.1 hypothetical protein [Thermoproteota archaeon] | diamond | 138 | 87.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27298327 | 27298327 | PRJNA498309_P_NODE_41403_length_427_cov_12.566667_g39290_i0 | PRJNA498309 | 41403 | 427 | 12.566667 | 53.65966809 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 129 | 9.349999999999999e-35 | NR | MEM3368590.1 | 2056631 | g39290 | i0 | 89.9 | 0.484777517564403 | 69 | 7 | 48.5 | 0 | 82 | 288 | 59 | 127 | MEM3368590.1 N-acetylmuramoyl-L-alanine amidase [Thermoproteota archaeon] | diamond | 207 | 129 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27866595 | 27866595 | PRJNA498309_P_NODE_79345_length_252_cov_7.795349_g77196_i0 | PRJNA498309 | 79345 | 252 | 7.795349 | 19.64427948 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 95.1 | 1.56e-20 | NR | MEM3368556.1 | 2056631 | g77196 | i0 | 83.6 | 0.654761904761905 | 55 | 9 | 65.5 | 0 | 5 | 169 | 1410 | 1464 | MEM3368556.1 hypothetical protein [Thermoproteota archaeon] | diamond | 165 | 95.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27961454 | 27961454 | PRJNA498309_P_NODE_99405_length_195_cov_2.962025_g97256_i0 | PRJNA498309 | 99405 | 195 | 2.962025 | 5.77594875 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 88.2 | 1.85e-18 | NR | MEM3368555.1 | 2056631 | g97256 | i0 | 82.5 | 0.876923076923077 | 57 | 10 | 87.7 | 0 | 171 | 1 | 38 | 94 | MEM3368555.1 hypothetical protein [Thermoproteota archaeon] | diamond | 171 | 88.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28213794 | 28213794 | PRJNA498309_P_NODE_97886_length_199_cov_2.253086_g95737_i0 | PRJNA498309 | 97886 | 199 | 2.253086 | 4.48364114 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 42 | 0.0402 | NR | MEM3368524.1 | 2056631 | g95737 | i0 | 76.9 | 0.391959798994975 | 26 | 6 | 39.2 | 0 | 61 | 138 | 1 | 26 | MEM3368524.1 hypothetical protein [Thermoproteota archaeon] | diamond | 78 | 42 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29145495 | 29145495 | PRJNA498309_P_NODE_68009_length_293_cov_5.250000_g65860_i0 | PRJNA498309 | 68009 | 293 | 5.25 | 15.3825 | root | 1 | Root_unresolved | Root_unresolved | 102 | 1.86e-23 | NR | WP_345803936.1 | 121277 | g65860 | i0 | 80.9 | 1.60750853242321 | 68 | 13 | 69.6 | 0 | 289 | 86 | 167 | 234 | WP_345803936.1 complex I subunit 5 family protein [Pyrobaculum arsenaticum] | diamond | 471 | 103 | 0.990291262135922 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum | ||
| 29476670 | 29476670 | PRJNA498309_P_NODE_77710_length_258_cov_2.113122_g75561_i0 | PRJNA498309 | 77710 | 258 | 2.113122 | 5.45185476 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 153 | 6.889999999999998e-41 | NR | MEM3368643.1 | 2056631 | g75561 | i0 | 91.7 | 0.976744186046512 | 84 | 7 | 97.7 | 0 | 6 | 257 | 324 | 407 | MEM3368643.1 hypothetical protein [Thermoproteota archaeon] | diamond | 252 | 153 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29919210 | 29919210 | PRJNA498309_P_NODE_47171_length_392_cov_2.501408_g45035_i0 | PRJNA498309 | 47171 | 392 | 2.501408 | 9.80551936 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 194 | 1.37e-54 | NR | MEM3368643.1 | 2056631 | g45035 | i0 | 96 | 0.772959183673469 | 101 | 4 | 77.3 | 0 | 88 | 390 | 699 | 799 | MEM3368643.1 hypothetical protein [Thermoproteota archaeon] | diamond | 303 | 194 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30835306 | 30835306 | PRJNA498309_P_NODE_90354_length_219_cov_1.252747_g88205_i0 | PRJNA498309 | 90354 | 219 | 1.252747 | 2.74351593 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 100 | 3.61e-23 | NR | NLE04249.1 | 2056631 | g88205 | i0 | 74.2 | 1.80821917808219 | 66 | 17 | 90.4 | 0 | 219 | 22 | 154 | 219 | NLE04249.1 Fe-S-oxidoreductase [Thermoproteota archaeon] | diamond | 396 | 100 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30866864 | 30866864 | PRJNA498309_P_NODE_86134_length_231_cov_2.644330_g83985_i0 | PRJNA498309 | 86134 | 231 | 2.64433 | 6.1084023 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 115 | 3.57e-30 | NR | MEM3368514.1 | 2056631 | g83985 | i0 | 82.9 | 0.909090909090909 | 70 | 12 | 90.9 | 0 | 210 | 1 | 140 | 209 | MEM3368514.1 hypothetical protein [Thermoproteota archaeon] | diamond | 210 | 115 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31056792 | 31056792 | PRJNA498309_P_NODE_100055_length_194_cov_1.484076_g97906_i0 | PRJNA498309 | 100055 | 194 | 1.484076 | 2.87910744 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 125 | 4.7299999999999997e-32 | NR | MEM3368575.1 | 2056631 | g97906 | i0 | 93.8 | 0.989690721649485 | 64 | 4 | 99 | 0 | 3 | 194 | 49 | 112 | MEM3368575.1 hypothetical protein [Thermoproteota archaeon] | diamond | 192 | 125 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31056800 | 31056800 | PRJNA498309_P_NODE_15475_length_749_cov_4.669944_g13820_i0 | PRJNA498309 | 15475 | 749 | 4.669944 | 34.97788056 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 356 | 2.21e-112 | NR | MEM3368643.1 | 2056631 | g13820 | i0 | 92.6 | 0.865153538050734 | 216 | 16 | 86.5 | 0 | 648 | 1 | 441 | 656 | MEM3368643.1 hypothetical protein [Thermoproteota archaeon] | diamond | 648 | 356 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31119405 | 31119405 | PRJNA498309_P_NODE_74195_length_270_cov_4.643777_g72046_i0 | PRJNA498309 | 74195 | 270 | 4.643777 | 12.5381979 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 156 | 7.05e-47 | NR | MEM3368608.1 | 2056631 | g72046 | i0 | 92.8 | 0.922222222222222 | 83 | 6 | 92.2 | 0 | 22 | 270 | 29 | 111 | MEM3368608.1 hypothetical protein [Thermoproteota archaeon] | diamond | 249 | 156 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31404404 | 31404404 | PRJNA498309_P_NODE_96176_length_203_cov_3.728916_g94027_i0 | PRJNA498309 | 96176 | 203 | 3.728916 | 7.56969948 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 71.6 | 1.45e-12 | NR | MEM3368556.1 | 2056631 | g94027 | i0 | 94.4 | 0.532019704433498 | 36 | 2 | 53.2 | 0 | 180 | 73 | 1288 | 1323 | MEM3368556.1 hypothetical protein [Thermoproteota archaeon] | diamond | 108 | 71.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32416731 | 32416731 | PRJNA498309_P_NODE_85799_length_232_cov_2.466667_g83650_i0 | PRJNA498309 | 85799 | 232 | 2.466667 | 5.72266744 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 126 | 5.68e-33 | NR | MEM3368576.1 | 2056631 | g83650 | i0 | 86.7 | 0.969827586206897 | 75 | 10 | 97 | 0 | 4 | 228 | 209 | 283 | MEM3368576.1 hypothetical protein [Thermoproteota archaeon] | diamond | 225 | 126 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32448509 | 32448509 | PRJNA498309_P_NODE_94079_length_208_cov_11.409357_g91930_i0 | PRJNA498309 | 94079 | 208 | 11.409357 | 23.73146256 | Pyrobaculum arsenaticum | 121277 | Archaea | Archaea | 124 | 1.12e-31 | NR | WP_345803937.1 | 121277 | g91930 | i0 | 100 | 0.908653846153846 | 63 | 0 | 90.9 | 0 | 1 | 189 | 92 | 154 | WP_345803937.1 proton-conducting transporter membrane subunit [Pyrobaculum arsenaticum] | diamond | 189 | 124 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum arsenaticum |
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);;