contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_kingdom = "Nanobdellati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26598771 | 26598771 | PRJNA168635_P_NODE_29901_length_164_cov_0.904348_g29485_i0 | PRJNA168635 | 29901 | 164 | 0.904348 | 1.48313072 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 61.2 | 1.06e-9 | NR | MCK9569155.1 | 2026773 | g29485 | i0 | 58 | 1.84756097560976 | 50 | 19 | 91.5 | 1 | 151 | 2 | 3 | 50 | MCK9569155.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 303 | 61.2 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 26789221 | 26789221 | PRJNA168635_P_NODE_34101_length_156_cov_2.093458_g33685_i0 | PRJNA168635 | 34101 | 156 | 2.093458 | 3.26579448 | Candidatus Micrarchaeia archaeon | 3018267 | Archaea | Archaea | 68.2 | 5.04e-12 | NR | MEM3771938.1 | 3018267 | g33685 | i0 | 57.7 | 1 | 52 | 20 | 100 | 1 | 1 | 156 | 52 | 101 | MEM3771938.1 hypothetical protein [Candidatus Micrarchaeia archaeon] | diamond | 156 | 68.2 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeia archaeon | |||||
| 26915684 | 26915684 | PRJNA168635_P_NODE_23082_length_173_cov_32.612903_g22666_i0 | PRJNA168635 | 23082 | 173 | 32.612903 | 56.42032219 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 52.8 | 4.21e-6 | NR | RLI98618.1 | 3121606 | g22666 | i0 | 53.3 | 0.780346820809249 | 45 | 21 | 78 | 0 | 167 | 33 | 216 | 260 | RLI98618.1 MAG: hypothetical protein DRP08_07985, partial [Candidatus Aenigmatarchaeota archaeon] | diamond | 135 | 52.8 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27105336 | 27105336 | PRJNA168635_P_NODE_29262_length_165_cov_0.896552_g28846_i0 | PRJNA168635 | 29262 | 165 | 0.896552 | 1.4793108 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 57 | 1.06e-7 | NR | MEK6829910.1 | 2026764 | g28846 | i0 | 52.8 | 0.654545454545455 | 36 | 17 | 65.5 | 0 | 6 | 113 | 270 | 305 | MEK6829910.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 108 | 57 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27168526 | 27168526 | PRJNA168635_P_NODE_34662_length_154_cov_2.752381_g34246_i0 | PRJNA168635 | 34662 | 154 | 2.752381 | 4.23866674 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 59.3 | 1.51e-8 | NR | MCA9485224.1 | 2026764 | g34246 | i0 | 60 | 0.876623376623377 | 45 | 18 | 87.7 | 0 | 140 | 6 | 285 | 329 | MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] | diamond | 135 | 59.3 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27642790 | 27642790 | PRJNA168635_P_NODE_34784_length_153_cov_7.605769_g34368_i0 | PRJNA168635 | 34784 | 153 | 7.605769 | 11.63682657 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 50.1 | 2.75e-5 | NR | MEM4260492.1 | 2026803 | g34368 | i0 | 44.9 | 0.96078431372549 | 49 | 26 | 96.1 | 1 | 149 | 3 | 19 | 66 | MEM4260492.1 ATP-binding protein [Candidatus Woesearchaeota archaeon] | diamond | 147 | 50.1 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 28242311 | 28242311 | PRJNA168635_P_NODE_18686_length_187_cov_1.456522_g18270_i0 | PRJNA168635 | 18686 | 187 | 1.456522 | 2.72369614 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 42 | 0.0166 | NR | MCX8147411.1 | 2026803 | g18270 | i0 | 63 | 0.834224598930481 | 27 | 10 | 43.3 | 0 | 83 | 3 | 1 | 27 | MCX8147411.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 156 | 42 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 28400364 | 28400364 | PRJNA168635_P_NODE_29026_length_165_cov_0.896552_g28610_i0 | PRJNA168635 | 29026 | 165 | 0.896552 | 1.4793108 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 78.2 | 4.01e-15 | NR | MBW3019666.1 | 2026803 | g28610 | i0 | 62.7 | 1.78181818181818 | 51 | 19 | 92.7 | 0 | 11 | 163 | 125 | 175 | MBW3019666.1 glycosyltransferase [Candidatus Woesearchaeota archaeon] | diamond | 294 | 78.2 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 29442033 | 29442033 | PRJNA168635_P_NODE_31730_length_162_cov_1.663717_g31314_i0 | PRJNA168635 | 31730 | 162 | 1.663717 | 2.69522154 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 48.9 | 8.49e-5 | NR | MFA5071040.1 | 2026773 | g31314 | i0 | 62.2 | 0.685185185185185 | 37 | 14 | 68.5 | 0 | 162 | 52 | 40 | 76 | MFA5071040.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 111 | 48.9 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29789471 | 29789471 | PRJNA168635_P_NODE_23451_length_173_cov_1.032258_g23035_i0 | PRJNA168635 | 23451 | 173 | 1.032258 | 1.78580634 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 76.3 | 2.2e-14 | NR | MAH49075.1 | 2026773 | g23035 | i0 | 71.1 | 0.780346820809249 | 45 | 13 | 78 | 0 | 37 | 171 | 48 | 92 | MAH49075.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 135 | 76.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30231880 | 30231880 | PRJNA168635_P_NODE_24392_length_170_cov_4.702479_g23976_i0 | PRJNA168635 | 24392 | 170 | 4.702479 | 7.9942143 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 51.2 | 9.09e-7 | NR | MEJ2267978.1 | 2026764 | g23976 | i0 | 54.5 | 1.95882352941176 | 55 | 24 | 95.3 | 1 | 8 | 169 | 4 | 58 | MEJ2267978.1 DUF378 domain-containing protein [Nanoarchaeota archaeon] | diamond | 333 | 51.2 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32097022 | 32097022 | PRJNA168635_P_NODE_18598_length_187_cov_2.181159_g18182_i0 | PRJNA168635 | 18598 | 187 | 2.181159 | 4.07876733 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 78.2 | 4.91e-16 | NR | MEM4260928.1 | 2026803 | g18182 | i0 | 68.6 | 0.818181818181818 | 51 | 16 | 81.8 | 0 | 35 | 187 | 4 | 54 | MEM4260928.1 HNH endonuclease [Candidatus Woesearchaeota archaeon] | diamond | 153 | 78.2 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32318870 | 32318870 | PRJNA168635_P_NODE_28779_length_165_cov_1.000000_g28363_i0 | PRJNA168635 | 28779 | 165 | 1 | 1.65 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 95.1 | 1.4599999999999995e-23 | NR | MEK6828573.1 | 2026764 | g28363 | i0 | 73.7 | 1.03636363636364 | 57 | 13 | 100 | 1 | 165 | 1 | 35 | 91 | MEK6828573.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 171 | 95.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota 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);;