contig_metadata
9 rows where bioproject = "PRJNA533623", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11985520 | 11985520 | PRJNA533623_P_NODE_52950_length_281_cov_9.472727_g51171_i0 | PRJNA533623 | 52950 | 281 | 9.472727 | 26.61836287 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 63.9 | 2.11e-9 | NR | XP_013756857.1 | 461836 | g51171 | i0 | 42.1 | 2.47686832740214 | 76 | 44 | 81.1 | 0 | 23 | 250 | 505 | 580 | XP_013756857.1 TBC1D2 protein [Thecamonas trahens ATCC 50062] | diamond | 696 | 63.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 13871547 | 13871547 | PRJNA533623_P_NODE_1591_length_1610_cov_3.302130_g1002_i0 | PRJNA533623 | 1591 | 1610 | 3.30213 | 53.164293 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 543 | 6.719999999999999e-185 | NR | XP_013755727.1 | 461836 | g1002 | i0 | 59.7 | 0.860869565217391 | 462 | 183 | 85.5 | 1 | 1 | 1377 | 19 | 480 | XP_013755727.1 heat shock protein 70 [Thecamonas trahens ATCC 50062] | diamond | 1386 | 543 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28025378 | 28025378 | PRJNA533623_P_NODE_26305_length_448_cov_9.217054_g24536_i0 | PRJNA533623 | 26305 | 448 | 9.217054 | 41.29240192 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 123 | 1.6e-30 | NR | XP_013761272.1 | 461836 | g24536 | i0 | 49.2 | 1.68080357142857 | 118 | 59 | 78.3 | 1 | 93 | 443 | 19 | 136 | XP_013761272.1 tumor susceptibility 101 [Thecamonas trahens ATCC 50062] | diamond | 753 | 123 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29004550 | 29004550 | PRJNA533623_P_NODE_10288_length_731_cov_18.535821_g8723_i0 | PRJNA533623 | 10288 | 731 | 18.535821 | 135.49685151 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 134 | 8.979999999999998e-32 | NR | XP_013756151.1 | 461836 | g8723 | i0 | 40.9 | 0.853625170998632 | 208 | 112 | 85 | 2 | 20 | 640 | 981 | 1178 | XP_013756151.1 tetratricopeptide repeat domain 18 [Thecamonas trahens ATCC 50062] | diamond | 624 | 134 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29098876 | 29098876 | PRJNA533623_P_NODE_14288_length_623_cov_8.361210_g12601_i0 | PRJNA533623 | 14288 | 623 | 8.36121 | 52.0903383 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.5 | 9.7e-7 | NR | XP_013762411.1 | 461836 | g12601 | i0 | 36.9 | 0.587479935794542 | 122 | 71 | 56.3 | 3 | 34 | 384 | 815 | 935 | XP_013762411.1 uncharacterized protein AMSG_00680 [Thecamonas trahens ATCC 50062] | diamond | 366 | 60.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30409022 | 30409022 | PRJNA533623_P_NODE_31573_length_401_cov_6.770588_g29802_i0 | PRJNA533623 | 31573 | 401 | 6.770588 | 27.15005788 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 2.39e-27 | NR | XP_013762760.1 | 461836 | g29802 | i0 | 58 | 7.66084788029925 | 100 | 40 | 74.8 | 1 | 56 | 355 | 505 | 602 | XP_013762760.1 type I inositol-3,4-bisphosphate 4-phosphatase [Thecamonas trahens ATCC 50062] | diamond | 3072 | 117 | 0.991452991452991 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30930907 | 30930907 | PRJNA533623_P_NODE_7234_length_861_cov_2.112500_g5841_i0 | PRJNA533623 | 7234 | 861 | 2.1125 | 18.188625 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 62.4 | 2.62e-7 | NR | XP_013755466.1 | 461836 | g5841 | i0 | 37.1 | 0.24390243902439 | 70 | 41 | 24.4 | 1 | 221 | 12 | 117 | 183 | XP_013755466.1 uncharacterized protein AMSG_08401 [Thecamonas trahens ATCC 50062] | diamond | 210 | 62.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31278357 | 31278357 | PRJNA533623_P_NODE_29995_length_414_cov_7.436261_g28225_i0 | PRJNA533623 | 29995 | 414 | 7.436261 | 30.78612054 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 67 | 8.04e-10 | NR | XP_013758227.1 | 461836 | g28225 | i0 | 36.2 | 1.5 | 105 | 63 | 76.1 | 1 | 27 | 341 | 711 | 811 | XP_013758227.1 uncharacterized protein AMSG_11848 [Thecamonas trahens ATCC 50062] | diamond | 621 | 67 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31974334 | 31974334 | PRJNA533623_P_NODE_1918_length_1500_cov_19.105629_g1239_i0 | PRJNA533623 | 1918 | 1500 | 19.105629 | 286.584435 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 84.7 | 5.42e-13 | NR | XP_013752810.1 | 461836 | g1239 | i0 | 29.2 | 0.576 | 288 | 179 | 54.2 | 9 | 452 | 1264 | 891 | 1170 | XP_013752810.1 glycosyl transferase group 1 [Thecamonas trahens ATCC 50062] | diamond | 864 | 84.7 | 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);;