contig_metadata
8 rows where bioproject = "PRJEB14803" and tax_kingdom = "Promethearchaeati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27475533 | 27475533 | PRJEB14803_P_NODE_5783_length_572_cov_2.702048_g5361_i0 | PRJEB14803 | 5783 | 572 | 2.702048 | 15.45571456 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 79.7 | 2.3e-15 | NR | OLS12533.1 | 1849166 | g5361 | i0 | 33.6 | 0.671328671328671 | 128 | 83 | 67.1 | 2 | 437 | 54 | 7 | 132 | OLS12533.1 MAG: hypothetical protein RBG13Loki_3844 [Promethearchaeota archaeon CR_4] | diamond | 384 | 79.7 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon CR_4 | ||||||
| 27791355 | 27791355 | PRJEB14803_P_NODE_1744_length_1088_cov_2.446344_g1514_i0 | PRJEB14803 | 1744 | 1088 | 2.446344 | 26.61622272 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 66.2 | 5.62e-8 | NR | MDH5404732.1 | 2026747 | g1514 | i0 | 33.1 | 0.441176470588235 | 160 | 87 | 40.5 | 7 | 850 | 410 | 118 | 270 | MDH5404732.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon] | diamond | 480 | 66.2 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 28170193 | 28170193 | PRJEB14803_P_NODE_9066_length_435_cov_1.717500_g8603_i0 | PRJEB14803 | 9066 | 435 | 1.7175 | 7.471125 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 62.4 | 3.97e-8 | NR | MBY8981431.1 | 2053489 | g8603 | i0 | 30.5 | 0.813793103448276 | 118 | 80 | 81.4 | 1 | 79 | 432 | 68 | 183 | MBY8981431.1 tetratricopeptide repeat protein [Promethearchaeota archaeon] | diamond | 354 | 62.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28580707 | 28580707 | PRJEB14803_P_NODE_24207_length_228_cov_1.243523_g23741_i0 | PRJEB14803 | 24207 | 228 | 1.243523 | 2.83523244 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 67.8 | 4.12e-11 | NR | MBN1215315.1 | 2053489 | g23741 | i0 | 48.5 | 1.82894736842105 | 68 | 34 | 89.5 | 1 | 217 | 14 | 286 | 352 | MBN1215315.1 tetratricopeptide repeat protein [Promethearchaeota archaeon] | diamond | 417 | 67.8 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 28769951 | 28769951 | PRJEB14803_P_NODE_14967_length_313_cov_2.061151_g14501_i0 | PRJEB14803 | 14967 | 313 | 2.061151 | 6.45140263 | Candidatus Sigynarchaeota archaeon | 3036967 | Archaea | Archaea | 52.4 | 3.5e-5 | NR | MEX2719049.1 | 3036967 | g14501 | i0 | 37.5 | 1.84025559105431 | 96 | 52 | 90.1 | 4 | 311 | 30 | 847 | 936 | MEX2719049.1 SIR2 family protein [Candidatus Sigynarchaeota archaeon] | diamond | 576 | 52.4 | 1 | Archaea | Promethearchaeati | Candidatus Sigynarchaeota | Candidatus Sigynarchaeota archaeon | ||||||
| 30728146 | 30728146 | PRJEB14803_P_NODE_23214_length_234_cov_1.572864_g22748_i0 | PRJEB14803 | 23214 | 234 | 1.572864 | 3.68050176 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 87.8 | 4.47e-18 | NR | HME52151.1 | 3067280 | g22748 | i0 | 51.3 | 1.93589743589744 | 76 | 37 | 97.4 | 0 | 233 | 6 | 787 | 862 | HME52151.1 SIR2 family protein [Promethearchaeia archaeon] | diamond | 453 | 87.8 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30854536 | 30854536 | PRJEB14803_P_NODE_24954_length_223_cov_1.675532_g24488_i0 | PRJEB14803 | 24954 | 223 | 1.675532 | 3.73643636 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 74.7 | 1.38e-13 | NR | MCY3413445.1 | 2026747 | g24488 | i0 | 47.9 | 0.982062780269058 | 73 | 38 | 98.2 | 0 | 221 | 3 | 76 | 148 | MCY3413445.1 VWA domain-containing protein [Candidatus Heimdallarchaeota archaeon] | diamond | 219 | 74.7 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 32024664 | 32024664 | PRJEB14803_P_NODE_7458_length_489_cov_5.427313_g7003_i0 | PRJEB14803 | 7458 | 489 | 5.427313 | 26.53956057 | Promethearchaeota archaeon CR_4 | 1849166 | Archaea | Archaea | 78.2 | 4.21e-15 | NR | OLS12533.1 | 1849166 | g7003 | i0 | 32.8 | 0.785276073619632 | 128 | 84 | 78.5 | 2 | 442 | 59 | 7 | 132 | OLS12533.1 MAG: hypothetical protein RBG13Loki_3844 [Promethearchaeota archaeon CR_4] | diamond | 384 | 78.2 | 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);;