contig_metadata
12 rows where bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9596969 | 9596969 | PRJNA688931_P_NODE_18168_length_241_cov_0.911458_g17955_i0 | PRJNA688931 | 18168 | 241 | 0.911458 | 2.19661378 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 60.2 | 1.3e-4 | NTclustered | gi|923119163|ref|XM_013897602.1| | 461836 | g17955 | i0 | 94.872 | 0.70954356846473 | 39 | 1 | 16 | 1 | 35 | 72 | 883 | 921 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_10984), partial mRNA | blastn | 171 | 60.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 9596993 | 9596993 | PRJNA688931_P_NODE_21408_length_221_cov_1.784884_g21195_i0 | PRJNA688931 | 21408 | 221 | 1.784884 | 3.94459364 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 67.6 | 7e-7 | NTclustered | gi|923122360|ref|XM_013899196.1| | 461836 | g21195 | i0 | 97.436 | 9.28054298642534 | 39 | 1 | 18 | 0 | 9 | 47 | 350 | 388 | Thecamonas trahens ATCC 50062 MYB family transcription factor (AMSG_09258), mRNA | blastn | 2051 | 67.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26639114 | 26639114 | PRJNA688931_P_NODE_33981_length_172_cov_1.682927_g33768_i0 | PRJNA688931 | 33981 | 172 | 1.682927 | 2.89463444 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 50.8 | 2.03e-5 | NR | XP_013757135.1 | 461836 | g33768 | i0 | 53.8 | 0.680232558139535 | 39 | 18 | 68 | 0 | 55 | 171 | 7 | 45 | XP_013757135.1 uncharacterized protein AMSG_11978 [Thecamonas trahens ATCC 50062] | diamond | 117 | 50.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27315230 | 27315230 | PRJNA688931_P_NODE_15023_length_266_cov_2.142857_g14810_i0 | PRJNA688931 | 15023 | 266 | 2.142857 | 5.69999962 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89 | 2.83e-18 | NR | XP_013755015.1 | 461836 | g14810 | i0 | 52.9 | 1.93984962406015 | 87 | 38 | 98.1 | 1 | 264 | 4 | 2958 | 3041 | XP_013755015.1 uncharacterized protein AMSG_12229 [Thecamonas trahens ATCC 50062] | diamond | 516 | 89 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27335315 | 27335315 | PRJNA688931_P_NODE_27903_length_193_cov_1.055556_g27690_i0 | PRJNA688931 | 27903 | 193 | 1.055556 | 2.03722308 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 80.9 | 5.92e-16 | NR | XP_013760602.1 | 461836 | g27690 | i0 | 54 | 12.7305699481865 | 63 | 29 | 97.9 | 0 | 192 | 4 | 102 | 164 | XP_013760602.1 transcription factor lim1, variant [Thecamonas trahens ATCC 50062] | diamond | 2457 | 80.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27335338 | 27335338 | PRJNA688931_P_NODE_6583_length_426_cov_2.026525_g6370_i0 | PRJNA688931 | 6583 | 426 | 2.026525 | 8.6329965 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 75.1 | 6.61e-14 | NR | XP_013753129.1 | 461836 | g6370 | i0 | 39.4 | 1.30281690140845 | 99 | 59 | 69.7 | 1 | 424 | 128 | 27 | 124 | XP_013753129.1 prefoldin, alpha subunit [Thecamonas trahens ATCC 50062] | diamond | 555 | 75.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29071955 | 29071955 | PRJNA688931_P_NODE_2228_length_761_cov_12.425562_g2067_i0 | PRJNA688931 | 2228 | 761 | 12.425562 | 94.55852682 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 87 | 1.72e-15 | NR | XP_013758183.1 | 461836 | g2067 | i0 | 31 | 0.890932982917214 | 226 | 130 | 88.3 | 4 | 43 | 714 | 150 | 351 | XP_013758183.1 cystatin-A2 [Thecamonas trahens ATCC 50062] | diamond | 678 | 87 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29829522 | 29829522 | PRJNA688931_P_NODE_32151_length_178_cov_1.263566_g31938_i0 | PRJNA688931 | 32151 | 178 | 1.263566 | 2.24914748 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 57.4 | 9.71e-8 | NR | XP_013760592.1 | 461836 | g31938 | i0 | 68.2 | 1.46629213483146 | 44 | 14 | 74.2 | 0 | 134 | 3 | 30 | 73 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 261 | 57.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30903910 | 30903910 | PRJNA688931_P_NODE_8734_length_362_cov_1.581470_g8521_i0 | PRJNA688931 | 8734 | 362 | 1.58147 | 5.7249214 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 121 | 1e-29 | NR | XP_013759428.1 | 461836 | g8521 | i0 | 44.7 | 2.83425414364641 | 114 | 63 | 94.5 | 0 | 342 | 1 | 22 | 135 | XP_013759428.1 succinyl-diaminopimelate desuccinylase [Thecamonas trahens ATCC 50062] | diamond | 1026 | 121 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31441089 | 31441089 | PRJNA688931_P_NODE_27916_length_193_cov_1.006944_g27703_i0 | PRJNA688931 | 27916 | 193 | 1.006944 | 1.94340192 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 75.9 | 3.72e-14 | NR | XP_013757530.1 | 461836 | g27703 | i0 | 53.1 | 3.97927461139896 | 64 | 30 | 99.5 | 0 | 1 | 192 | 201 | 264 | XP_013757530.1 AGC protein kinase [Thecamonas trahens ATCC 50062] | diamond | 768 | 75.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31567913 | 31567913 | PRJNA688931_P_NODE_2236_length_760_cov_12.583685_g2075_i0 | PRJNA688931 | 2236 | 760 | 12.583685 | 95.636006 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 88.6 | 4.92e-16 | NR | XP_013758183.1 | 461836 | g2075 | i0 | 31.4 | 0.892105263157895 | 226 | 129 | 88.4 | 4 | 42 | 713 | 150 | 351 | XP_013758183.1 cystatin-A2 [Thecamonas trahens ATCC 50062] | diamond | 678 | 88.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32642691 | 32642691 | PRJNA688931_P_NODE_18020_length_242_cov_1.046632_g17807_i0 | PRJNA688931 | 18020 | 242 | 1.046632 | 2.53284944 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 50.8 | 5.06e-5 | NR | XP_013759730.1 | 461836 | g17807 | i0 | 35.7 | 2.62809917355372 | 70 | 38 | 86.8 | 2 | 15 | 224 | 287 | 349 | XP_013759730.1 aaas-prov protein [Thecamonas trahens ATCC 50062] | diamond | 636 | 50.8 | 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);;