contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26828685 | 26828685 | PRJNA670521_P_NODE_79741_length_247_cov_0.885057_g78996_i0 | PRJNA670521 | 79741 | 247 | 0.885057 | 2.18609079 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 61.6 | 9.1e-9 | NR | XP_013757752.1 | 461836 | g78996 | i0 | 61.9 | 1.53036437246964 | 42 | 16 | 51 | 0 | 126 | 1 | 2235 | 2276 | XP_013757752.1 ubiquitin carboxyl-terminal hydrolase 34 [Thecamonas trahens ATCC 50062] | diamond | 378 | 61.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27461053 | 27461053 | PRJNA670521_P_NODE_68363_length_254_cov_2.320442_g67618_i0 | PRJNA670521 | 68363 | 254 | 2.320442 | 5.89392268 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 98.6 | 9.95e-22 | NR | XP_013754144.1 | 461836 | g67618 | i0 | 54.4 | 1.77165354330709 | 79 | 30 | 86.2 | 1 | 237 | 19 | 2099 | 2177 | XP_013754144.1 ubiquitin carboxyl-terminal hydrolase 34 [Thecamonas trahens ATCC 50062] | diamond | 450 | 98.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27682284 | 27682284 | PRJNA670521_P_NODE_44984_length_309_cov_1.275424_g44239_i0 | PRJNA670521 | 44984 | 309 | 1.275424 | 3.94106016 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 57.8 | 5.36e-8 | NR | XP_013761346.1 | 461836 | g44239 | i0 | 38.2 | 0.864077669902913 | 89 | 49 | 82.5 | 3 | 309 | 55 | 35 | 121 | XP_013761346.1 uncharacterized protein AMSG_01836 [Thecamonas trahens ATCC 50062] | diamond | 267 | 57.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27776799 | 27776799 | PRJNA670521_P_NODE_19684_length_424_cov_1.695157_g18941_i0 | PRJNA670521 | 19684 | 424 | 1.695157 | 7.18746568 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 115 | 4.9000000000000005e-27 | NR | XP_013759182.1 | 461836 | g18941 | i0 | 46.1 | 0.997641509433962 | 141 | 73 | 99.8 | 2 | 423 | 1 | 231 | 368 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 423 | 115 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27839611 | 27839611 | PRJNA670521_P_NODE_51284_length_293_cov_0.831818_g50539_i0 | PRJNA670521 | 51284 | 293 | 0.831818 | 2.43722674 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 65.5 | 6.93e-10 | NR | XP_013753394.1 | 461836 | g50539 | i0 | 34.3 | 0.716723549488055 | 70 | 46 | 71.7 | 0 | 213 | 4 | 97 | 166 | XP_013753394.1 phosphatidylinositol-4-phosphate 5-kinase [Thecamonas trahens ATCC 50062] | diamond | 210 | 65.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27871281 | 27871281 | PRJNA670521_P_NODE_1965_length_1236_cov_3.588134_g1537_i0 | PRJNA670521 | 1965 | 1236 | 3.588134 | 44.34933624 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.8 | 1.01e-5 | NR | XP_013757898.1 | 461836 | g1537 | i0 | 31.4 | 0.339805825242718 | 140 | 85 | 34 | 5 | 487 | 68 | 3067 | 3195 | XP_013757898.1 uncharacterized protein AMSG_05495 [Thecamonas trahens ATCC 50062] | diamond | 420 | 60.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29051796 | 29051796 | PRJNA670521_P_NODE_48928_length_298_cov_2.120000_g48183_i0 | PRJNA670521 | 48928 | 298 | 2.12 | 6.3176 | root | 1 | Root_unresolved | Root_unresolved | 99.4 | 5.02e-22 | NR | XP_013755367.1 | 461836 | g48183 | i0 | 51.5 | 2.92953020134228 | 97 | 46 | 97.7 | 1 | 3 | 293 | 309 | 404 | XP_013755367.1 uncharacterized protein AMSG_12124 [Thecamonas trahens ATCC 50062] | diamond | 873 | 100 | 0.994 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29481309 | 29481309 | PRJNA670521_P_NODE_40510_length_322_cov_1.192771_g39765_i0 | PRJNA670521 | 40510 | 322 | 1.192771 | 3.84072262 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 47.8 | 0.00122 | NR | XP_013759989.1 | 461836 | g39765 | i0 | 46.4 | 0.642857142857143 | 69 | 37 | 64.3 | 0 | 112 | 318 | 131 | 199 | XP_013759989.1 uncharacterized protein AMSG_03648 [Thecamonas trahens ATCC 50062] | diamond | 207 | 47.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29513069 | 29513069 | PRJNA670521_P_NODE_54130_length_286_cov_1.220657_g53385_i0 | PRJNA670521 | 54130 | 286 | 1.220657 | 3.49107902 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 66.6 | 4.31e-11 | NR | XP_013756644.1 | 461836 | g53385 | i0 | 48.2 | 0.891608391608392 | 85 | 36 | 80.8 | 3 | 25 | 255 | 1 | 85 | XP_013756644.1 cortactin isoform F [Thecamonas trahens ATCC 50062] | diamond | 255 | 66.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30176352 | 30176352 | PRJNA670521_P_NODE_11172_length_537_cov_1.948276_g10437_i0 | PRJNA670521 | 11172 | 537 | 1.948276 | 10.46224212 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 145 | 2.71e-37 | NR | XP_013759182.1 | 461836 | g10437 | i0 | 47.9 | 0.932960893854749 | 167 | 84 | 93.3 | 2 | 535 | 35 | 259 | 422 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 501 | 145 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30283650 | 30283650 | PRJNA670521_P_NODE_34052_length_344_cov_1.118081_g33307_i0 | PRJNA670521 | 34052 | 344 | 1.118081 | 3.84619864 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99 | 1e-22 | NR | XP_013761382.1 | 461836 | g33307 | i0 | 44.8 | 1.90988372093023 | 105 | 58 | 91.6 | 0 | 317 | 3 | 45 | 149 | XP_013761382.1 derlin-1 [Thecamonas trahens ATCC 50062] | diamond | 657 | 100 | 0.99 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31345696 | 31345696 | PRJNA670521_P_NODE_10456_length_555_cov_1.398340_g9723_i0 | PRJNA670521 | 10456 | 555 | 1.39834 | 7.760787 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 112 | 2.72e-25 | NR | XP_013759182.1 | 461836 | g9723 | i0 | 41.6 | 0.87027027027027 | 161 | 90 | 87 | 3 | 72 | 554 | 120 | 276 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 483 | 112 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32041629 | 32041629 | PRJNA670521_P_NODE_81478_length_246_cov_0.890173_g80733_i0 | PRJNA670521 | 81478 | 246 | 0.890173 | 2.18982558 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 42.7 | 0.0394 | NR | XP_013755855.1 | 461836 | g80733 | i0 | 35 | 0.975609756097561 | 80 | 52 | 97.6 | 0 | 242 | 3 | 828 | 907 | XP_013755855.1 myosin VIIA [Thecamonas trahens ATCC 50062] | diamond | 240 | 42.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32306978 | 32306978 | PRJNA670521_P_NODE_31799_length_352_cov_3.634409_g31054_i0 | PRJNA670521 | 31799 | 352 | 3.634409 | 12.79311968 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 6.23e-35 | NR | XP_013762434.1 | 461836 | g31054 | i0 | 56.1 | 14.5653409090909 | 114 | 45 | 97.2 | 2 | 10 | 351 | 19 | 127 | XP_013762434.1 60S ribosomal protein L20 [Thecamonas trahens ATCC 50062] | diamond | 5127 | 130 | 0.992307692307692 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32642051 | 32642051 | PRJNA670521_P_NODE_11400_length_532_cov_6.627451_g10665_i0 | PRJNA670521 | 11400 | 532 | 6.627451 | 35.25803932 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 46.6 | 0.0256 | NR | XP_013762491.1 | 461836 | g10665 | i0 | 25.6 | 1.61842105263158 | 125 | 85 | 66 | 3 | 361 | 11 | 563 | 687 | XP_013762491.1 saposin A [Thecamonas trahens ATCC 50062] | diamond | 861 | 46.6 | 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);;