contig_metadata
8 rows where bioproject = "PRJNA515078", tax_clade = "Metamonada" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9415074 | 9415074 | PRJNA515078_P_NODE_6248_length_376_cov_2.165192_g6015_i0 | PRJNA515078 | 6248 | 376 | 2.165192 | 8.14112192 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 1.62e-22 | NR | ESU37416.1 | 5741 | g6015 | i0 | 57.5 | 5.52925531914894 | 80 | 32 | 62.2 | 1 | 141 | 374 | 17 | 96 | ESU37416.1 Protein disulfide isomerase [Giardia intestinalis] | diamond | 2079 | 101 | 0.99009900990099 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 10690732 | 10690732 | PRJNA515078_P_NODE_6669_length_362_cov_2.627692_g6436_i0 | PRJNA515078 | 6669 | 362 | 2.627692 | 9.51224504 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 54.7 | 0.01 | NTclustered | gi|2794881223|ref|XM_067906531.1| | 348837 | g6436 | i0 | 96.97 | 0.0911602209944751 | 33 | 0 | 9 | 1 | 135 | 167 | 1764 | 1795 | Spironucleus salmonicida Tenascin-like protein (SS50377_22645), partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28845483 | 28845483 | PRJNA515078_P_NODE_22608_length_183_cov_0.842466_g22375_i0 | PRJNA515078 | 22608 | 183 | 0.842466 | 1.54171278 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 42.7 | 0.0164 | NR | TNJ28141.1 | 5742 | g22375 | i0 | 52.9 | 1.34426229508197 | 34 | 14 | 55.7 | 1 | 178 | 77 | 56 | 87 | TNJ28141.1 High cysteine protein [Giardia muris] | diamond | 246 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 30235134 | 30235134 | PRJNA515078_P_NODE_372_length_1425_cov_3.220461_g315_i0 | PRJNA515078 | 372 | 1425 | 3.220461 | 45.89156925 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 53.5 | 0.00123 | NR | GIQ79393.1 | 797122 | g315 | i0 | 28.2 | 0.298947368421053 | 142 | 89 | 27.6 | 5 | 1259 | 867 | 45 | 184 | GIQ79393.1 hypothetical protein KIPB_000036 [Kipferlia bialata] | diamond | 426 | 53.5 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30597949 | 30597949 | PRJNA515078_P_NODE_20353_length_192_cov_2.000000_g20120_i0 | PRJNA515078 | 20353 | 192 | 2 | 3.84 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57 | 1.7e-7 | NR | KAG9393110.1 | 201153 | g20120 | i0 | 45.9 | 3.90625 | 61 | 29 | 95.3 | 1 | 191 | 9 | 226 | 282 | KAG9393110.1 Acyltransferase [Carpediemonas membranifera] | diamond | 750 | 57 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31356666 | 31356666 | PRJNA515078_P_NODE_21896_length_185_cov_1.601351_g21663_i0 | PRJNA515078 | 21896 | 185 | 1.601351 | 2.96249935 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.5 | 1.54e-4 | NR | ESU38557.1 | 5741 | g21663 | i0 | 41.7 | 1.88108108108108 | 60 | 30 | 92.4 | 3 | 179 | 9 | 32 | 89 | ESU38557.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 348 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31514925 | 31514925 | PRJNA515078_P_NODE_19056_length_199_cov_1.191358_g18823_i0 | PRJNA515078 | 19056 | 199 | 1.191358 | 2.37080242 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.00832 | NR | ESU40915.1 | 5741 | g18823 | i0 | 45.5 | 8.08040201005025 | 44 | 22 | 66.3 | 1 | 2 | 133 | 349 | 390 | ESU40915.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 1608 | 44.3 | 0.99097065462754 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32732490 | 32732490 | PRJNA515078_P_NODE_7800_length_330_cov_1.232082_g7567_i0 | PRJNA515078 | 7800 | 330 | 1.232082 | 4.0658706 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 48.5 | 8.18e-4 | NR | CAK8784082.1 | 28002 | g7567 | i0 | 25 | 3.01818181818182 | 112 | 76 | 97.3 | 2 | 328 | 8 | 108 | 216 | CAK8784082.1 HINF_043333 [Hexamita inflata] | diamond | 996 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata |
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);;