contig_metadata
15 rows where bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7263589 | 7263589 | PRJNA906294_P_NODE_108626_length_390_cov_3.987382_g104511_i0 | PRJNA906294 | 108626 | 390 | 3.987382 | 15.5507898 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 176 | 2.12e-39 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g104511 | i0 | 87.5 | 3.50512820512821 | 152 | 19 | 39 | 0 | 223 | 374 | 15 | 166 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 1367 | 176 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 21287516 | 21287516 | PRJNA906294_P_NODE_113837_length_377_cov_2.901316_g109722_i0 | PRJNA906294 | 113837 | 377 | 2.901316 | 10.93796132 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 159 | 2.06e-34 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g109722 | i0 | 89.6 | 33.0848806366048 | 125 | 13 | 33 | 0 | 102 | 226 | 5178 | 5302 | Catacumbia lutetiensis strain ORSAYFEB19APU2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 12473 | 159 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 27150300 | 27150300 | PRJNA906294_P_NODE_140502_length_326_cov_1.086957_g136386_i0 | PRJNA906294 | 140502 | 326 | 1.086957 | 3.54347982 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 50.8 | 1.31e-4 | NR | XP_013752988.1 | 461836 | g136386 | i0 | 36 | 0.791411042944785 | 86 | 48 | 79.1 | 2 | 283 | 26 | 311 | 389 | XP_013752988.1 N-acylethanolamine-hydrolyzing acid amidase [Thecamonas trahens ATCC 50062] | diamond | 258 | 50.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27277322 | 27277322 | PRJNA906294_P_NODE_177223_length_278_cov_1.570732_g173107_i0 | PRJNA906294 | 177223 | 278 | 1.570732 | 4.36663496 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 59.7 | 6.23e-8 | NR | XP_013761942.1 | 461836 | g173107 | i0 | 43.2 | 1.78057553956835 | 81 | 46 | 87.4 | 0 | 10 | 252 | 830 | 910 | XP_013761942.1 MmpL efflux pump [Thecamonas trahens ATCC 50062] | diamond | 495 | 59.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28161544 | 28161544 | PRJNA906294_P_NODE_129885_length_344_cov_1.121771_g125769_i0 | PRJNA906294 | 129885 | 344 | 1.121771 | 3.85889224 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 119 | 4.2000000000000004e-30 | NR | XP_013763040.1 | 461836 | g125769 | i0 | 52.6 | 3.95058139534884 | 114 | 51 | 99.4 | 1 | 343 | 2 | 3 | 113 | XP_013763040.1 Ras-like GTP-binding protein A [Thecamonas trahens ATCC 50062] | diamond | 1359 | 119 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28918948 | 28918948 | PRJNA906294_P_NODE_121028_length_361_cov_1.496528_g116913_i0 | PRJNA906294 | 121028 | 361 | 1.496528 | 5.40246608 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 100 | 8.34e-22 | NR | XP_013758417.1 | 461836 | g116913 | i0 | 39.5 | 0.988919667590028 | 119 | 67 | 94.7 | 1 | 343 | 2 | 45 | 163 | XP_013758417.1 uncharacterized protein AMSG_04749 [Thecamonas trahens ATCC 50062] | diamond | 357 | 100 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29140359 | 29140359 | PRJNA906294_P_NODE_102329_length_408_cov_2.143284_g98214_i0 | PRJNA906294 | 102329 | 408 | 2.143284 | 8.74459872 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 53.5 | 3.61e-5 | NR | XP_013762149.1 | 461836 | g98214 | i0 | 46.4 | 0.411764705882353 | 56 | 27 | 41.2 | 1 | 151 | 318 | 85 | 137 | XP_013762149.1 uncharacterized protein AMSG_00972 [Thecamonas trahens ATCC 50062] | diamond | 168 | 53.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29487327 | 29487327 | PRJNA906294_P_NODE_86430_length_464_cov_1.976982_g82316_i0 | PRJNA906294 | 86430 | 464 | 1.976982 | 9.17319648 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 121 | 2.68e-29 | NR | XP_013755586.1 | 461836 | g82316 | i0 | 44.8 | 0.9375 | 145 | 77 | 93.1 | 2 | 445 | 14 | 189 | 331 | XP_013755586.1 pregnancy-associated glycoprotein 6 [Thecamonas trahens ATCC 50062] | diamond | 435 | 121 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30055805 | 30055805 | PRJNA906294_P_NODE_228151_length_242_cov_0.899408_g224035_i0 | PRJNA906294 | 228151 | 242 | 0.899408 | 2.17656736 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 50.4 | 7.12e-5 | NR | XP_013756038.1 | 461836 | g224035 | i0 | 31.5 | 0.90495867768595 | 73 | 50 | 90.5 | 0 | 1 | 219 | 788 | 860 | XP_013756038.1 uncharacterized protein AMSG_12074 [Thecamonas trahens ATCC 50062] | diamond | 219 | 50.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30118992 | 30118992 | PRJNA906294_P_NODE_140872_length_325_cov_1.583333_g136756_i0 | PRJNA906294 | 140872 | 325 | 1.583333 | 5.14583225 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 61.2 | 3.35e-8 | NR | XP_013757898.1 | 461836 | g136756 | i0 | 40 | 1.15384615384615 | 65 | 38 | 59.1 | 1 | 94 | 285 | 3138 | 3202 | XP_013757898.1 uncharacterized protein AMSG_05495 [Thecamonas trahens ATCC 50062] | diamond | 375 | 61.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31319822 | 31319822 | PRJNA906294_P_NODE_214175_length_247_cov_0.873563_g210059_i0 | PRJNA906294 | 214175 | 247 | 0.873563 | 2.15770061 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 73.2 | 8.05e-14 | NR | XP_013753426.1 | 461836 | g210059 | i0 | 43.9 | 0.995951417004049 | 82 | 46 | 99.6 | 0 | 246 | 1 | 48 | 129 | XP_013753426.1 uncharacterized protein AMSG_10226 [Thecamonas trahens ATCC 50062] | diamond | 246 | 73.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31636103 | 31636103 | PRJNA906294_P_NODE_133956_length_336_cov_2.794677_g129840_i0 | PRJNA906294 | 133956 | 336 | 2.794677 | 9.39011472 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 100 | 2.47e-25 | NR | XP_013758440.1 | 461836 | g129840 | i0 | 59.3 | 0.767857142857143 | 86 | 31 | 76.8 | 2 | 39 | 296 | 1 | 82 | XP_013758440.1 uncharacterized protein AMSG_04774 [Thecamonas trahens ATCC 50062] | diamond | 258 | 100 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32647877 | 32647877 | PRJNA906294_P_NODE_191020_length_264_cov_1.586387_g186904_i0 | PRJNA906294 | 191020 | 264 | 1.586387 | 4.18806168 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 97.1 | 1.03e-21 | NR | XP_013760841.1 | 461836 | g186904 | i0 | 57.1 | 0.954545454545455 | 84 | 36 | 95.5 | 0 | 262 | 11 | 34 | 117 | XP_013760841.1 deoxyguanosine kinase [Thecamonas trahens ATCC 50062] | diamond | 252 | 97.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32774061 | 32774061 | PRJNA906294_P_NODE_218360_length_245_cov_1.325581_g214244_i0 | PRJNA906294 | 218360 | 245 | 1.325581 | 3.24767345 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 74.7 | 1.97e-13 | NR | XP_013754869.1 | 461836 | g214244 | i0 | 48 | 0.918367346938776 | 75 | 35 | 91.8 | 2 | 240 | 16 | 88 | 158 | XP_013754869.1 uncharacterized protein AMSG_09154 [Thecamonas trahens ATCC 50062] | diamond | 225 | 74.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32837072 | 32837072 | PRJNA906294_P_NODE_228560_length_242_cov_0.899408_g224444_i0 | PRJNA906294 | 228560 | 242 | 0.899408 | 2.17656736 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 56.6 | 4.75e-7 | NR | XP_013754814.1 | 461836 | g224444 | i0 | 37.2 | 3.74380165289256 | 78 | 47 | 96.7 | 2 | 236 | 3 | 226 | 301 | XP_013754814.1 uncharacterized protein AMSG_09085 [Thecamonas trahens ATCC 50062] | diamond | 906 | 56.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);;