contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9831706 | 9831706 | PRJNA928559_P_NODE_34528_length_562_cov_3.167689_g32982_i0 | PRJNA928559 | 34528 | 562 | 3.167689 | 17.80241218 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 191 | 2.68e-56 | NR | XP_013760592.1 | 461836 | g32982 | i0 | 63.3 | 0.784697508896797 | 147 | 52 | 77.9 | 2 | 3 | 440 | 195 | 340 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 441 | 191 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 10181571 | 10181571 | PRJNA928559_P_NODE_196388_length_249_cov_1.806818_g194819_i0 | PRJNA928559 | 196388 | 249 | 1.806818 | 4.49897682 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 89.7 | 1.19e-18 | NR | XP_013761543.1 | 461836 | g194819 | i0 | 58 | 1.67469879518072 | 69 | 29 | 83.1 | 0 | 38 | 244 | 3200 | 3268 | XP_013761543.1 dynein heavy chain 2 [Thecamonas trahens ATCC 50062] | diamond | 417 | 89.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 17481471 | 17481471 | PRJNA928559_P_NODE_199554_length_248_cov_0.937143_g197985_i0 | PRJNA928559 | 199554 | 248 | 0.937143 | 2.32411464 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 84.3 | 3.28e-17 | NR | XP_013760809.1 | 461836 | g197985 | i0 | 57.5 | 1.875 | 73 | 28 | 84.7 | 1 | 3 | 212 | 94 | 166 | XP_013760809.1 Ala-interacting subunit 5 [Thecamonas trahens ATCC 50062] | diamond | 465 | 84.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28193228 | 28193228 | PRJNA928559_P_NODE_18526_length_733_cov_4.054545_g17081_i0 | PRJNA928559 | 18526 | 733 | 4.054545 | 29.71981485 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 87 | 1.4e-15 | NR | XP_013758183.1 | 461836 | g17081 | i0 | 31 | 0.924965893587995 | 226 | 130 | 91.7 | 4 | 43 | 714 | 150 | 351 | XP_013758183.1 cystatin-A2 [Thecamonas trahens ATCC 50062] | diamond | 678 | 87 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28351228 | 28351228 | PRJNA928559_P_NODE_191386_length_251_cov_3.022472_g189817_i0 | PRJNA928559 | 191386 | 251 | 3.022472 | 7.58640472 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 65.9 | 2.44e-10 | NR | XP_013760592.1 | 461836 | g189817 | i0 | 66.7 | 0.537848605577689 | 45 | 15 | 53.8 | 0 | 15 | 149 | 294 | 338 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 135 | 65.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29740275 | 29740275 | PRJNA928559_P_NODE_173390_length_265_cov_1.281250_g171821_i0 | PRJNA928559 | 173390 | 265 | 1.28125 | 3.3953125 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 96.7 | 6.13e-24 | NR | XP_013753308.1 | 461836 | g171821 | i0 | 55.1 | 0.883018867924528 | 78 | 35 | 88.3 | 0 | 263 | 30 | 15 | 92 | XP_013753308.1 cystatin-B thiol proteinase inhibitor [Thecamonas trahens ATCC 50062] | diamond | 234 | 96.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31193475 | 31193475 | PRJNA928559_P_NODE_187915_length_253_cov_0.866667_g186346_i0 | PRJNA928559 | 187915 | 253 | 0.866667 | 2.19266751 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 52.4 | 1.74e-5 | NR | XP_013760362.1 | 461836 | g186346 | i0 | 40.5 | 0.99604743083004 | 84 | 45 | 99.6 | 2 | 253 | 2 | 656 | 734 | XP_013760362.1 meckelin [Thecamonas trahens ATCC 50062] | diamond | 252 | 52.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32617178 | 32617178 | PRJNA928559_P_NODE_140780_length_298_cov_1.662222_g139211_i0 | PRJNA928559 | 140780 | 298 | 1.662222 | 4.95342156 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 43.9 | 0.015 | NR | XP_013757154.1 | 461836 | g139211 | i0 | 32.8 | 0.674496644295302 | 67 | 45 | 67.4 | 0 | 246 | 46 | 99 | 165 | XP_013757154.1 uncharacterized protein AMSG_05741 [Thecamonas trahens ATCC 50062] | diamond | 201 | 43.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32869070 | 32869070 | PRJNA928559_P_NODE_188620_length_253_cov_0.866667_g187051_i0 | PRJNA928559 | 188620 | 253 | 0.866667 | 2.19266751 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 44.7 | 0.00792 | NR | XP_013759479.1 | 461836 | g187051 | i0 | 52 | 0.592885375494071 | 50 | 23 | 58.1 | 1 | 251 | 105 | 17 | 66 | XP_013759479.1 uncharacterized protein AMSG_02572 [Thecamonas trahens ATCC 50062] | diamond | 150 | 44.7 | 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);;