contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2727232 | 2727232 | PRJNA1059246_P_NODE_13163_length_651_cov_2.776817_g12579_i0 | PRJNA1059246 | 13163 | 651 | 2.776817 | 18.07707867 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 494 | 8.95e-135 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g12579 | i0 | 83.549 | 54.7450076804916 | 541 | 76 | 82 | 9 | 116 | 650 | 545 | 12 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 35639 | 494 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 2727406 | 2727406 | PRJNA1059246_P_NODE_25203_length_445_cov_1.448925_g24578_i0 | PRJNA1059246 | 25203 | 445 | 1.448925 | 6.44771625 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 294 | 6.48e-75 | NTclustered | gi|923132712|ref|XM_013904368.1| | 461836 | g24578 | i0 | 80 | 14.6988764044944 | 405 | 75 | 90 | 6 | 42 | 443 | 1095 | 694 | Thecamonas trahens ATCC 50062 actin-like protein 3 (AMSG_03466), partial mRNA | blastn | 6541 | 294 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5279796 | 5279796 | PRJNA1059246_P_NODE_36705_length_355_cov_1.088652_g36079_i0 | PRJNA1059246 | 36705 | 355 | 1.088652 | 3.8647146 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 213 | 1.46e-50 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g36079 | i0 | 77.841 | 0.991549295774648 | 352 | 72 | 98 | 6 | 7 | 355 | 1196 | 848 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 352 | 213 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8664591 | 8664591 | PRJNA1059246_P_NODE_25987_length_436_cov_2.845730_g25362_i0 | PRJNA1059246 | 25987 | 436 | 2.84573 | 12.4073828 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 233 | 1.3999999999999997e-56 | NTclustered | gi|116222168|gb|DQ980460.1| | 41120 | g25362 | i0 | 81.145 | 53.447247706422 | 297 | 50 | 67 | 6 | 143 | 436 | 1906 | 1613 | Apusomonas proboscidea clone aphsp90 Hsp90 mRNA, partial cds | blastn | 23303 | 233 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 12930441 | 12930441 | PRJNA1059246_P_NODE_12351_length_676_cov_2.288557_g11772_i0 | PRJNA1059246 | 12351 | 676 | 2.288557 | 15.47064532 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 63.9 | 3.11e-5 | NTclustered | gi|923129264|ref|XM_013902644.1| | 461836 | g11772 | i0 | 100 | 0.276627218934911 | 34 | 0 | 5 | 0 | 321 | 354 | 196 | 163 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_05025), partial mRNA | blastn | 187 | 63.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12930599 | 12930599 | PRJNA1059246_P_NODE_24231_length_455_cov_2.209424_g23607_i0 | PRJNA1059246 | 24231 | 455 | 2.209424 | 10.0528792 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 255 | 3.13e-63 | NTclustered | gi|923121052|ref|XM_013898544.1| | 461836 | g23607 | i0 | 80.392 | 8.77802197802198 | 357 | 53 | 76 | 11 | 1 | 348 | 859 | 1207 | Thecamonas trahens ATCC 50062 DEAD-box ATP-dependent RNA helicase 56 (AMSG_09968), mRNA | blastn | 3994 | 255 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12930815 | 12930815 | PRJNA1059246_P_NODE_43991_length_317_cov_0.946721_g43365_i0 | PRJNA1059246 | 43991 | 317 | 0.946721 | 3.00110557 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 315 | 3.4299999999999993e-81 | NTclustered | gi|923133342|ref|XM_013904683.1| | 461836 | g43365 | i0 | 84.543 | 3.75709779179811 | 317 | 49 | 100 | 0 | 1 | 317 | 1017 | 701 | Thecamonas trahens ATCC 50062 beta-ureidopropionase (AMSG_03295), partial mRNA | blastn | 1191 | 315 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12930934 | 12930934 | PRJNA1059246_P_NODE_53151_length_279_cov_1.932039_g52525_i0 | PRJNA1059246 | 53151 | 279 | 1.932039 | 5.39038881 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 324 | 4.93e-84 | NTclustered | gi|923129538|ref|XM_013902781.1| | 461836 | g52525 | i0 | 87.814 | 96.8637992831541 | 279 | 31 | 100 | 2 | 1 | 279 | 2906 | 2631 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_11856), partial mRNA | blastn | 27025 | 324 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 16754316 | 16754316 | PRJNA1059246_P_NODE_63374_length_249_cov_2.625000_g62748_i0 | PRJNA1059246 | 63374 | 249 | 2.625 | 6.53625 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 62.1 | 3.74e-5 | NTclustered | gi|923122824|ref|XM_013899428.1| | 461836 | g62748 | i0 | 82.667 | 0.698795180722892 | 75 | 7 | 30 | 4 | 5 | 79 | 3204 | 3136 | Thecamonas trahens ATCC 50062 CMGC/DYRK/YAK protein kinase (AMSG_09172), mRNA | blastn | 174 | 62.1 | 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);;