contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA675331" and tax_clade = "Apusozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6272471 | 6272471 | PRJNA675331_P_NODE_17445_length_254_cov_2.751381_g17273_i0 | PRJNA675331 | 17445 | 254 | 2.751381 | 6.98850774 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 117 | 5.750000000000001e-29 | NR | XP_013753861.1 | 461836 | g17273 | i0 | 56 | 0.992125984251969 | 84 | 37 | 99.2 | 0 | 2 | 253 | 51 | 134 | XP_013753861.1 protein disulfide isomerase A [Thecamonas trahens ATCC 50062] | diamond | 252 | 117 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8301096 | 8301096 | PRJNA675331_P_NODE_18827_length_250_cov_0.870056_g18655_i0 | PRJNA675331 | 18827 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 1.9299999999999998e-32 | NR | XP_013758235.1 | 461836 | g18655 | i0 | 76.8 | 15.744 | 82 | 19 | 98.4 | 0 | 248 | 3 | 888 | 969 | XP_013758235.1 uncharacterized protein AMSG_11856 [Thecamonas trahens ATCC 50062] | diamond | 3936 | 130 | 0.992307692307692 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28881881 | 28881881 | PRJNA675331_P_NODE_13768_length_277_cov_1.343137_g13596_i0 | PRJNA675331 | 13768 | 277 | 1.343137 | 3.72048949 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 85.1 | 1.19e-18 | NR | XP_013758370.1 | 461836 | g13596 | i0 | 46.7 | 0.974729241877256 | 90 | 48 | 97.5 | 0 | 4 | 273 | 49 | 138 | XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062] | diamond | 270 | 85.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29134804 | 29134804 | PRJNA675331_P_NODE_3869_length_478_cov_1.711111_g3697_i0 | PRJNA675331 | 3869 | 478 | 1.711111 | 8.17911058 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 82.8 | 1.37e-16 | NR | XP_013753243.1 | 461836 | g3697 | i0 | 30.7 | 0.941422594142259 | 150 | 101 | 92.3 | 2 | 7 | 447 | 12 | 161 | XP_013753243.1 uncharacterized protein AMSG_10809 [Thecamonas trahens ATCC 50062] | diamond | 450 | 82.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29525386 | 29525386 | PRJNA675331_P_NODE_1570_length_727_cov_1.353211_g1410_i0 | PRJNA675331 | 1570 | 727 | 1.353211 | 9.83784397 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 207 | 6.75e-62 | NR | XP_013755573.1 | 461836 | g1410 | i0 | 47.8 | 4.48968363136176 | 205 | 106 | 84.2 | 1 | 68 | 679 | 122 | 326 | XP_013755573.1 cysteine protease CP19 [Thecamonas trahens ATCC 50062] | diamond | 3264 | 207 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29714340 | 29714340 | PRJNA675331_P_NODE_24410_length_237_cov_2.347561_g24238_i0 | PRJNA675331 | 24410 | 237 | 2.347561 | 5.56371957 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 1.45e-39 | NR | XP_013762907.1 | 461836 | g24238 | i0 | 88.5 | 2.9620253164557 | 78 | 9 | 98.7 | 0 | 236 | 3 | 393 | 470 | XP_013762907.1 elongation factor 2 [Thecamonas trahens ATCC 50062] | diamond | 702 | 149 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31800297 | 31800297 | PRJNA675331_P_NODE_2297_length_608_cov_1.833645_g2131_i0 | PRJNA675331 | 2297 | 608 | 1.833645 | 11.1485616 | root | 1 | Root_unresolved | Root_unresolved | 213 | 2.91e-64 | NR | XP_013757656.1 | 461836 | g2131 | i0 | 50.7 | 2.99506578947368 | 201 | 98 | 99.2 | 1 | 6 | 608 | 104 | 303 | XP_013757656.1 NAD-dependent epimerase/dehydratase [Thecamonas trahens ATCC 50062] | diamond | 1821 | 213 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32073489 | 32073489 | PRJNA675331_P_NODE_21598_length_245_cov_0.895349_g21426_i0 | PRJNA675331 | 21598 | 245 | 0.895349 | 2.19360505 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 63.5 | 1.84e-9 | NR | XP_013754951.1 | 461836 | g21426 | i0 | 51.9 | 0.942857142857143 | 77 | 34 | 90.6 | 2 | 240 | 19 | 3155 | 3231 | XP_013754951.1 uncharacterized protein AMSG_08995 [Thecamonas trahens ATCC 50062] | diamond | 231 | 63.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32799876 | 32799876 | PRJNA675331_P_NODE_22660_length_243_cov_0.905882_g22488_i0 | PRJNA675331 | 22660 | 243 | 0.905882 | 2.20129326 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 46.6 | 0.00173 | NR | XP_013757898.1 | 461836 | g22488 | i0 | 37.3 | 0.925925925925926 | 75 | 43 | 90.1 | 2 | 25 | 243 | 3083 | 3155 | XP_013757898.1 uncharacterized protein AMSG_05495 [Thecamonas trahens ATCC 50062] | diamond | 225 | 46.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens |
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);;