contig_metadata
9 rows where bioproject = "PRJNA1144090", tax_phylum = "Promethearchaeota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11765917 | 11765917 | PRJNA1144090_P_NODE_36510_length_430_cov_1.294118_g35975_i0 | PRJNA1144090 | 36510 | 430 | 1.294118 | 5.5647074 | Archaea | 2157 | Archaea | Archaea | 207 | 3.65e-62 | NR | KKK45229.1 | 1538547 | g35975 | i0 | 66.4 | 15.9558139534884 | 143 | 48 | 99.8 | 0 | 2 | 430 | 127 | 269 | KKK45229.1 MAG: Cyclic 2,3-diphosphoglycerate synthetase [Candidatus Lokiarchaeum sp. GC14_75] | diamond | 6861 | 207 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Lokiarchaeum | Candidatus Lokiarchaeum sp. GC14_75 | ||
| 27260216 | 27260216 | PRJNA1144090_P_NODE_49563_length_362_cov_5.650519_g49028_i0 | PRJNA1144090 | 49563 | 362 | 5.650519 | 20.45487878 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 48.9 | 8.74e-4 | NR | MBY9020929.1 | 2053489 | g49028 | i0 | 39.5 | 0.629834254143646 | 76 | 41 | 61.3 | 3 | 264 | 43 | 165 | 237 | MBY9020929.1 GTP-binding protein [Promethearchaeota archaeon] | diamond | 228 | 48.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 27702640 | 27702640 | PRJNA1144090_P_NODE_49944_length_361_cov_2.118056_g49409_i0 | PRJNA1144090 | 49944 | 361 | 2.118056 | 7.64618216 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 95.5 | 5.5600000000000006e-21 | NR | MBD3350911.1 | 2053489 | g49409 | i0 | 39.8 | 1.10526315789474 | 133 | 67 | 99.7 | 1 | 1 | 360 | 143 | 275 | MBD3350911.1 DUF1152 domain-containing protein [Promethearchaeota archaeon] | diamond | 399 | 95.5 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28449249 | 28449249 | PRJNA1144090_P_NODE_111466_length_244_cov_0.900585_g110931_i0 | PRJNA1144090 | 111466 | 244 | 0.900585 | 2.1974274 | Candidatus Harpocratesius | 3049169 | Archaea | Archaea | 91.3 | 2.27e-19 | NR | TFG17558.1 | 2053489 | g110931 | i0 | 60.9 | 8.49590163934426 | 69 | 25 | 84.8 | 1 | 209 | 3 | 2 | 68 | TFG17558.1 MAG: GTPase [Promethearchaeota archaeon] | diamond | 2073 | 91.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28933781 | 28933781 | PRJNA1144090_P_NODE_54908_length_343_cov_2.033333_g54373_i0 | PRJNA1144090 | 54908 | 343 | 2.033333 | 6.97433219 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.1 | 0.0454 | NR | MBY8979638.1 | 2053489 | g54373 | i0 | 28.7 | 0.822157434402332 | 94 | 58 | 82.2 | 2 | 324 | 43 | 77 | 161 | MBY8979638.1 DUF3795 domain-containing protein [Promethearchaeota archaeon] | diamond | 282 | 43.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30512822 | 30512822 | PRJNA1144090_P_NODE_85713_length_272_cov_1.381910_g85178_i0 | PRJNA1144090 | 85713 | 272 | 1.38191 | 3.7587952 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 47.4 | 9.64e-4 | NR | MBN2154198.1 | 2053489 | g85178 | i0 | 40 | 0.496323529411765 | 45 | 27 | 49.6 | 0 | 163 | 29 | 1 | 45 | MBN2154198.1 hypothetical protein [Promethearchaeota archaeon] | diamond | 135 | 47.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30544417 | 30544417 | PRJNA1144090_P_NODE_116753_length_241_cov_0.916667_g116218_i0 | PRJNA1144090 | 116753 | 241 | 0.916667 | 2.20916747 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 70.9 | 9.58e-13 | NR | HMF32723.1 | 3067280 | g116218 | i0 | 54.2 | 0.734439834024896 | 59 | 27 | 73.4 | 0 | 181 | 5 | 4 | 62 | HMF32723.1 TSUP family transporter [Promethearchaeia archaeon] | diamond | 177 | 70.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31608067 | 31608067 | PRJNA1144090_P_NODE_43576_length_389_cov_2.120253_g43041_i0 | PRJNA1144090 | 43576 | 389 | 2.120253 | 8.24778417 | Promethearchaeaceae | 3366644 | Archaea | Archaea | 107 | 2.06e-24 | NR | UYP46776.1 | 2951803 | g43041 | i0 | 48.8 | 1.9974293059126 | 129 | 57 | 99.5 | 2 | 3 | 389 | 305 | 424 | UYP46776.1 Glycerate 2-kinase [Candidatus Lokiarchaeum ossiferum] | diamond | 777 | 107 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Lokiarchaeum | Candidatus Lokiarchaeum ossiferum | ||
| 32283817 | 32283817 | PRJNA1144090_P_NODE_84479_length_274_cov_1.497512_g83944_i0 | PRJNA1144090 | 84479 | 274 | 1.497512 | 4.10318288 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 56.6 | 6.45e-7 | NR | OLS14127.1 | 1849166 | g83944 | i0 | 76.9 | 0.427007299270073 | 39 | 8 | 42.7 | 1 | 154 | 270 | 15 | 52 | OLS14127.1 MAG: short-chain alcohol dehydrogenase [Promethearchaeota archaeon CR_4] | diamond | 117 | 56.6 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 |
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);;