contig_metadata
11 rows where bioproject = "PRJNA924320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2174567 | 2174567 | PRJNA924320_S_NODE_39742_length_178_cov_1.023256_g39600_i0 | PRJNA924320 | 39742 | 178 | 1.023256 | 1.82139568 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 171 | 3.98e-38 | NTclustered | gi|923125065|ref|XM_013900547.1| | 461836 | g39600 | i0 | 84.181 | 26.5280898876404 | 177 | 26 | 99 | 2 | 3 | 178 | 340 | 165 | Thecamonas trahens ATCC 50062 60S ribosomal protein L3 (AMSG_07514), mRNA | blastn | 4722 | 171 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 7630273 | 7630273 | PRJNA924320_S_NODE_29926_length_199_cov_1.020000_g29784_i0 | PRJNA924320 | 29926 | 199 | 1.02 | 2.0298 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 70.1 | 4.69e-12 | NR | XP_013759092.1 | 461836 | g29784 | i0 | 43.9 | 2.98492462311558 | 66 | 30 | 99.5 | 1 | 199 | 2 | 50 | 108 | XP_013759092.1 succinyl-diaminopimelate desuccinylase [Thecamonas trahens ATCC 50062] | diamond | 594 | 70.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30814531 | 30814531 | PRJNA924320_S_NODE_10394_length_305_cov_1.343750_g10252_i0 | PRJNA924320 | 10394 | 305 | 1.34375 | 4.0984375 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 118 | 5.46e-29 | NR | XP_013757530.1 | 461836 | g10252 | i0 | 55.7 | 2.88196721311475 | 97 | 43 | 95.4 | 0 | 15 | 305 | 134 | 230 | XP_013757530.1 AGC protein kinase [Thecamonas trahens ATCC 50062] | diamond | 879 | 118 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30814535 | 30814535 | PRJNA924320_S_NODE_12954_length_276_cov_2.418502_g12812_i0 | PRJNA924320 | 12954 | 276 | 2.418502 | 6.67506552 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 49.3 | 2.8e-4 | NR | XP_013755018.1 | 461836 | g12812 | i0 | 26.6 | 0.858695652173913 | 79 | 56 | 85.9 | 1 | 29 | 265 | 1587 | 1663 | XP_013755018.1 uncharacterized protein AMSG_12232 [Thecamonas trahens ATCC 50062] | diamond | 237 | 49.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31604980 | 31604980 | PRJNA924320_S_NODE_2576_length_576_cov_1.855787_g2443_i0 | PRJNA924320 | 2576 | 576 | 1.855787 | 10.68933312 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 164 | 1.19e-44 | NR | XP_013759428.1 | 461836 | g2443 | i0 | 44.9 | 0.916666666666667 | 176 | 94 | 90.6 | 2 | 523 | 2 | 14 | 188 | XP_013759428.1 succinyl-diaminopimelate desuccinylase [Thecamonas trahens ATCC 50062] | diamond | 528 | 164 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31952780 | 31952780 | PRJNA924320_S_NODE_31797_length_194_cov_1.758621_g31655_i0 | PRJNA924320 | 31797 | 194 | 1.758621 | 3.41172474 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 65.9 | 1.37e-10 | NR | XP_013754247.1 | 461836 | g31655 | i0 | 37.5 | 0.989690721649485 | 64 | 40 | 99 | 0 | 3 | 194 | 496 | 559 | XP_013754247.1 coatomer protein complex [Thecamonas trahens ATCC 50062] | diamond | 192 | 65.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32016098 | 32016098 | PRJNA924320_S_NODE_1238_length_804_cov_18.796026_g1141_i0 | PRJNA924320 | 1238 | 804 | 18.796026 | 151.12004904 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 87.4 | 1.7e-15 | NR | XP_013758183.1 | 461836 | g1141 | i0 | 31.4 | 0.843283582089552 | 226 | 129 | 83.6 | 4 | 721 | 50 | 150 | 351 | XP_013758183.1 cystatin-A2 [Thecamonas trahens ATCC 50062] | diamond | 678 | 87.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32086685 | 32086685 | PRJNA924320_S_NODE_35438_length_186_cov_2.226277_g35296_i0 | PRJNA924320 | 35438 | 186 | 2.226277 | 4.14087522 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 41.2 | 0.0351 | NR | XP_013758370.1 | 461836 | g35296 | i0 | 43.1 | 2.01612903225806 | 51 | 25 | 82.3 | 1 | 182 | 30 | 95 | 141 | XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062] | diamond | 375 | 41.6 | 0.990384615384615 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32269455 | 32269455 | PRJNA924320_S_NODE_1498_length_736_cov_3.323144_g1389_i0 | PRJNA924320 | 1498 | 736 | 3.323144 | 24.45833984 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 193 | 8.69e-58 | NR | XP_013762487.1 | 461836 | g1389 | i0 | 45.1 | 4.69565217391304 | 237 | 115 | 96.2 | 5 | 11 | 718 | 9 | 231 | XP_013762487.1 countin-1 [Thecamonas trahens ATCC 50062] | diamond | 3456 | 193 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32395938 | 32395938 | PRJNA924320_S_NODE_37199_length_183_cov_1.037313_g37057_i0 | PRJNA924320 | 37199 | 183 | 1.037313 | 1.89828279 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 69.3 | 6.78e-12 | NR | XP_013757797.1 | 461836 | g37057 | i0 | 53.4 | 1.88524590163934 | 58 | 26 | 95.1 | 1 | 8 | 181 | 152 | 208 | XP_013757797.1 beta-lactamase [Thecamonas trahens ATCC 50062] | diamond | 345 | 69.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32711486 | 32711486 | PRJNA924320_S_NODE_44260_length_170_cov_0.867769_g44118_i0 | PRJNA924320 | 44260 | 170 | 0.867769 | 1.4752073 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 73.9 | 1.33e-13 | NR | XP_013757797.1 | 461836 | g44118 | i0 | 60 | 2.84117647058824 | 55 | 21 | 97.1 | 1 | 169 | 5 | 133 | 186 | XP_013757797.1 beta-lactamase [Thecamonas trahens ATCC 50062] | diamond | 483 | 73.9 | 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);;