contig_metadata
15 rows where bioproject = "PRJEB10320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22965408 | 22965408 | PRJEB10320_P_NODE_2359_length_697_cov_1.782477_g2170_i0 | PRJEB10320 | 2359 | 697 | 1.782477 | 12.42386469 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 253 | 5.71e-80 | NR | XP_013760592.1 | 461836 | g2170 | i0 | 68.4 | 0.817790530846485 | 190 | 57 | 81.3 | 2 | 2 | 568 | 153 | 340 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 570 | 253 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27349050 | 27349050 | PRJEB10320_P_NODE_25403_length_162_cov_1.259843_g25145_i0 | PRJEB10320 | 25403 | 162 | 1.259843 | 2.04094566 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 82.4 | 1.23e-16 | NR | XP_013759207.1 | 461836 | g25145 | i0 | 62.7 | 0.944444444444444 | 51 | 19 | 94.4 | 0 | 2 | 154 | 155 | 205 | XP_013759207.1 glucoamylase [Thecamonas trahens ATCC 50062] | diamond | 153 | 82.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27380593 | 27380593 | PRJEB10320_P_NODE_27263_length_155_cov_0.816667_g27005_i0 | PRJEB10320 | 27263 | 155 | 0.816667 | 1.26583385 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 72 | 5.25e-13 | NR | XP_013759182.1 | 461836 | g27005 | i0 | 62 | 0.967741935483871 | 50 | 19 | 96.8 | 0 | 3 | 152 | 250 | 299 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 150 | 72 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28106509 | 28106509 | PRJEB10320_P_NODE_9605_length_318_cov_1.893993_g9347_i0 | PRJEB10320 | 9605 | 318 | 1.893993 | 6.02289774 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 50.1 | 1.8e-4 | NR | XP_013755466.1 | 461836 | g9347 | i0 | 26.9 | 1.0188679245283 | 108 | 69 | 94.3 | 3 | 6 | 305 | 70 | 175 | XP_013755466.1 uncharacterized protein AMSG_08401 [Thecamonas trahens ATCC 50062] | diamond | 324 | 50.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28454094 | 28454094 | PRJEB10320_P_NODE_16086_length_224_cov_2.068783_g15828_i0 | PRJEB10320 | 16086 | 224 | 2.068783 | 4.63407392 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 52.4 | 1.13e-5 | NR | XP_013754947.1 | 461836 | g15828 | i0 | 51.1 | 1.28571428571429 | 47 | 22 | 61.6 | 1 | 87 | 224 | 68 | 114 | XP_013754947.1 AGC/PKA protein kinase [Thecamonas trahens ATCC 50062] | diamond | 288 | 52.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29463896 | 29463896 | PRJEB10320_P_NODE_6430_length_410_cov_1.880000_g6176_i0 | PRJEB10320 | 6430 | 410 | 1.88 | 7.708 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 47 | 0.00786 | NR | XP_013757898.1 | 461836 | g6176 | i0 | 39.5 | 0.314634146341463 | 43 | 26 | 31.5 | 0 | 23 | 151 | 3135 | 3177 | XP_013757898.1 uncharacterized protein AMSG_05495 [Thecamonas trahens ATCC 50062] | diamond | 129 | 47 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29558927 | 29558927 | PRJEB10320_P_NODE_28390_length_151_cov_1.034483_g28132_i0 | PRJEB10320 | 28390 | 151 | 1.034483 | 1.56206933 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 56.6 | 1.29e-7 | NR | XP_013763036.1 | 461836 | g28132 | i0 | 61.7 | 0.933774834437086 | 47 | 17 | 93.4 | 1 | 3 | 143 | 401 | 446 | XP_013763036.1 tripeptidyl peptidase [Thecamonas trahens ATCC 50062] | diamond | 141 | 56.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30254181 | 30254181 | PRJEB10320_P_NODE_26072_length_159_cov_1.540323_g25814_i0 | PRJEB10320 | 26072 | 159 | 1.540323 | 2.44911357 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 82.4 | 7.84e-17 | NR | XP_013758005.1 | 461836 | g25814 | i0 | 76.6 | 0.886792452830189 | 47 | 11 | 88.7 | 0 | 19 | 159 | 55 | 101 | XP_013758005.1 uncharacterized protein AMSG_05289 [Thecamonas trahens ATCC 50062] | diamond | 141 | 82.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30632868 | 30632868 | PRJEB10320_P_NODE_26373_length_158_cov_1.300813_g26115_i0 | PRJEB10320 | 26373 | 158 | 1.300813 | 2.05528454 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 49.7 | 4.11e-5 | NR | XP_013761142.1 | 461836 | g26115 | i0 | 44.2 | 0.987341772151899 | 52 | 29 | 98.7 | 0 | 1 | 156 | 213 | 264 | XP_013761142.1 pyoverdine biosynthesis regulatory [Thecamonas trahens ATCC 50062] | diamond | 156 | 49.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30759503 | 30759503 | PRJEB10320_P_NODE_24034_length_168_cov_2.180451_g23776_i0 | PRJEB10320 | 24034 | 168 | 2.180451 | 3.66315768 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.8 | 5.39e-9 | NR | XP_013762398.1 | 461836 | g23776 | i0 | 61.9 | 1.625 | 42 | 16 | 75 | 0 | 128 | 3 | 558 | 599 | XP_013762398.1 uncharacterized protein AMSG_00666 [Thecamonas trahens ATCC 50062] | diamond | 273 | 60.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30791033 | 30791033 | PRJEB10320_P_NODE_28694_length_150_cov_1.043478_g28436_i0 | PRJEB10320 | 28694 | 150 | 1.043478 | 1.565217 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 58.9 | 2.07e-8 | NR | XP_013755589.1 | 461836 | g28436 | i0 | 50 | 1 | 50 | 24 | 98 | 1 | 150 | 4 | 469 | 518 | XP_013755589.1 phospholipase B domain containing 2 isoform 2 [Thecamonas trahens ATCC 50062] | diamond | 150 | 58.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31391704 | 31391704 | PRJEB10320_P_NODE_2036_length_747_cov_2.891854_g1857_i0 | PRJEB10320 | 2036 | 747 | 2.891854 | 21.60214938 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 193 | 9.630000000000001e-58 | NR | XP_013762487.1 | 461836 | g1857 | i0 | 45.1 | 4.6425702811245 | 237 | 115 | 94.8 | 5 | 731 | 24 | 9 | 231 | XP_013762487.1 countin-1 [Thecamonas trahens ATCC 50062] | diamond | 3468 | 193 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31423149 | 31423149 | PRJEB10320_P_NODE_23896_length_169_cov_1.492537_g23638_i0 | PRJEB10320 | 23896 | 169 | 1.492537 | 2.52238753 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 95.9 | 8.829999999999999e-23 | NR | XP_013757057.1 | 461836 | g23638 | i0 | 74.5 | 0.905325443786982 | 51 | 13 | 90.5 | 0 | 162 | 10 | 168 | 218 | XP_013757057.1 lysozyme [Thecamonas trahens ATCC 50062] | diamond | 153 | 95.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31486648 | 31486648 | PRJEB10320_P_NODE_12056_length_274_cov_1.673640_g11798_i0 | PRJEB10320 | 12056 | 274 | 1.67364 | 4.5857736 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 51.2 | 4.76e-5 | NR | XP_013759479.1 | 461836 | g11798 | i0 | 47.6 | 1.41240875912409 | 63 | 30 | 65.7 | 2 | 9 | 188 | 1 | 63 | XP_013759479.1 uncharacterized protein AMSG_02572 [Thecamonas trahens ATCC 50062] | diamond | 387 | 51.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32845450 | 32845450 | PRJEB10320_P_NODE_13480_length_254_cov_2.187215_g13222_i0 | PRJEB10320 | 13480 | 254 | 2.187215 | 5.5555261 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 54.7 | 2.44e-6 | NR | XP_013760592.1 | 461836 | g13222 | i0 | 65 | 0.47244094488189 | 40 | 14 | 47.2 | 0 | 2 | 121 | 300 | 339 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 120 | 54.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);;