contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27242652 | 27242652 | PRJNA758398_S_NODE_32263_length_188_cov_1.345324_g32122_i0 | PRJNA758398 | 32263 | 188 | 1.345324 | 2.52920912 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 47.4 | 4.06e-4 | NR | MBN2155576.1 | 2053489 | g32122 | i0 | 44.4 | 0.861702127659574 | 54 | 30 | 86.2 | 0 | 186 | 25 | 77 | 130 | MBN2155576.1 50S ribosomal protein L10 [Promethearchaeota archaeon] | diamond | 162 | 47.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 27463965 | 27463965 | PRJNA758398_S_NODE_12863_length_273_cov_2.732143_g12722_i0 | PRJNA758398 | 12863 | 273 | 2.732143 | 7.45875039 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 86.3 | 4.74e-18 | NR | NWF96413.1 | 2053491 | g12722 | i0 | 70.2 | 0.626373626373626 | 57 | 17 | 62.6 | 0 | 36 | 206 | 56 | 112 | NWF96413.1 deoxyribose-phosphate aldolase [Candidatus Thorarchaeota archaeon] | diamond | 171 | 86.3 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 27621858 | 27621858 | PRJNA758398_S_NODE_21464_length_221_cov_1.186047_g21323_i0 | PRJNA758398 | 21464 | 221 | 1.186047 | 2.62116387 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 59.3 | 3.88e-8 | NR | MBD3254534.1 | 2053489 | g21323 | i0 | 40.6 | 0.936651583710407 | 69 | 41 | 93.7 | 0 | 12 | 218 | 80 | 148 | MBD3254534.1 MFS transporter [Promethearchaeota archaeon] | diamond | 207 | 59.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 27874296 | 27874296 | PRJNA758398_S_NODE_31225_length_191_cov_0.978873_g31084_i0 | PRJNA758398 | 31225 | 191 | 0.978873 | 1.86964743 | Candidatus Thorarchaeota archaeon | 2053491 | Archaea | Archaea | 89 | 6.39e-19 | NR | TFG27179.1 | 2053491 | g31084 | i0 | 73.3 | 9.4869109947644 | 60 | 16 | 94.2 | 0 | 180 | 1 | 30 | 89 | TFG27179.1 MAG: threonine ammonia-lyase [Candidatus Thorarchaeota archaeon] | diamond | 1812 | 89 | 1 | Archaea | Promethearchaeati | Candidatus Thorarchaeota | Candidatus Thorarchaeota archaeon | ||||||
| 28632332 | 28632332 | PRJNA758398_S_NODE_42767_length_167_cov_0.864407_g42626_i0 | PRJNA758398 | 42767 | 167 | 0.864407 | 1.44355969 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 41.2 | 0.0471 | NR | MBY8985525.1 | 2053489 | g42626 | i0 | 55.9 | 0.610778443113772 | 34 | 15 | 61.1 | 0 | 1 | 102 | 88 | 121 | MBY8985525.1 alpha-L-fucosidase [Promethearchaeota archaeon] | diamond | 102 | 41.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29579050 | 29579050 | PRJNA758398_S_NODE_29150_length_196_cov_1.557823_g29009_i0 | PRJNA758398 | 29150 | 196 | 1.557823 | 3.05333308 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 76.3 | 3.12e-14 | NR | TXT67626.1 | 2053489 | g29009 | i0 | 59.3 | 0.826530612244898 | 54 | 22 | 82.7 | 0 | 22 | 183 | 678 | 731 | TXT67626.1 MAG: hypothetical protein BAJALOKI1v1_40029 [Promethearchaeota archaeon] | diamond | 162 | 76.3 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30789473 | 30789473 | PRJNA758398_S_NODE_14574_length_259_cov_1.214286_g14433_i0 | PRJNA758398 | 14574 | 259 | 1.214286 | 3.14500074 | Promethearchaeati | 1935183 | Archaea | Archaea | 66.6 | 1.6e-10 | NR | MBD3405183.1 | 2053489 | g14433 | i0 | 43.2 | 3.75289575289575 | 81 | 46 | 93.8 | 0 | 257 | 15 | 321 | 401 | MBD3405183.1 threonine ammonia-lyase [Promethearchaeota archaeon] | diamond | 972 | 66.6 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota 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);;