contig_metadata
15 rows where bioproject = "PRJEB75017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7787703 | 7787703 | PRJEB75017_P_NODE_14107_length_252_cov_1.407821_g13978_i0 | PRJEB75017 | 14107 | 252 | 1.407821 | 3.54770892 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 172 | 1.68e-38 | NTclustered | gi|923124038|ref|XM_013900034.1| | 461836 | g13978 | i0 | 81.308 | 17.1547619047619 | 214 | 38 | 85 | 2 | 4 | 216 | 930 | 1142 | Thecamonas trahens ATCC 50062 seryl-tRNA synthetase (AMSG_08432), mRNA | blastn | 4323 | 172 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 17986913 | 17986913 | PRJEB75017_P_NODE_14415_length_252_cov_0.871508_g14286_i0 | PRJEB75017 | 14415 | 252 | 0.871508 | 2.19620016 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 250 | 7.55e-62 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g14286 | i0 | 88.725 | 17.7103174603175 | 204 | 23 | 81 | 0 | 47 | 250 | 608 | 405 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 4463 | 250 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 17986993 | 17986993 | PRJEB75017_P_NODE_6375_length_351_cov_1.147482_g6246_i0 | PRJEB75017 | 6375 | 351 | 1.147482 | 4.02766182 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 58.5 | 7.59e-8 | NR | XP_013753243.1 | 461836 | g6246 | i0 | 32.3 | 0.794871794871795 | 93 | 63 | 79.5 | 0 | 347 | 69 | 71 | 163 | XP_013753243.1 uncharacterized protein AMSG_10809 [Thecamonas trahens ATCC 50062] | diamond | 279 | 58.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27065674 | 27065674 | PRJEB75017_P_NODE_14142_length_252_cov_1.307263_g14013_i0 | PRJEB75017 | 14142 | 252 | 1.307263 | 3.29430276 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 92.8 | 1.03e-19 | NR | XP_013754710.1 | 461836 | g14013 | i0 | 55.1 | 1.72619047619048 | 69 | 26 | 76.2 | 1 | 252 | 61 | 513 | 581 | XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062] | diamond | 435 | 92.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27192059 | 27192059 | PRJEB75017_P_NODE_7162_length_333_cov_1.946154_g7033_i0 | PRJEB75017 | 7162 | 333 | 1.946154 | 6.48069282 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 59.3 | 1.22e-7 | NR | XP_013759479.1 | 461836 | g7033 | i0 | 51.5 | 0.594594594594595 | 66 | 29 | 56.8 | 2 | 333 | 145 | 1 | 66 | XP_013759479.1 uncharacterized protein AMSG_02572 [Thecamonas trahens ATCC 50062] | diamond | 198 | 59.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27216339 | 27216339 | PRJEB75017_P_NODE_16042_length_248_cov_0.891429_g15913_i0 | PRJEB75017 | 16042 | 248 | 0.891429 | 2.21074392 | root | 1 | Root_unresolved | Root_unresolved | 131 | 2.31e-33 | NR | XP_013760858.1 | 461836 | g15913 | i0 | 73.2 | 16.8629032258065 | 82 | 22 | 99.2 | 0 | 2 | 247 | 520 | 601 | XP_013760858.1 uncharacterized protein AMSG_02312 [Thecamonas trahens ATCC 50062] | diamond | 4182 | 131 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27255330 | 27255330 | PRJEB75017_P_NODE_15243_length_250_cov_0.881356_g15114_i0 | PRJEB75017 | 15243 | 250 | 0.881356 | 2.20339 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.5 | 2.36e-8 | NR | XP_013756038.1 | 461836 | g15114 | i0 | 40.8 | 0.912 | 76 | 45 | 91.2 | 0 | 231 | 4 | 776 | 851 | XP_013756038.1 uncharacterized protein AMSG_12074 [Thecamonas trahens ATCC 50062] | diamond | 228 | 60.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28006344 | 28006344 | PRJEB75017_P_NODE_13825_length_253_cov_0.866667_g13696_i0 | PRJEB75017 | 13825 | 253 | 0.866667 | 2.19266751 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 1.58e-28 | NR | XP_013761903.1 | 461836 | g13696 | i0 | 64.3 | 5.82213438735178 | 84 | 30 | 99.6 | 0 | 252 | 1 | 340 | 423 | XP_013761903.1 long-chain acyl-CoA synthetase [Thecamonas trahens ATCC 50062] | diamond | 1473 | 117 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29086980 | 29086980 | PRJEB75017_P_NODE_16108_length_247_cov_1.747126_g15979_i0 | PRJEB75017 | 16108 | 247 | 1.747126 | 4.31540122 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 91.7 | 2.21e-19 | NR | XP_013759182.1 | 461836 | g15979 | i0 | 62.2 | 0.898785425101215 | 74 | 27 | 89.9 | 1 | 245 | 24 | 284 | 356 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 222 | 91.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30255671 | 30255671 | PRJEB75017_P_NODE_9812_length_291_cov_1.073394_g9683_i0 | PRJEB75017 | 9812 | 291 | 1.073394 | 3.12357654 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 43.9 | 0.0168 | NR | XP_013754042.1 | 461836 | g9683 | i0 | 34.9 | 1.44329896907216 | 86 | 44 | 88.7 | 4 | 2 | 259 | 90 | 163 | XP_013754042.1 uncharacterized protein AMSG_09689 [Thecamonas trahens ATCC 50062] | diamond | 420 | 43.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30627112 | 30627112 | PRJEB75017_P_NODE_1713_length_661_cov_1.256803_g1587_i0 | PRJEB75017 | 1713 | 661 | 1.256803 | 8.30746783 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 2.3000000000000003e-28 | NR | XP_013760831.1 | 461836 | g1587 | i0 | 50 | 1.72012102874433 | 124 | 54 | 56.3 | 1 | 288 | 659 | 72 | 187 | XP_013760831.1 cathepsin D1 [Thecamonas trahens ATCC 50062] | diamond | 1137 | 120 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31488101 | 31488101 | PRJEB75017_P_NODE_17876_length_243_cov_0.917647_g17747_i0 | PRJEB75017 | 17876 | 243 | 0.917647 | 2.22988221 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 76.6 | 1.87e-14 | NR | XP_013755473.1 | 461836 | g17747 | i0 | 48.7 | 0.938271604938272 | 76 | 36 | 93.8 | 1 | 14 | 241 | 187 | 259 | XP_013755473.1 uncharacterized protein AMSG_08411 [Thecamonas trahens ATCC 50062] | diamond | 228 | 76.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31551378 | 31551378 | PRJEB75017_P_NODE_7816_length_321_cov_1.258065_g7687_i0 | PRJEB75017 | 7816 | 321 | 1.258065 | 4.03838865 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 58.5 | 2.56e-7 | NR | XP_013755586.1 | 461836 | g7687 | i0 | 48.5 | 0.616822429906542 | 66 | 31 | 60.7 | 2 | 201 | 7 | 188 | 251 | XP_013755586.1 pregnancy-associated glycoprotein 6 [Thecamonas trahens ATCC 50062] | diamond | 198 | 58.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32563771 | 32563771 | PRJEB75017_P_NODE_16999_length_245_cov_1.191860_g16870_i0 | PRJEB75017 | 16999 | 245 | 1.19186 | 2.920057 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 128 | 3.92e-33 | NR | XP_013759822.1 | 461836 | g16870 | i0 | 79 | 0.991836734693878 | 81 | 17 | 99.2 | 0 | 244 | 2 | 287 | 367 | XP_013759822.1 actin-like protein 3 [Thecamonas trahens ATCC 50062] | diamond | 243 | 128 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32713720 | 32713720 | PRJEB75017_P_NODE_9600_length_293_cov_1.418182_g9471_i0 | PRJEB75017 | 9600 | 293 | 1.418182 | 4.15527326 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 3.9199999999999995e-37 | NR | XP_013760047.1 | 461836 | g9471 | i0 | 70.3 | 2.79522184300341 | 91 | 27 | 93.2 | 0 | 275 | 3 | 1 | 91 | XP_013760047.1 proteasome subunit alpha type-3 [Thecamonas trahens ATCC 50062] | diamond | 819 | 136 | 0.992647058823529 | 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);;