contig_metadata
16 rows where bioproject = "PRJNA437204", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1708102 | 1708102 | PRJNA437204_P_NODE_722_length_1463_cov_3.110072_g605_i0 | PRJNA437204 | 722 | 1463 | 3.110072 | 45.50035336 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 557 | 8.419999999999998e-193 | NR | XP_013762089.1 | 461836 | g605 | i0 | 61.1 | 5.90772385509228 | 476 | 177 | 97.6 | 5 | 1429 | 2 | 12 | 479 | XP_013762089.1 inositol-3-phosphate synthase [Thecamonas trahens ATCC 50062] | diamond | 8643 | 557 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 9360143 | 9360143 | PRJNA437204_P_NODE_13808_length_474_cov_1.147132_g13509_i0 | PRJNA437204 | 13808 | 474 | 1.147132 | 5.43740568 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 145 | 5.87e-37 | NR | XP_013761942.1 | 461836 | g13509 | i0 | 50 | 0.987341772151899 | 156 | 75 | 98.7 | 1 | 473 | 6 | 714 | 866 | XP_013761942.1 MmpL efflux pump [Thecamonas trahens ATCC 50062] | diamond | 468 | 145 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 10635441 | 10635441 | PRJNA437204_P_NODE_103729_length_246_cov_0.890173_g103430_i0 | PRJNA437204 | 103729 | 246 | 0.890173 | 2.18982558 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 176 | 1.26e-39 | NTclustered | gi|923130274|ref|XM_013903149.1| | 461836 | g103430 | i0 | 88.356 | 44.719512195122 | 146 | 17 | 59 | 0 | 97 | 242 | 734 | 589 | Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA | blastn | 11001 | 176 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 15735059 | 15735059 | PRJNA437204_P_NODE_33393_length_344_cov_1.394834_g33094_i0 | PRJNA437204 | 33393 | 344 | 1.394834 | 4.79822896 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 9.86e-27 | NR | XP_013754951.1 | 461836 | g33094 | i0 | 59.1 | 2.26744186046512 | 88 | 36 | 76.7 | 0 | 340 | 77 | 2812 | 2899 | XP_013754951.1 uncharacterized protein AMSG_08995 [Thecamonas trahens ATCC 50062] | diamond | 780 | 114 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 17009865 | 17009865 | PRJNA437204_P_NODE_42634_length_317_cov_2.500000_g42335_i0 | PRJNA437204 | 42634 | 317 | 2.5 | 7.925 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 123 | 2.18e-31 | NR | XP_013760592.1 | 461836 | g42335 | i0 | 67.7 | 1.5993690851735 | 93 | 28 | 86.1 | 1 | 43 | 315 | 30 | 122 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 507 | 123 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23385804 | 23385804 | PRJNA437204_P_NODE_9519_length_549_cov_0.834034_g9221_i0 | PRJNA437204 | 9519 | 549 | 0.834034 | 4.57884666 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 318 | 4.82e-82 | NTclustered | gi|923129698|ref|XM_013902861.1| | 461836 | g9221 | i0 | 79.104 | 14.2677595628415 | 469 | 92 | 85 | 6 | 60 | 525 | 141 | 606 | Thecamonas trahens ATCC 50062 acyl-coa dehydrogenase (AMSG_04641), partial mRNA | blastn | 7833 | 318 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27170480 | 27170480 | PRJNA437204_P_NODE_24802_length_381_cov_1.000000_g24503_i0 | PRJNA437204 | 24802 | 381 | 1 | 3.81 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 96.3 | 3.01e-20 | NR | XP_013759829.1 | 461836 | g24503 | i0 | 45.2 | 1.97637795275591 | 124 | 65 | 96.9 | 3 | 2 | 370 | 273 | 394 | XP_013759829.1 uncharacterized protein AMSG_03474 [Thecamonas trahens ATCC 50062] | diamond | 753 | 96.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27328883 | 27328883 | PRJNA437204_P_NODE_26843_length_370_cov_1.814815_g26544_i0 | PRJNA437204 | 26843 | 370 | 1.814815 | 6.7148155 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 49.7 | 1.65e-4 | NR | XP_013755301.1 | 461836 | g26544 | i0 | 36.4 | 0.624324324324324 | 77 | 48 | 62.4 | 1 | 355 | 125 | 41 | 116 | XP_013755301.1 uncharacterized protein AMSG_08071 [Thecamonas trahens ATCC 50062] | diamond | 231 | 49.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27771059 | 27771059 | PRJNA437204_P_NODE_19164_length_418_cov_2.823188_g18865_i0 | PRJNA437204 | 19164 | 418 | 2.823188 | 11.80092584 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 86.7 | 1.57e-18 | NR | XP_013755301.1 | 461836 | g18865 | i0 | 38.7 | 0.889952153110048 | 124 | 74 | 87.6 | 1 | 3 | 368 | 8 | 131 | XP_013755301.1 uncharacterized protein AMSG_08071 [Thecamonas trahens ATCC 50062] | diamond | 372 | 86.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28402327 | 28402327 | PRJNA437204_P_NODE_64246_length_274_cov_1.169154_g63947_i0 | PRJNA437204 | 64246 | 274 | 1.169154 | 3.20348196 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 66.6 | 2.05e-10 | NR | XP_013760714.1 | 461836 | g63947 | i0 | 53.4 | 0.635036496350365 | 58 | 26 | 62.4 | 1 | 173 | 3 | 41 | 98 | XP_013760714.1 surfactant protein B containing protein [Thecamonas trahens ATCC 50062] | diamond | 174 | 66.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28497155 | 28497155 | PRJNA437204_P_NODE_127407_length_241_cov_0.916667_g127108_i0 | PRJNA437204 | 127407 | 241 | 0.916667 | 2.20916747 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 96.7 | 1.79e-21 | NR | XP_013752988.1 | 461836 | g127108 | i0 | 55.8 | 2.91286307053942 | 77 | 34 | 95.9 | 0 | 237 | 7 | 120 | 196 | XP_013752988.1 N-acylethanolamine-hydrolyzing acid amidase [Thecamonas trahens ATCC 50062] | diamond | 702 | 96.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28654975 | 28654975 | PRJNA437204_P_NODE_94307_length_248_cov_0.880000_g94008_i0 | PRJNA437204 | 94307 | 248 | 0.88 | 2.1824 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 47.4 | 8.67e-4 | NR | XP_013759940.1 | 461836 | g94008 | i0 | 46.2 | 0.629032258064516 | 52 | 28 | 62.9 | 0 | 17 | 172 | 231 | 282 | XP_013759940.1 uncharacterized protein AMSG_03594 [Thecamonas trahens ATCC 50062] | diamond | 156 | 47.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29317944 | 29317944 | PRJNA437204_P_NODE_9769_length_543_cov_1.380851_g9471_i0 | PRJNA437204 | 9769 | 543 | 1.380851 | 7.49802093 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 134 | 1.84e-33 | NR | XP_013755460.1 | 461836 | g9471 | i0 | 41.1 | 0.994475138121547 | 180 | 101 | 98.9 | 2 | 1 | 537 | 231 | 406 | XP_013755460.1 N-acylsphingosine amidohydrolase [Thecamonas trahens ATCC 50062] | diamond | 540 | 134 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31909201 | 31909201 | PRJNA437204_P_NODE_16817_length_440_cov_1.242507_g16518_i0 | PRJNA437204 | 16817 | 440 | 1.242507 | 5.4670308 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 62.8 | 1.24e-8 | NR | XP_013762641.1 | 461836 | g16518 | i0 | 32.9 | 0.975 | 143 | 90 | 97.5 | 2 | 11 | 439 | 95 | 231 | XP_013762641.1 glutathione S-transferase [Thecamonas trahens ATCC 50062] | diamond | 429 | 62.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32621378 | 32621378 | PRJNA437204_P_NODE_75700_length_256_cov_1.683060_g75401_i0 | PRJNA437204 | 75700 | 256 | 1.68306 | 4.3086336 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 59.3 | 5.98e-8 | NR | XP_013756459.1 | 461836 | g75401 | i0 | 45.8 | 2.80078125 | 83 | 35 | 97.3 | 2 | 6 | 254 | 313 | 385 | XP_013756459.1 phenylalanine-4-hydroxylase [Thecamonas trahens ATCC 50062] | diamond | 717 | 59.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32888326 | 32888326 | PRJNA437204_P_NODE_15780_length_450_cov_2.042440_g15481_i0 | PRJNA437204 | 15780 | 450 | 2.04244 | 9.19098 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 86.3 | 3.26e-18 | NR | XP_013755301.1 | 461836 | g15481 | i0 | 43.6 | 0.78 | 117 | 64 | 76.7 | 1 | 4 | 348 | 15 | 131 | XP_013755301.1 uncharacterized protein AMSG_08071 [Thecamonas trahens ATCC 50062] | diamond | 351 | 86.3 | 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);;