contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3981366 | 3981366 | PRJNA1010662_P_NODE_6364_length_218_cov_2.266272_g6305_i0 | PRJNA1010662 | 6364 | 218 | 2.266272 | 4.94047296 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 83.6 | 7.89e-17 | NR | XP_013762925.1 | 461836 | g6305 | i0 | 52.9 | 1.84403669724771 | 68 | 32 | 93.6 | 0 | 1 | 204 | 259 | 326 | XP_013762925.1 cruzipain [Thecamonas trahens ATCC 50062] | diamond | 402 | 83.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26844900 | 26844900 | PRJNA1010662_P_NODE_7341_length_207_cov_1.930380_g7282_i0 | PRJNA1010662 | 7341 | 207 | 1.93038 | 3.9958866 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 48.5 | 9.8e-5 | NR | XP_013753243.1 | 461836 | g7282 | i0 | 41.4 | 1.01449275362319 | 70 | 40 | 100 | 1 | 207 | 1 | 7 | 76 | XP_013753243.1 uncharacterized protein AMSG_10809 [Thecamonas trahens ATCC 50062] | diamond | 210 | 48.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26971093 | 26971093 | PRJNA1010662_P_NODE_2182_length_344_cov_1.400000_g2123_i0 | PRJNA1010662 | 2182 | 344 | 1.4 | 4.816 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 76.3 | 2.09e-13 | NR | XP_013763036.1 | 461836 | g2123 | i0 | 44.6 | 0.976744186046512 | 112 | 50 | 90.7 | 4 | 316 | 5 | 380 | 487 | XP_013763036.1 tripeptidyl peptidase [Thecamonas trahens ATCC 50062] | diamond | 336 | 76.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28195461 | 28195461 | PRJNA1010662_P_NODE_14806_length_165_cov_0.896552_g14747_i0 | PRJNA1010662 | 14806 | 165 | 0.896552 | 1.4793108 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 9.43e-6 | NR | XP_013761031.1 | 461836 | g14747 | i0 | 50.9 | 3.85454545454545 | 53 | 26 | 96.4 | 0 | 163 | 5 | 251 | 303 | XP_013761031.1 Cullin-3 [Thecamonas trahens ATCC 50062] | diamond | 636 | 52 | 0.992307692307692 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28455892 | 28455892 | PRJNA1010662_P_NODE_2906_length_303_cov_1.228346_g2847_i0 | PRJNA1010662 | 2906 | 303 | 1.228346 | 3.72188838 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 96.7 | 3.75e-22 | NR | XP_013762487.1 | 461836 | g2847 | i0 | 55 | 0.792079207920792 | 80 | 36 | 79.2 | 0 | 303 | 64 | 152 | 231 | XP_013762487.1 countin-1 [Thecamonas trahens ATCC 50062] | diamond | 240 | 96.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29529348 | 29529348 | PRJNA1010662_P_NODE_3590_length_274_cov_2.937778_g3531_i0 | PRJNA1010662 | 3590 | 274 | 2.937778 | 8.04951172 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 86.3 | 2.66e-17 | NR | XP_013760714.1 | 461836 | g3531 | i0 | 50.6 | 0.974452554744526 | 89 | 42 | 97.4 | 2 | 271 | 5 | 143 | 229 | XP_013760714.1 surfactant protein B containing protein [Thecamonas trahens ATCC 50062] | diamond | 267 | 86.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31677903 | 31677903 | PRJNA1010662_P_NODE_14577_length_165_cov_1.327586_g14518_i0 | PRJNA1010662 | 14577 | 165 | 1.327586 | 2.1905169 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 62.8 | 1.08e-9 | NR | XP_013760629.1 | 461836 | g14518 | i0 | 68.3 | 0.745454545454545 | 41 | 13 | 74.5 | 0 | 5 | 127 | 857 | 897 | XP_013760629.1 uncharacterized protein AMSG_02788 [Thecamonas trahens ATCC 50062] | diamond | 123 | 62.8 | 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);;