contig_metadata
9 rows where bioproject = "PRJNA533114", tax_phylum = "Nanobdellota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27014291 | 27014291 | PRJNA533114_P_NODE_18702_length_523_cov_1.640000_g18453_i0 | PRJNA533114 | 18702 | 523 | 1.64 | 8.5772 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 112 | 4.17e-27 | NR | HLC74877.1 | 2910166 | g18453 | i0 | 41.4 | 2.42065009560229 | 162 | 82 | 91.8 | 6 | 480 | 1 | 29 | 179 | HLC74877.1 fatty acid desaturase family protein [Candidatus Nanoarchaeia archaeon] | diamond | 1266 | 112 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 27457022 | 27457022 | PRJNA533114_P_NODE_106143_length_246_cov_1.346821_g105891_i0 | PRJNA533114 | 106143 | 246 | 1.346821 | 3.31317966 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 120 | 2.32e-29 | NR | MCA9485224.1 | 2026764 | g105891 | i0 | 70.4 | 0.98780487804878 | 81 | 24 | 98.8 | 0 | 3 | 245 | 483 | 563 | MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] | diamond | 243 | 120 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 28941078 | 28941078 | PRJNA533114_P_NODE_33628_length_396_cov_1.448916_g33376_i0 | PRJNA533114 | 33628 | 396 | 1.448916 | 5.73770736 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 58.9 | 2.55e-8 | NR | MEK6926262.1 | 2026764 | g33376 | i0 | 59.2 | 0.727272727272727 | 49 | 20 | 37.1 | 0 | 9 | 155 | 32 | 80 | MEK6926262.1 RNA-binding protein [Nanoarchaeota archaeon] | diamond | 288 | 58.9 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29287987 | 29287987 | PRJNA533114_P_NODE_105589_length_247_cov_0.885057_g105337_i0 | PRJNA533114 | 105589 | 247 | 0.885057 | 2.18609079 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 48.5 | 1.07e-4 | NR | MEK6792489.1 | 2026764 | g105337 | i0 | 44 | 0.607287449392713 | 50 | 28 | 60.7 | 0 | 150 | 1 | 32 | 81 | MEK6792489.1 cytochrome b5-like heme/steroid binding domain-containing protein [Nanoarchaeota archaeon] | diamond | 150 | 48.5 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29776709 | 29776709 | PRJNA533114_P_NODE_71971_length_284_cov_1.146919_g71719_i0 | PRJNA533114 | 71971 | 284 | 1.146919 | 3.2572499600000002 | Nanobdellati | 1783276 | Archaea | Archaea | 44.7 | 0.0101 | NR | MBU0456521.1 | 2026764 | g71719 | i0 | 38.6 | 2.25 | 70 | 20 | 73.9 | 1 | 19 | 228 | 129 | 175 | MBU0456521.1 tRNA-dihydrouridine synthase family protein [Nanoarchaeota archaeon] | diamond | 639 | 45.1 | 0.991130820399113 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31088732 | 31088732 | PRJNA533114_P_NODE_58055_length_312_cov_1.288703_g57803_i0 | PRJNA533114 | 58055 | 312 | 1.288703 | 4.02075336 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 148 | 4.99e-39 | NR | MCA9485224.1 | 2026764 | g57803 | i0 | 68.3 | 1 | 104 | 32 | 99 | 1 | 3 | 311 | 246 | 349 | MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] | diamond | 312 | 148 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31752775 | 31752775 | PRJNA533114_P_NODE_8357_length_776_cov_2.280228_g8145_i0 | PRJNA533114 | 8357 | 776 | 2.280228 | 17.69456928 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 186 | 2.74e-52 | NR | MBU0461306.1 | 2026764 | g8145 | i0 | 38.8 | 0.997422680412371 | 258 | 125 | 99.7 | 4 | 2 | 775 | 145 | 369 | MBU0461306.1 class I tRNA ligase family protein [Nanoarchaeota archaeon] | diamond | 774 | 186 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32164344 | 32164344 | PRJNA533114_P_NODE_90878_length_254_cov_2.088398_g90626_i0 | PRJNA533114 | 90878 | 254 | 2.088398 | 5.30453092 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 41.2 | 0.0448 | NR | MEK6881965.1 | 2026764 | g90626 | i0 | 33.3 | 0.637795275590551 | 54 | 34 | 63.8 | 1 | 228 | 67 | 35 | 86 | MEK6881965.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 162 | 41.2 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32527487 | 32527487 | PRJNA533114_P_NODE_46219_length_345_cov_1.132353_g45967_i0 | PRJNA533114 | 46219 | 345 | 1.132353 | 3.90661785 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0165 | NR | MCK4670296.1 | 2026764 | g45967 | i0 | 31.7 | 0.982608695652174 | 60 | 41 | 52.2 | 0 | 83 | 262 | 245 | 304 | MCK4670296.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 339 | 45.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);;