contig_metadata
13 rows where bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513345 | 6513345 | PRJEB7366_P_NODE_17326_length_185_cov_1.600000_g16892_i0 | PRJEB7366 | 17326 | 185 | 1.6 | 2.96 | archaeon | 1906665 | Archaea | Archaea | 117 | 2.04e-31 | NR | MDP2439237.1 | 1906665 | g16892 | i0 | 86.9 | 0.989189189189189 | 61 | 8 | 98.9 | 0 | 185 | 3 | 121 | 181 | MDP2439237.1 50S ribosomal protein L15e [archaeon] | diamond | 183 | 117 | 1 | Archaea | archaeon | ||||||||
| 20536154 | 20536154 | PRJEB7366_P_NODE_19677_length_172_cov_1.167883_g19243_i0 | PRJEB7366 | 19677 | 172 | 1.167883 | 2.00875876 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 86.3 | 4.82e-18 | NR | OLS15498.1 | 1849166 | g19243 | i0 | 76.8 | 0.976744186046512 | 56 | 13 | 97.7 | 0 | 4 | 171 | 257 | 312 | OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4] | diamond | 168 | 86.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 | ||||||
| 26939034 | 26939034 | PRJEB7366_P_NODE_13442_length_217_cov_1.098901_g13008_i0 | PRJEB7366 | 13442 | 217 | 1.098901 | 2.38461517 | archaeon | 1906665 | Archaea | Archaea | 79 | 2.01e-16 | NR | MDP2434319.1 | 1906665 | g13008 | i0 | 52.2 | 0.953917050691244 | 69 | 31 | 92.6 | 1 | 3 | 203 | 19 | 87 | MDP2434319.1 glutathione S-transferase family protein [archaeon] | diamond | 207 | 79 | 1 | Archaea | archaeon | ||||||||
| 27722343 | 27722343 | PRJEB7366_P_NODE_14044_length_211_cov_1.363636_g13610_i0 | PRJEB7366 | 14044 | 211 | 1.363636 | 2.87727196 | Halovalidus | 3383206 | Archaea | Archaea | 88.2 | 2.17e-19 | NR | MBJ32717.1 | 2026739 | g13610 | i0 | 57.4 | 1.96208530805687 | 68 | 29 | 96.7 | 0 | 2 | 205 | 153 | 220 | MBJ32717.1 adenylate kinase [Methanobacteriota archaeon] | diamond | 414 | 88.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27879797 | 27879797 | PRJEB7366_P_NODE_15625_length_197_cov_1.481481_g15191_i0 | PRJEB7366 | 15625 | 197 | 1.481481 | 2.91851757 | Archaea | 2157 | Archaea | Archaea | 94.7 | 5.480000000000001e-21 | NR | OLS15498.1 | 1849166 | g15191 | i0 | 72.1 | 1.85786802030457 | 61 | 17 | 92.9 | 0 | 11 | 193 | 286 | 346 | OLS15498.1 MAG: protein AtoB1 [Promethearchaeota archaeon CR_4] | diamond | 366 | 94.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 | ||||||
| 28297397 | 28297397 | PRJEB7366_P_NODE_24806_length_150_cov_1.391304_g24372_i0 | PRJEB7366 | 24806 | 150 | 1.391304 | 2.086956 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 67.4 | 2.01e-11 | NR | MBU1199156.1 | 2026764 | g24372 | i0 | 65.3 | 2.94 | 49 | 17 | 98 | 0 | 148 | 2 | 267 | 315 | MBU1199156.1 ATP-binding protein [Nanoarchaeota archaeon] | diamond | 441 | 67.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29371076 | 29371076 | PRJEB7366_P_NODE_12129_length_232_cov_1.395939_g11695_i0 | PRJEB7366 | 12129 | 232 | 1.395939 | 3.23857848 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 97.4 | 9.78e-22 | NR | OLS14603.1 | 1849166 | g11695 | i0 | 83.3 | 1.39655172413793 | 54 | 9 | 69.8 | 0 | 232 | 71 | 364 | 417 | OLS14603.1 MAG: acetyl-CoA acetyltransferase [Promethearchaeota archaeon CR_4] | diamond | 324 | 97.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 | ||||||
| 30002708 | 30002708 | PRJEB7366_P_NODE_23111_length_156_cov_1.652893_g22677_i0 | PRJEB7366 | 23111 | 156 | 1.652893 | 2.57851308 | archaeon | 1906665 | Archaea | Archaea | 43.1 | 0.00821 | NR | RYG61804.1 | 1906665 | g22677 | i0 | 48.4 | 1.23076923076923 | 31 | 16 | 59.6 | 0 | 94 | 2 | 29 | 59 | RYG61804.1 MAG: YHYH protein [archaeon] | diamond | 192 | 43.1 | 1 | Archaea | archaeon | ||||||||
| 30223653 | 30223653 | PRJEB7366_P_NODE_5212_length_397_cov_1.698895_g4779_i0 | PRJEB7366 | 5212 | 397 | 1.698895 | 6.74461315 | archaeon | 1906665 | Archaea | Archaea | 176 | 3.95e-49 | NR | MDP2436218.1 | 1906665 | g4779 | i0 | 65.1 | 1.94962216624685 | 129 | 45 | 97.5 | 0 | 1 | 387 | 262 | 390 | MDP2436218.1 acyl-CoA dehydrogenase C-terminal domain-containing protein [archaeon] | diamond | 774 | 176 | 1 | Archaea | archaeon | ||||||||
| 31101020 | 31101020 | PRJEB7366_P_NODE_9995_length_262_cov_2.612335_g9561_i0 | PRJEB7366 | 9995 | 262 | 2.612335 | 6.8443177 | Archaea | 2157 | Archaea | Archaea | 53.1 | 1.73e-6 | NR | MFH1589218.1 | 1906665 | g9561 | i0 | 47.4 | 3.17175572519084 | 57 | 27 | 61.8 | 3 | 7 | 168 | 46 | 102 | MFH1589218.1 thioredoxin domain-containing protein [archaeon] | diamond | 831 | 53.1 | 1 | Archaea | archaeon | ||||||||
| 31234660 | 31234660 | PRJEB7366_P_NODE_22655_length_158_cov_1.536585_g22221_i0 | PRJEB7366 | 22655 | 158 | 1.536585 | 2.4278043 | Methanobrevibacter olleyae | 294671 | Archaea | Archaea | 40.8 | 0.0152 | NR | AMK16309.1 | 294671 | g22221 | i0 | 51.6 | 0.588607594936709 | 31 | 15 | 58.9 | 0 | 107 | 15 | 3 | 33 | AMK16309.1 phage-related protein [Methanobrevibacter olleyae] | diamond | 93 | 40.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter olleyae | |
| 31329647 | 31329647 | PRJEB7366_P_NODE_20656_length_167_cov_1.280303_g20222_i0 | PRJEB7366 | 20656 | 167 | 1.280303 | 2.13810601 | Theionarchaea archaeon DG-7 | 2747605 | Archaea | Archaea | 72 | 2.8e-13 | NR | KYK33069.1 | 1803814 | g20222 | i0 | 59.6 | 3.66467065868263 | 52 | 21 | 93.4 | 0 | 4 | 159 | 35 | 86 | KYK33069.1 MAG: glyoxal reductase [Theionarchaea archaeon DG-70-1] | diamond | 612 | 72 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Theionarchaea | Theionarchaea archaeon DG-70-1 | |||||
| 32342245 | 32342245 | PRJEB7366_P_NODE_23319_length_155_cov_2.333333_g22885_i0 | PRJEB7366 | 23319 | 155 | 2.333333 | 3.61666615 | archaeon | 1906665 | Archaea | Archaea | 62 | 2.29e-10 | NR | RYH04971.1 | 1906665 | g22885 | i0 | 58.3 | 0.929032258064516 | 48 | 17 | 92.9 | 1 | 11 | 154 | 90 | 134 | RYH04971.1 MAG: hypothetical protein EON65_45995 [archaeon] | diamond | 144 | 62 | 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);;