contig_metadata
11 rows where bioproject = "PRJNA857857" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12324334 | 12324334 | PRJNA857857_P_NODE_36610_length_251_cov_0.865169_g36161_i0 | PRJNA857857 | 36610 | 251 | 0.865169 | 2.17157419 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 121 | 6.149999999999999e-23 | NTclustered | gi|923137764|ref|XM_013906893.1| | 461836 | g36161 | i0 | 79.651 | 0.685258964143426 | 172 | 31 | 68 | 4 | 65 | 234 | 7 | 176 | Thecamonas trahens ATCC 50062 40S ribosomal protein SA (AMSG_00611), partial mRNA | blastn | 172 | 121 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26959996 | 26959996 | PRJNA857857_P_NODE_14342_length_416_cov_1.189504_g13895_i0 | PRJNA857857 | 14342 | 416 | 1.189504 | 4.94833664 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 127 | 4.1399999999999997e-32 | NR | XP_013761142.1 | 461836 | g13895 | i0 | 50.7 | 0.980769230769231 | 136 | 65 | 98.1 | 1 | 8 | 415 | 202 | 335 | XP_013761142.1 pyoverdine biosynthesis regulatory [Thecamonas trahens ATCC 50062] | diamond | 408 | 127 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26960011 | 26960011 | PRJNA857857_P_NODE_8062_length_547_cov_2.318565_g7633_i0 | PRJNA857857 | 8062 | 547 | 2.318565 | 12.68255055 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 157 | 1.52e-41 | NR | XP_013759900.1 | 461836 | g7633 | i0 | 44.9 | 1.02559414990859 | 187 | 93 | 97.6 | 5 | 545 | 12 | 311 | 496 | XP_013759900.1 monooxygenase [Thecamonas trahens ATCC 50062] | diamond | 561 | 157 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29770652 | 29770652 | PRJNA857857_P_NODE_1011_length_1361_cov_1.818323_g812_i0 | PRJNA857857 | 1011 | 1361 | 1.818323 | 24.74737603 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 243 | 9.76e-71 | NR | XP_013755460.1 | 461836 | g812 | i0 | 34.9 | 1.59368111682586 | 407 | 251 | 87.3 | 8 | 174 | 1361 | 80 | 483 | XP_013755460.1 N-acylsphingosine amidohydrolase [Thecamonas trahens ATCC 50062] | diamond | 2169 | 243 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30403087 | 30403087 | PRJNA857857_P_NODE_7213_length_578_cov_3.007921_g6785_i0 | PRJNA857857 | 7213 | 578 | 3.007921 | 17.38578338 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 77.4 | 6.92e-14 | NR | XP_013754042.1 | 461836 | g6785 | i0 | 39.1 | 0.690311418685121 | 133 | 76 | 68 | 3 | 567 | 175 | 7 | 136 | XP_013754042.1 uncharacterized protein AMSG_09689 [Thecamonas trahens ATCC 50062] | diamond | 399 | 77.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30528929 | 30528929 | PRJNA857857_P_NODE_28793_length_288_cov_1.223256_g28344_i0 | PRJNA857857 | 28793 | 288 | 1.223256 | 3.52297728 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 89 | 3.6e-18 | NR | XP_013753350.1 | 461836 | g28344 | i0 | 46.7 | 1.91666666666667 | 92 | 47 | 95.8 | 2 | 277 | 2 | 51 | 140 | XP_013753350.1 gill-specific calpain [Thecamonas trahens ATCC 50062] | diamond | 552 | 89 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30695105 | 30695105 | PRJNA857857_P_NODE_4313_length_744_cov_1.779434_g3922_i0 | PRJNA857857 | 4313 | 744 | 1.779434 | 13.23898896 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 5.779999999999998e-38 | NR | XP_013759386.1 | 461836 | g3922 | i0 | 38 | 3.14112903225806 | 234 | 130 | 88.7 | 3 | 67 | 726 | 140 | 372 | XP_013759386.1 peptidase M28 [Thecamonas trahens ATCC 50062] | diamond | 2337 | 150 | 0.993333333333333 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31413942 | 31413942 | PRJNA857857_P_NODE_11296_length_468_cov_1.106329_g10856_i0 | PRJNA857857 | 11296 | 468 | 1.106329 | 5.17761972 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 62 | 8.06e-8 | NR | XP_013757418.1 | 461836 | g10856 | i0 | 33.3 | 0.826923076923077 | 129 | 74 | 81.4 | 3 | 455 | 75 | 1236 | 1354 | XP_013757418.1 uncharacterized protein AMSG_06249 [Thecamonas trahens ATCC 50062] | diamond | 387 | 62 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31793233 | 31793233 | PRJNA857857_P_NODE_22577_length_329_cov_1.175781_g22128_i0 | PRJNA857857 | 22577 | 329 | 1.175781 | 3.86831949 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 109 | 1.7e-25 | NR | XP_013758779.1 | 461836 | g22128 | i0 | 45.4 | 0.984802431610942 | 108 | 59 | 98.5 | 0 | 326 | 3 | 58 | 165 | XP_013758779.1 uncharacterized protein AMSG_04439 [Thecamonas trahens ATCC 50062] | diamond | 324 | 109 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31920046 | 31920046 | PRJNA857857_P_NODE_9197_length_515_cov_1.287330_g8766_i0 | PRJNA857857 | 9197 | 515 | 1.28733 | 6.6297495 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 55.5 | 2.07e-5 | NR | XP_013754710.1 | 461836 | g8766 | i0 | 30.1 | 1.30485436893204 | 113 | 64 | 60.6 | 5 | 203 | 514 | 542 | 648 | XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062] | diamond | 672 | 55.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32489720 | 32489720 | PRJNA857857_P_NODE_30779_length_278_cov_1.136585_g30330_i0 | PRJNA857857 | 30779 | 278 | 1.136585 | 3.1597063 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 66.6 | 2.35e-10 | NR | XP_013752810.1 | 461836 | g30330 | i0 | 41 | 0.841726618705036 | 78 | 45 | 84.2 | 1 | 259 | 26 | 3436 | 3512 | XP_013752810.1 glycosyl transferase group 1 [Thecamonas trahens ATCC 50062] | diamond | 234 | 66.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);;