contig_metadata
13 rows where bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2922527 | 2922527 | PRJNA285816_S_NODE_1163_length_605_cov_2.410072_g1072_i0 | PRJNA285816 | 1163 | 605 | 2.410072 | 14.5809356 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 207 | 5.3800000000000006e-58 | NR | KAG9389740.1 | 201153 | g1072 | i0 | 54.6 | 5.03305785123967 | 205 | 87 | 98.7 | 1 | 2 | 598 | 227 | 431 | KAG9389740.1 calcium-translocating P-type ATPase [Carpediemonas membranifera] | diamond | 3045 | 207 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 10575862 | 10575862 | PRJNA285816_S_NODE_14849_length_201_cov_0.888158_g14747_i0 | PRJNA285816 | 14849 | 201 | 0.888158 | 1.78519758 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 87.4 | 1.49e-18 | NR | GIQ89219.1 | 797122 | g14747 | i0 | 62.3 | 0.91044776119403 | 61 | 23 | 91 | 0 | 18 | 200 | 115 | 175 | GIQ89219.1 peptidase C1A, partial [Kipferlia bialata] | diamond | 183 | 87.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 26996729 | 26996729 | PRJNA285816_S_NODE_25182_length_167_cov_1.720339_g25080_i0 | PRJNA285816 | 25182 | 167 | 1.720339 | 2.87296613 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 2.07e-6 | NR | KAG9390876.1 | 201153 | g25080 | i0 | 40.7 | 2.82035928143713 | 54 | 32 | 97 | 0 | 167 | 6 | 117 | 170 | KAG9390876.1 Protein tyrosine kinase [Carpediemonas membranifera] | diamond | 471 | 53.5 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27863734 | 27863734 | PRJNA285816_S_NODE_825_length_690_cov_4.982839_g759_i0 | PRJNA285816 | 825 | 690 | 4.982839 | 34.3815891 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 49.3 | 0.009 | NR | GIQ80334.1 | 797122 | g759 | i0 | 32.3 | 0.68695652173913 | 158 | 92 | 64.3 | 6 | 56 | 499 | 896 | 1048 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 474 | 49.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28148144 | 28148144 | PRJNA285816_S_NODE_25985_length_166_cov_1.333333_g25883_i0 | PRJNA285816 | 25985 | 166 | 1.333333 | 2.21333278 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 54.3 | 1.04e-6 | NR | CAK8813933.1 | 28002 | g25883 | i0 | 45.5 | 1.64457831325301 | 44 | 24 | 79.5 | 0 | 18 | 149 | 294 | 337 | CAK8813933.1 HINF_000805 [Hexamita inflata] | diamond | 273 | 54.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28355008 | 28355008 | PRJNA285816_S_NODE_1686_length_507_cov_4.139738_g1584_i0 | PRJNA285816 | 1686 | 507 | 4.139738 | 20.98847166 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 109 | 2.29e-27 | NR | GIQ82639.1 | 797122 | g1584 | i0 | 43.2 | 3.72189349112426 | 125 | 68 | 74 | 1 | 51 | 425 | 6 | 127 | GIQ82639.1 hypothetical protein KIPB_003808 [Kipferlia bialata] | diamond | 1887 | 109 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28937440 | 28937440 | PRJNA285816_S_NODE_29608_length_162_cov_0.920354_g29506_i0 | PRJNA285816 | 29608 | 162 | 0.920354 | 1.49097348 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 69.7 | 3.41e-12 | NR | GIQ88195.1 | 797122 | g29506 | i0 | 66 | 0.981481481481482 | 53 | 18 | 98.1 | 0 | 161 | 3 | 188 | 240 | GIQ88195.1 kinesin-like protein, partial [Kipferlia bialata] | diamond | 159 | 69.7 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30011108 | 30011108 | PRJNA285816_S_NODE_7251_length_262_cov_2.051643_g7149_i0 | PRJNA285816 | 7251 | 262 | 2.051643 | 5.37530466 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 57 | 4.33e-7 | NR | KAG9394743.1 | 201153 | g7149 | i0 | 35.6 | 0.99618320610687 | 87 | 54 | 98.5 | 2 | 3 | 260 | 499 | 584 | KAG9394743.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 261 | 57 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30168722 | 30168722 | PRJNA285816_S_NODE_1772_length_495_cov_4.282511_g1670_i0 | PRJNA285816 | 1772 | 495 | 4.282511 | 21.19842945 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 88.2 | 8.76e-17 | NR | KAG9396990.1 | 201153 | g1670 | i0 | 33.5 | 1.03030303030303 | 170 | 100 | 97 | 6 | 495 | 16 | 194 | 360 | KAG9396990.1 ABC transporter substrate-binding protein [Carpediemonas membranifera] | diamond | 510 | 88.2 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30863931 | 30863931 | PRJNA285816_S_NODE_15574_length_197_cov_1.952703_g15472_i0 | PRJNA285816 | 15574 | 197 | 1.952703 | 3.84682491 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 50.8 | 2.81e-5 | NR | KAG9393206.1 | 201153 | g15472 | i0 | 52.4 | 0.639593908629442 | 42 | 19 | 64 | 1 | 189 | 64 | 192 | 232 | KAG9393206.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 126 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31147976 | 31147976 | PRJNA285816_S_NODE_3135_length_379_cov_2.360606_g3033_i0 | PRJNA285816 | 3135 | 379 | 2.360606 | 8.94669674 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 77.4 | 5.85e-15 | NR | KAG9392754.1 | 201153 | g3033 | i0 | 41.9 | 0.736147757255937 | 93 | 53 | 72.8 | 1 | 276 | 1 | 37 | 129 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 279 | 77.4 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32160778 | 32160778 | PRJNA285816_S_NODE_25018_length_168_cov_0.873950_g24916_i0 | PRJNA285816 | 25018 | 168 | 0.87395 | 1.468236 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 44.7 | 0.00278 | NR | ESU42997.1 | 5741 | g24916 | i0 | 54.3 | 1.76785714285714 | 35 | 16 | 62.5 | 0 | 167 | 63 | 205 | 239 | ESU42997.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 297 | 44.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32223962 | 32223962 | PRJNA285816_S_NODE_5758_length_288_cov_6.075314_g5656_i0 | PRJNA285816 | 5758 | 288 | 6.075314 | 17.49690432 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 47.8 | 0.00106 | NR | KAG9390019.1 | 201153 | g5656 | i0 | 26.3 | 3.01041666666667 | 95 | 68 | 96.9 | 1 | 285 | 7 | 165 | 259 | KAG9390019.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 867 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera |
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);;