contig_metadata
19 rows where bioproject = "PRJNA833575" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10157654 | 10157654 | PRJNA833575_P_NODE_5588_length_597_cov_1.793561_g5451_i0 | PRJNA833575 | 5588 | 597 | 1.793561 | 10.70755917 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 259 | 1.4e-77 | NR | MBR9691352.1 | 2026803 | g5451 | i0 | 63.3 | 10.9899497487437 | 199 | 73 | 100 | 0 | 1 | 597 | 4 | 202 | MBR9691352.1 pyruvate, phosphate dikinase [Candidatus Woesearchaeota archaeon] | diamond | 6561 | 259 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 11028130 | 11028130 | PRJNA833575_P_NODE_32949_length_258_cov_1.523810_g32812_i0 | PRJNA833575 | 32949 | 258 | 1.52381 | 3.9314298 | archaeon | 1906665 | Archaea | Archaea | 143 | 3.72e-40 | NR | MDP2437677.1 | 1906665 | g32812 | i0 | 89.2 | 0.965116279069767 | 83 | 9 | 96.5 | 0 | 257 | 9 | 77 | 159 | MDP2437677.1 serine/threonine-protein kinase [archaeon] | diamond | 249 | 143 | 1 | Archaea | archaeon | ||||||||
| 17806311 | 17806311 | PRJNA833575_P_NODE_19934_length_331_cov_0.866412_g19797_i0 | PRJNA833575 | 19934 | 331 | 0.866412 | 2.86782372 | archaeon | 1906665 | Archaea | Archaea | 105 | 5.9300000000000006e-27 | NR | MDP2439593.1 | 1906665 | g19797 | i0 | 53.1 | 0.88821752265861 | 98 | 44 | 87 | 1 | 8 | 295 | 3 | 100 | MDP2439593.1 hypothetical protein [archaeon] | diamond | 294 | 105 | 1 | Archaea | archaeon | ||||||||
| 19950885 | 19950885 | PRJNA833575_P_NODE_37156_length_239_cov_1.782353_g37019_i0 | PRJNA833575 | 37156 | 239 | 1.782353 | 4.25982367 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 127 | 5.86e-32 | NR | MDD5178149.1 | 2910166 | g37019 | i0 | 78.2 | 2.94979079497908 | 78 | 17 | 97.9 | 0 | 3 | 236 | 554 | 631 | MDD5178149.1 pyruvate, phosphate dikinase [Candidatus Nanoarchaeia archaeon] | diamond | 705 | 127 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 26706143 | 26706143 | PRJNA833575_P_NODE_19001_length_338_cov_1.338290_g18864_i0 | PRJNA833575 | 19001 | 338 | 1.33829 | 4.5234202 | archaeon | 1906665 | Archaea | Archaea | 48.5 | 0.001 | NR | MCQ2817480.1 | 1906665 | g18864 | i0 | 27.4 | 1.03846153846154 | 117 | 59 | 98.5 | 6 | 333 | 1 | 13 | 109 | MCQ2817480.1 thrombospondin type-1 domain-containing protein [archaeon] | diamond | 351 | 48.5 | 1 | Archaea | archaeon | ||||||||
| 27434104 | 27434104 | PRJNA833575_P_NODE_10143_length_451_cov_1.010471_g10006_i0 | PRJNA833575 | 10143 | 451 | 1.010471 | 4.55722421 | archaeon | 1906665 | Archaea | Archaea | 118 | 4.19e-30 | NR | MDP2437922.1 | 1906665 | g10006 | i0 | 44.9 | 1.0509977827051 | 158 | 78 | 99.1 | 5 | 449 | 3 | 11 | 168 | MDP2437922.1 glutathione S-transferase family protein [archaeon] | diamond | 474 | 118 | 1 | Archaea | archaeon | ||||||||
| 27559974 | 27559974 | PRJNA833575_P_NODE_4044_length_693_cov_2.801282_g3919_i0 | PRJNA833575 | 4044 | 693 | 2.801282 | 19.41288426 | archaeon | 1906665 | Archaea | Archaea | 112 | 4.93e-26 | NR | MCQ2821136.1 | 1906665 | g3919 | i0 | 63.2 | 0.74025974025974 | 171 | 62 | 74 | 1 | 663 | 151 | 7 | 176 | MCQ2821136.1 hypothetical protein [archaeon] | diamond | 513 | 112 | 1 | Archaea | archaeon | ||||||||
| 27821441 | 27821441 | PRJNA833575_P_NODE_25924_length_292_cov_1.614350_g25787_i0 | PRJNA833575 | 25924 | 292 | 1.61435 | 4.713902 | Archaea | 2157 | Archaea | Archaea | 83.6 | 3.17e-17 | NR | MCD6235937.1 | 2026795 | g25787 | i0 | 44.9 | 3.66780821917808 | 89 | 47 | 90.4 | 2 | 1 | 264 | 137 | 224 | MCD6235937.1 UMP kinase [Nitrososphaerota archaeon] | diamond | 1071 | 83.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28065335 | 28065335 | PRJNA833575_P_NODE_10425_length_445_cov_2.079787_g10288_i0 | PRJNA833575 | 10425 | 445 | 2.079787 | 9.25505215 | archaeon | 1906665 | Archaea | Archaea | 224 | 4.879999999999999e-72 | NR | MDP2437167.1 | 1906665 | g10288 | i0 | 81.5 | 0.910112359550562 | 135 | 25 | 91 | 0 | 40 | 444 | 13 | 147 | MDP2437167.1 50S ribosomal protein L5 [archaeon] | diamond | 405 | 224 | 1 | Archaea | archaeon | ||||||||
| 29328213 | 29328213 | PRJNA833575_P_NODE_42849_length_230_cov_0.894410_g42712_i0 | PRJNA833575 | 42849 | 230 | 0.89441 | 2.057143 | archaeon | 1906665 | Archaea | Archaea | 87.4 | 5.35e-18 | NR | MDP2435621.1 | 1906665 | g42712 | i0 | 45.3 | 0.978260869565217 | 75 | 40 | 97.8 | 1 | 2 | 226 | 296 | 369 | MDP2435621.1 hypothetical protein [archaeon] | diamond | 225 | 87.4 | 1 | Archaea | archaeon | ||||||||
| 29391564 | 29391564 | PRJNA833575_P_NODE_35249_length_248_cov_1.385475_g35112_i0 | PRJNA833575 | 35249 | 248 | 1.385475 | 3.435978 | archaeon | 1906665 | Archaea | Archaea | 77.4 | 2.17e-15 | NR | MCQ2817649.1 | 1906665 | g35112 | i0 | 45.7 | 0.979838709677419 | 81 | 44 | 98 | 0 | 5 | 247 | 101 | 181 | MCQ2817649.1 hypothetical protein [archaeon] | diamond | 243 | 77.4 | 1 | Archaea | archaeon | ||||||||
| 29706755 | 29706755 | PRJNA833575_P_NODE_41090_length_232_cov_0.883436_g40953_i0 | PRJNA833575 | 41090 | 232 | 0.883436 | 2.04957152 | archaeon | 1906665 | Archaea | Archaea | 49.7 | 3.72e-5 | NR | MDP2436418.1 | 1906665 | g40953 | i0 | 37.5 | 0.827586206896552 | 64 | 39 | 82.8 | 1 | 4 | 195 | 69 | 131 | MDP2436418.1 hypothetical protein [archaeon] | diamond | 192 | 49.7 | 1 | Archaea | archaeon | ||||||||
| 30221010 | 30221010 | PRJNA833575_P_NODE_40472_length_233_cov_0.878049_g40335_i0 | PRJNA833575 | 40472 | 233 | 0.878049 | 2.04585417 | root | 1 | Root_unresolved | Root_unresolved | 60.5 | 2.37e-9 | NR | MDF1538772.1 | 2053491 | g40335 | i0 | 37.8 | 4.58369098712446 | 74 | 46 | 95.3 | 0 | 8 | 229 | 16 | 89 | MDF1538772.1 6-carboxytetrahydropterin synthase [Candidatus Thorarchaeota archaeon] | diamond | 1068 | 60.5 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 31065903 | 31065903 | PRJNA833575_P_NODE_7815_length_510_cov_1.560091_g7678_i0 | PRJNA833575 | 7815 | 510 | 1.560091 | 7.9564641 | archaeon | 1906665 | Archaea | Archaea | 55.5 | 1.3e-5 | NR | MCQ2821136.1 | 1906665 | g7678 | i0 | 60.7 | 0.329411764705882 | 56 | 22 | 32.9 | 0 | 303 | 136 | 122 | 177 | MCQ2821136.1 hypothetical protein [archaeon] | diamond | 168 | 55.5 | 1 | Archaea | archaeon | ||||||||
| 31350309 | 31350309 | PRJNA833575_P_NODE_25716_length_293_cov_1.892857_g25579_i0 | PRJNA833575 | 25716 | 293 | 1.892857 | 5.54607101 | archaeon | 1906665 | Archaea | Archaea | 82 | 2.42e-16 | NR | MCQ2821136.1 | 1906665 | g25579 | i0 | 61.1 | 0.972696245733788 | 95 | 35 | 97.3 | 1 | 289 | 5 | 1 | 93 | MCQ2821136.1 hypothetical protein [archaeon] | diamond | 285 | 82 | 1 | Archaea | archaeon | ||||||||
| 31698108 | 31698108 | PRJNA833575_P_NODE_43537_length_229_cov_0.900000_g43400_i0 | PRJNA833575 | 43537 | 229 | 0.9 | 2.061 | Halobacteriales archaeon SW_12_69_24 | 1919197 | Archaea | Archaea | 41.6 | 0.0468 | NR | PSQ33497.1 | 1919197 | g43400 | i0 | 48.9 | 0.615720524017467 | 47 | 24 | 61.6 | 0 | 39 | 179 | 28 | 74 | PSQ33497.1 MAG: tryptophan-rich sensory protein [Halobacteriales archaeon SW_12_69_24] | diamond | 141 | 41.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon SW_12_69_24 | |||
| 31959664 | 31959664 | PRJNA833575_P_NODE_18257_length_344_cov_1.589091_g18120_i0 | PRJNA833575 | 18257 | 344 | 1.589091 | 5.46647304 | root | 1 | Root_unresolved | Root_unresolved | 80.1 | 8.76e-15 | NR | MBO7518105.1 | 66852 | g18120 | i0 | 69.4 | 2.80813953488372 | 49 | 14 | 41.9 | 1 | 218 | 75 | 423 | 471 | MBO7518105.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 966 | 80.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32867209 | 32867209 | PRJNA833575_P_NODE_25420_length_295_cov_1.274336_g25283_i0 | PRJNA833575 | 25420 | 295 | 1.274336 | 3.7592912 | archaeon | 1906665 | Archaea | Archaea | 65.1 | 9.71e-10 | NR | MDP2438056.1 | 1906665 | g25283 | i0 | 42.2 | 0.84406779661017 | 83 | 46 | 82.4 | 1 | 259 | 17 | 72 | 154 | MDP2438056.1 protein kinase [archaeon] | diamond | 249 | 65.1 | 1 | Archaea | archaeon | ||||||||
| 32898628 | 32898628 | PRJNA833575_P_NODE_32160_length_262_cov_1.119171_g32023_i0 | PRJNA833575 | 32160 | 262 | 1.119171 | 2.93222802 | archaeon | 1906665 | Archaea | Archaea | 122 | 1.3099999999999998e-31 | NR | MDP2439229.1 | 1906665 | g32023 | i0 | 66.3 | 0.984732824427481 | 86 | 29 | 98.5 | 0 | 261 | 4 | 245 | 330 | MDP2439229.1 phosphatidylinositol 4-kinase [archaeon] | diamond | 258 | 122 | 1 | Archaea | 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);;