contig_metadata
9 rows where bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14972337 | 14972337 | PRJNA971593_P_NODE_4572_length_566_cov_2.336714_g4426_i0 | PRJNA971593 | 4572 | 566 | 2.336714 | 13.22580124 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 405 | 3.72e-108 | NTclustered | gi|923124493|ref|XM_013900261.1| | 461836 | g4426 | i0 | 90.554 | 177.743816254417 | 307 | 27 | 54 | 2 | 2 | 307 | 151 | 456 | Thecamonas trahens ATCC 50062 ubiquitin C (AMSG_07946), partial mRNA | blastn | 100603 | 405 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 16247117 | 16247117 | PRJNA971593_P_NODE_23413_length_249_cov_1.312500_g23264_i0 | PRJNA971593 | 23413 | 249 | 1.3125 | 3.268125 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 134 | 7.82e-27 | NTclustered | gi|923128656|ref|XM_013902341.1| | 461836 | g23264 | i0 | 76.587 | 1.36144578313253 | 252 | 53 | 100 | 6 | 1 | 249 | 373 | 621 | Thecamonas trahens ATCC 50062 actin-like protein 2 (AMSG_05368), mRNA | blastn | 339 | 134 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 20070960 | 20070960 | PRJNA971593_P_NODE_2436_length_762_cov_6.223512_g2302_i0 | PRJNA971593 | 2436 | 762 | 6.223512 | 47.42316144 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 158 | 1.57e-33 | NTclustered | gi|923132316|ref|XM_013904170.1| | 461836 | g2302 | i0 | 84.375 | 1.66404199475066 | 160 | 25 | 21 | 0 | 559 | 718 | 190 | 31 | Thecamonas trahens ATCC 50062 50S ribosomal protein L37a (AMSG_03714), partial mRNA | blastn | 1268 | 158 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26931048 | 26931048 | PRJNA971593_P_NODE_1802_length_872_cov_2.833542_g1681_i0 | PRJNA971593 | 1802 | 872 | 2.833542 | 24.70848624 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 258 | 5.47e-81 | NR | XP_013753886.1 | 461836 | g1681 | i0 | 47.3 | 1.0045871559633 | 292 | 140 | 97 | 8 | 27 | 872 | 5 | 292 | XP_013753886.1 cysteine proteinase 1 [Thecamonas trahens ATCC 50062] | diamond | 876 | 258 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27405395 | 27405395 | PRJNA971593_P_NODE_23243_length_250_cov_0.870056_g23094_i0 | PRJNA971593 | 23243 | 250 | 0.870056 | 2.17514 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 103 | 2.2699999999999994e-23 | NR | XP_013758219.1 | 461836 | g23094 | i0 | 69.2 | 0.936 | 78 | 23 | 92.4 | 1 | 231 | 1 | 1759 | 1836 | XP_013758219.1 uncharacterized protein AMSG_11840 [Thecamonas trahens ATCC 50062] | diamond | 234 | 103 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27910086 | 27910086 | PRJNA971593_P_NODE_10585_length_372_cov_1.043478_g10436_i0 | PRJNA971593 | 10585 | 372 | 1.043478 | 3.88173816 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 43.5 | 0.0134 | NR | XP_013757921.1 | 461836 | g10436 | i0 | 38.9 | 0.435483870967742 | 54 | 33 | 43.5 | 0 | 372 | 211 | 32 | 85 | XP_013757921.1 uncharacterized protein AMSG_11880 [Thecamonas trahens ATCC 50062] | diamond | 162 | 43.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29931376 | 29931376 | PRJNA971593_P_NODE_3511_length_645_cov_1.211538_g3367_i0 | PRJNA971593 | 3511 | 645 | 1.211538 | 7.8144201 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 163 | 4.4799999999999984e-43 | NR | XP_013759408.1 | 461836 | g3367 | i0 | 38.8 | 0.995348837209302 | 214 | 128 | 99.5 | 2 | 3 | 644 | 144 | 354 | XP_013759408.1 stress protein [Thecamonas trahens ATCC 50062] | diamond | 642 | 163 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31359562 | 31359562 | PRJNA971593_P_NODE_22576_length_250_cov_2.067797_g22427_i0 | PRJNA971593 | 22576 | 250 | 2.067797 | 5.1694925 | root | 1 | Root_unresolved | Root_unresolved | 89 | 2.23e-18 | NR | XP_013762274.1 | 461836 | g22427 | i0 | 55.6 | 4.932 | 81 | 35 | 97.2 | 1 | 249 | 7 | 522 | 601 | XP_013762274.1 uncharacterized protein AMSG_01102 [Thecamonas trahens ATCC 50062] | diamond | 1233 | 89 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31922468 | 31922468 | PRJNA971593_P_NODE_25837_length_246_cov_0.890173_g25688_i0 | PRJNA971593 | 25837 | 246 | 0.890173 | 2.18982558 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 74.3 | 2.85e-13 | NR | XP_013758095.1 | 461836 | g25688 | i0 | 57.7 | 2.13414634146341 | 52 | 18 | 63.4 | 1 | 242 | 87 | 478 | 525 | XP_013758095.1 IBR domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 525 | 74.3 | 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);;