contig_metadata
9 rows where bioproject = "PRJNA594101", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23519530 | 23519530 | PRJNA594101_S_NODE_4299_length_777_cov_1.666193_g4029_i0 | PRJNA594101 | 4299 | 777 | 1.666193 | 12.94631961 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 56.5 | 0.006 | NTclustered | gi|923128178|ref|XM_013902102.1| | 461836 | g4029 | i0 | 100 | 0.114543114543115 | 30 | 0 | 4 | 0 | 625 | 654 | 548 | 577 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_06051), partial mRNA | blastn | 89 | 56.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27016427 | 27016427 | PRJNA594101_S_NODE_6342_length_647_cov_29.031359_g6050_i0 | PRJNA594101 | 6342 | 647 | 29.031359 | 187.83289273 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 174 | 1.06e-46 | NR | XP_013754710.1 | 461836 | g6050 | i0 | 47.9 | 0.890262751159196 | 192 | 88 | 85.3 | 6 | 38 | 589 | 475 | 662 | XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062] | diamond | 576 | 174 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27048189 | 27048189 | PRJNA594101_S_NODE_29702_length_314_cov_1.207469_g29400_i0 | PRJNA594101 | 29702 | 314 | 1.207469 | 3.79145266 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 90.1 | 1.03e-18 | NR | XP_013759982.1 | 461836 | g29400 | i0 | 54.1 | 2.65605095541401 | 85 | 30 | 77.4 | 2 | 254 | 12 | 51 | 130 | XP_013759982.1 cytochrome c peroxidase [Thecamonas trahens ATCC 50062] | diamond | 834 | 90.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28248145 | 28248145 | PRJNA594101_S_NODE_42186_length_268_cov_1.897436_g41884_i0 | PRJNA594101 | 42186 | 268 | 1.897436 | 5.08512848 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 47.4 | 8.3e-4 | NR | XP_013760521.1 | 461836 | g41884 | i0 | 67.9 | 0.313432835820896 | 28 | 8 | 30.2 | 1 | 188 | 268 | 11 | 38 | XP_013760521.1 uncharacterized protein AMSG_02675 [Thecamonas trahens ATCC 50062] | diamond | 84 | 47.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28943243 | 28943243 | PRJNA594101_S_NODE_28008_length_322_cov_0.835341_g27706_i0 | PRJNA594101 | 28008 | 322 | 0.835341 | 2.68979802 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 59.3 | 1.37e-7 | NR | XP_013755586.1 | 461836 | g27706 | i0 | 40.3 | 0.717391304347826 | 77 | 43 | 68.9 | 1 | 59 | 280 | 279 | 355 | XP_013755586.1 pregnancy-associated glycoprotein 6 [Thecamonas trahens ATCC 50062] | diamond | 231 | 59.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30553557 | 30553557 | PRJNA594101_S_NODE_45113_length_260_cov_1.545455_g44811_i0 | PRJNA594101 | 45113 | 260 | 1.545455 | 4.018183 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 94.7 | 1.72e-20 | NR | XP_013758604.1 | 461836 | g44811 | i0 | 50.6 | 1.99615384615385 | 87 | 37 | 95.8 | 3 | 259 | 11 | 282 | 366 | XP_013758604.1 histone deacetylase 1 [Thecamonas trahens ATCC 50062] | diamond | 519 | 94.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30932872 | 30932872 | PRJNA594101_S_NODE_16774_length_406_cov_1.579580_g16472_i0 | PRJNA594101 | 16774 | 406 | 1.57958 | 6.4130948 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 135 | 8.989999999999998e-35 | NR | XP_013759092.1 | 461836 | g16472 | i0 | 46.5 | 1.9064039408867 | 129 | 68 | 95.3 | 1 | 20 | 406 | 24 | 151 | XP_013759092.1 succinyl-diaminopimelate desuccinylase [Thecamonas trahens ATCC 50062] | diamond | 774 | 135 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30932914 | 30932914 | PRJNA594101_S_NODE_4474_length_762_cov_48.069666_g4202_i0 | PRJNA594101 | 4474 | 762 | 48.069666 | 366.29085492 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 87.8 | 9.5e-16 | NR | XP_013758183.1 | 461836 | g4202 | i0 | 31 | 0.889763779527559 | 226 | 130 | 88.2 | 4 | 729 | 58 | 150 | 351 | XP_013758183.1 cystatin-A2 [Thecamonas trahens ATCC 50062] | diamond | 678 | 87.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32369666 | 32369666 | PRJNA594101_S_NODE_17119_length_402_cov_1.534954_g16817_i0 | PRJNA594101 | 17119 | 402 | 1.534954 | 6.17051508 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.3 | 8.42e-18 | NR | XP_013762927.1 | 461836 | g16817 | i0 | 37.8 | 6.97761194029851 | 135 | 80 | 97.8 | 4 | 397 | 5 | 1 | 135 | XP_013762927.1 actophorin [Thecamonas trahens ATCC 50062] | diamond | 2805 | 85.1 | 0.990599294947121 | 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);;