contig_metadata
4 rows where bioproject = "PRJNA773247", tax_kingdom = "Promethearchaeati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27590634 | 27590634 | PRJNA773247_P_NODE_16404_length_362_cov_3.588235_g16320_i0 | PRJNA773247 | 16404 | 362 | 3.588235 | 12.9894107 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 58.5 | 8.29e-8 | NR | TFG99969.1 | 2053491 | g16320 | i0 | 50.9 | 0.472375690607735 | 57 | 27 | 46.4 | 1 | 2 | 169 | 106 | 162 | TFG99969.1 MAG: hypothetical protein E4H12_00835 [Candidatus Thorarchaeota archaeon] | diamond | 171 | 58.5 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 30369740 | 30369740 | PRJNA773247_P_NODE_19012_length_331_cov_2.728682_g18928_i0 | PRJNA773247 | 19012 | 331 | 2.728682 | 9.03193742 | Candidatus Hodarchaeales archaeon | 3069329 | Archaea | Archaea | 83.2 | 6.53e-18 | NR | HKZ43294.1 | 3069329 | g18928 | i0 | 43.8 | 1.79456193353474 | 96 | 53 | 86.1 | 1 | 323 | 39 | 18 | 113 | HKZ43294.1 hypothetical protein [Candidatus Hodarchaeales archaeon] | diamond | 594 | 83.2 | 1 | Archaea | Promethearchaeati | Candidatus Hodarchaeota | Candidatus Hodarchaeia | Candidatus Hodarchaeales | Candidatus Hodarchaeales archaeon | ||||
| 31475532 | 31475532 | PRJNA773247_P_NODE_19036_length_331_cov_1.782946_g18952_i0 | PRJNA773247 | 19036 | 331 | 1.782946 | 5.90155126 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 62.8 | 2.48e-10 | NR | TFG96793.1 | 2053491 | g18952 | i0 | 50.8 | 0.589123867069486 | 65 | 23 | 50.8 | 1 | 329 | 162 | 20 | 84 | TFG96793.1 MAG: hypothetical protein E4H12_10245 [Candidatus Thorarchaeota archaeon] | diamond | 195 | 62.8 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 32013175 | 32013175 | PRJNA773247_P_NODE_20518_length_316_cov_1.267490_g20434_i0 | PRJNA773247 | 20518 | 316 | 1.26749 | 4.0052684 | Candidatus Sigynarchaeota archaeon | 3036967 | Archaea | Archaea | 60.8 | 9.43e-10 | NR | MEX2716764.1 | 3036967 | g20434 | i0 | 49.2 | 0.579113924050633 | 61 | 29 | 57.9 | 1 | 264 | 82 | 6 | 64 | MEX2716764.1 helix-turn-helix domain-containing protein [Candidatus Sigynarchaeota archaeon] | diamond | 183 | 60.8 | 1 | Archaea | Promethearchaeati | Candidatus Sigynarchaeota | Candidatus Sigynarchaeota 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);;