contig_metadata
6 rows where analysis = "blastn", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4466187 | 4466187 | PRJNA670521_P_NODE_63464_length_265_cov_1.385417_g62719_i0 | PRJNA670521 | 63464 | 265 | 1.385417 | 3.67135505 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 134 | 8.410000000000001e-27 | NTclustered | gi|923135694|ref|XM_013905859.1| | 461836 | g62719 | i0 | 81.437 | 26.2452830188679 | 167 | 27 | 62 | 4 | 100 | 264 | 928 | 764 | Thecamonas trahens ATCC 50062 V-type H(+)-translocating pyrophosphatase, variant (AMSG_01802), mRNA | blastn | 6955 | 134 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 9566649 | 9566649 | PRJNA670521_P_NODE_27768_length_371_cov_1.500000_g27023_i0 | PRJNA670521 | 27768 | 371 | 1.5 | 5.565 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 403 | 8.45e-108 | NTclustered | gi|923120664|ref|XM_013898350.1| | 461836 | g27023 | i0 | 86.364 | 99.6927223719677 | 374 | 45 | 100 | 6 | 1 | 371 | 1306 | 936 | Thecamonas trahens ATCC 50062 ATP-dependent RNA helicase eIF4A (AMSG_10343), partial mRNA | blastn | 36986 | 403 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12644195 | 12644195 | PRJNA670521_P_NODE_51330_length_292_cov_2.178082_g50585_i0 | PRJNA670521 | 51330 | 292 | 2.178082 | 6.35999944 | Mamiellophyceae | 1035538 | Root_unresolved | Root_unresolved | 285 | 2.45e-72 | NTclustered | gi|923120664|ref|XM_013898350.1| | 461836 | g50585 | i0 | 84.3 | 92.9897260273973 | 293 | 44 | 100 | 2 | 1 | 292 | 1196 | 905 | Thecamonas trahens ATCC 50062 ATP-dependent RNA helicase eIF4A (AMSG_10343), partial mRNA | blastn | 27153 | 287 | 0.993031358885017 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 17216023 | 17216023 | PRJNA670521_P_NODE_15574_length_467_cov_1.954315_g14832_i0 | PRJNA670521 | 15574 | 467 | 1.954315 | 9.12665105 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 383 | 1.4199999999999996e-101 | NTclustered | gi|923132712|ref|XM_013904368.1| | 461836 | g14832 | i0 | 81.739 | 17.8565310492505 | 460 | 82 | 98 | 2 | 9 | 467 | 592 | 1050 | Thecamonas trahens ATCC 50062 actin-like protein 3 (AMSG_03466), partial mRNA | blastn | 8339 | 383 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 21040573 | 21040573 | PRJNA670521_P_NODE_22677_length_401_cov_0.939024_g21934_i0 | PRJNA670521 | 22677 | 401 | 0.939024 | 3.76548624 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 62.1 | 6.39e-5 | NTclustered | gi|923122824|ref|XM_013899428.1| | 461836 | g21934 | i0 | 82.667 | 0.458852867830424 | 75 | 7 | 21 | 4 | 179 | 253 | 3136 | 3204 | Thecamonas trahens ATCC 50062 CMGC/DYRK/YAK protein kinase (AMSG_09172), mRNA | blastn | 184 | 62.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 24864442 | 24864442 | PRJNA670521_P_NODE_7520_length_647_cov_2.059233_g6802_i0 | PRJNA670521 | 7520 | 647 | 2.059233 | 13.32323751 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 488 | 4.1399999999999985e-133 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g6802 | i0 | 83.364 | 59.7604327666151 | 541 | 77 | 83 | 9 | 101 | 635 | 545 | 12 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 38665 | 488 | 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);;