contig_metadata
12 rows where bioproject = "PRJNA1035005", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3995156 | 3995156 | PRJNA1035005_P_NODE_1064_length_1311_cov_8.742326_g823_i0 | PRJNA1035005 | 1064 | 1311 | 8.742326 | 114.61189386 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 374 | 2.83e-124 | NR | XP_013760592.1 | 461836 | g823 | i0 | 63.8 | 0.707093821510298 | 309 | 108 | 70.3 | 2 | 43 | 963 | 30 | 336 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 927 | 374 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 6547281 | 6547281 | PRJNA1035005_P_NODE_8766_length_379_cov_1.745098_g8364_i0 | PRJNA1035005 | 8766 | 379 | 1.745098 | 6.61392142 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 255 | 2.56e-63 | NTclustered | gi|923133736|ref|XM_013904880.1| | 461836 | g8364 | i0 | 88.263 | 56.3509234828496 | 213 | 25 | 56 | 0 | 3 | 215 | 327 | 115 | Thecamonas trahens ATCC 50062 ADP-ribosylation factor 1 (AMSG_02990), mRNA | blastn | 21357 | 255 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28045851 | 28045851 | PRJNA1035005_P_NODE_27505_length_286_cov_1.225352_g27099_i0 | PRJNA1035005 | 27505 | 286 | 1.225352 | 3.50450672 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 66.2 | 3.55e-10 | NR | XP_013757381.1 | 461836 | g27099 | i0 | 42.4 | 1.03846153846154 | 99 | 48 | 94.4 | 1 | 1 | 270 | 924 | 1022 | XP_013757381.1 ABC transporter [Thecamonas trahens ATCC 50062] | diamond | 297 | 66.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28424925 | 28424925 | PRJNA1035005_P_NODE_47146_length_260_cov_2.085561_g46740_i0 | PRJNA1035005 | 47146 | 260 | 2.085561 | 5.4224586 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 62 | 7.37e-9 | NR | XP_013759207.1 | 461836 | g46740 | i0 | 65 | 0.461538461538462 | 40 | 14 | 46.2 | 0 | 2 | 121 | 461 | 500 | XP_013759207.1 glucoamylase [Thecamonas trahens ATCC 50062] | diamond | 120 | 62 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28519628 | 28519628 | PRJNA1035005_P_NODE_34007_length_277_cov_1.651961_g33601_i0 | PRJNA1035005 | 34007 | 277 | 1.651961 | 4.57593197 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 73.9 | 5.26e-13 | NR | XP_013757206.1 | 461836 | g33601 | i0 | 44.3 | 1.05054151624549 | 97 | 46 | 98.6 | 3 | 3 | 275 | 294 | 388 | XP_013757206.1 tryptophan 2,3-dioxygenase [Thecamonas trahens ATCC 50062] | diamond | 291 | 73.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29087986 | 29087986 | PRJNA1035005_P_NODE_30588_length_282_cov_1.114833_g30182_i0 | PRJNA1035005 | 30588 | 282 | 1.114833 | 3.14382906 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 53.9 | 5.95e-6 | NR | XP_013759479.1 | 461836 | g30182 | i0 | 46.3 | 0.712765957446808 | 67 | 33 | 68.1 | 2 | 40 | 231 | 1 | 67 | XP_013759479.1 uncharacterized protein AMSG_02572 [Thecamonas trahens ATCC 50062] | diamond | 201 | 53.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29151364 | 29151364 | PRJNA1035005_P_NODE_43609_length_265_cov_1.296875_g43203_i0 | PRJNA1035005 | 43609 | 265 | 1.296875 | 3.43671875 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 57.4 | 3.4e-7 | NR | XP_013758347.1 | 461836 | g43203 | i0 | 42.5 | 2.34339622641509 | 73 | 42 | 82.6 | 0 | 2 | 220 | 514 | 586 | XP_013758347.1 phosphatidylinositol 4-kinase type 2-beta [Thecamonas trahens ATCC 50062] | diamond | 621 | 57.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29426958 | 29426958 | PRJNA1035005_P_NODE_35109_length_276_cov_1.280788_g34703_i0 | PRJNA1035005 | 35109 | 276 | 1.280788 | 3.53497488 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 9.15e-4 | NR | XP_013758206.1 | 461836 | g34703 | i0 | 36.6 | 3.52173913043478 | 71 | 40 | 77.2 | 3 | 57 | 269 | 27 | 92 | XP_013758206.1 AGC/AKT protein kinase [Thecamonas trahens ATCC 50062] | diamond | 972 | 48.1 | 0.993762993762994 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29813929 | 29813929 | PRJNA1035005_P_NODE_28331_length_285_cov_1.160377_g27925_i0 | PRJNA1035005 | 28331 | 285 | 1.160377 | 3.30707445 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 96.3 | 1.83e-22 | NR | XP_013757528.1 | 461836 | g27925 | i0 | 65.8 | 1.66315789473684 | 79 | 26 | 82.1 | 1 | 254 | 21 | 50 | 128 | XP_013757528.1 glutathione S-transferase 2 [Thecamonas trahens ATCC 50062] | diamond | 474 | 96.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29877350 | 29877350 | PRJNA1035005_P_NODE_47391_length_260_cov_1.668449_g46985_i0 | PRJNA1035005 | 47391 | 260 | 1.668449 | 4.3379674 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.1 | 3.58e-8 | NR | XP_013762398.1 | 461836 | g46985 | i0 | 61.9 | 0.484615384615385 | 42 | 16 | 48.5 | 0 | 3 | 128 | 561 | 602 | XP_013762398.1 uncharacterized protein AMSG_00666 [Thecamonas trahens ATCC 50062] | diamond | 126 | 60.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30667072 | 30667072 | PRJNA1035005_P_NODE_57493_length_252_cov_0.871508_g57087_i0 | PRJNA1035005 | 57493 | 252 | 0.871508 | 2.19620016 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 89 | 2.2e-18 | NR | XP_013758816.1 | 461836 | g57087 | i0 | 49.4 | 0.988095238095238 | 83 | 42 | 98.8 | 0 | 251 | 3 | 303 | 385 | XP_013758816.1 latex allergen Hevea brasiliensis [Thecamonas trahens ATCC 50062] | diamond | 249 | 89 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31583965 | 31583965 | PRJNA1035005_P_NODE_74736_length_246_cov_0.901734_g74330_i0 | PRJNA1035005 | 74736 | 246 | 0.901734 | 2.21826564 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 63.2 | 2.38e-9 | NR | XP_013755460.1 | 461836 | g74330 | i0 | 43.5 | 0.841463414634146 | 69 | 38 | 82.9 | 1 | 9 | 212 | 123 | 191 | XP_013755460.1 N-acylsphingosine amidohydrolase [Thecamonas trahens ATCC 50062] | diamond | 207 | 63.2 | 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);;