contig_metadata
14 rows where bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322444 | 322444 | PRJNA1195374_P_NODE_84501_length_241_cov_0.976190_g84157_i0 | PRJNA1195374 | 84501 | 241 | 0.97619 | 2.3526179 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 113 | 8.26e-30 | NR | KAG9394003.1 | 201153 | g84157 | i0 | 79.2 | 2.78838174273859 | 72 | 15 | 89.6 | 0 | 8 | 223 | 85 | 156 | KAG9394003.1 ISC system FeS cluster assembly, IscU scaffold [Carpediemonas membranifera] | diamond | 672 | 113 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 21997787 | 21997787 | PRJNA1195374_P_NODE_14538_length_591_cov_2.254826_g14199_i0 | PRJNA1195374 | 14538 | 591 | 2.254826 | 13.32602166 | Ergobibamus cyprinoides | 926446 | Fornicata | other_Eukaryota | 331 | 6.7e-86 | NTclustered | gi|339759377|dbj|AB600301.1| | 926446 | g14199 | i0 | 80.543 | 71.3011844331641 | 442 | 77 | 74 | 8 | 4 | 440 | 842 | 1279 | Ergobibamus cyprinoides gene for beta-tubulin, partial cds, strain: CL | blastn | 42139 | 331 | 1 | Eukaryota | Metamonada | Fornicata | Ergobibamus | Ergobibamus cyprinoides | |||||
| 26882762 | 26882762 | PRJNA1195374_P_NODE_72781_length_250_cov_0.870056_g72437_i0 | PRJNA1195374 | 72781 | 250 | 0.870056 | 2.17514 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 70.1 | 5.51e-12 | NR | KAG9390653.1 | 201153 | g72437 | i0 | 48.1 | 0.972 | 81 | 39 | 97.2 | 2 | 249 | 7 | 176 | 253 | KAG9390653.1 Papain family cysteine protease [Carpediemonas membranifera] | diamond | 243 | 70.1 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27167089 | 27167089 | PRJNA1195374_P_NODE_77802_length_246_cov_0.890173_g77458_i0 | PRJNA1195374 | 77802 | 246 | 0.890173 | 2.18982558 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 77.8 | 6.25e-16 | NR | KAG9396224.1 | 201153 | g77458 | i0 | 47.4 | 0.926829268292683 | 76 | 37 | 89 | 2 | 245 | 27 | 73 | 148 | KAG9396224.1 Glia maturation factor beta [Carpediemonas membranifera] | diamond | 228 | 77.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28240757 | 28240757 | PRJNA1195374_P_NODE_21846_length_485_cov_92.439320_g21503_i0 | PRJNA1195374 | 21846 | 485 | 92.43932 | 448.330702 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 47.8 | 0.00753 | NR | KWX13038.1 | 1394984 | g21503 | i0 | 37 | 0.451546391752577 | 73 | 42 | 42.7 | 2 | 116 | 322 | 103 | 175 | KWX13038.1 Variant-specific surface protein [Giardia intestinalis assemblage B] | diamond | 219 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28462200 | 28462200 | PRJNA1195374_P_NODE_14486_length_592_cov_2.175337_g14148_i0 | PRJNA1195374 | 14486 | 592 | 2.175337 | 12.87799504 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 85.5 | 3.01e-17 | NR | CAK8791145.1 | 28002 | g14148 | i0 | 36.6 | 1.97635135135135 | 131 | 69 | 66.4 | 4 | 563 | 171 | 33 | 149 | CAK8791145.1 HINF_096380 [Hexamita inflata] | diamond | 1170 | 85.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28859761 | 28859761 | PRJNA1195374_P_NODE_5128_length_921_cov_4.116745_g4865_i0 | PRJNA1195374 | 5128 | 921 | 4.116745 | 37.91522145 | Viridiplantae | 33090 | Fornicata | other_Eukaryota | 61.2 | 2.43e-6 | NR | XP_001709457.2 | 5741 | g4865 | i0 | 31.2 | 1.56351791530945 | 231 | 147 | 72 | 6 | 54 | 716 | 83 | 311 | XP_001709457.2 VSP [Giardia intestinalis] | diamond | 1440 | 61.6 | 0.993506493506494 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29566973 | 29566973 | PRJNA1195374_P_NODE_3110_length_1108_cov_2.052174_g2897_i0 | PRJNA1195374 | 3110 | 1108 | 2.052174 | 22.73808792 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 117 | 8.02e-26 | NR | KAG9390019.1 | 201153 | g2897 | i0 | 27.1 | 0.798736462093863 | 295 | 209 | 78.8 | 4 | 1046 | 174 | 4 | 296 | KAG9390019.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 885 | 117 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29661376 | 29661376 | PRJNA1195374_P_NODE_38170_length_363_cov_1.058621_g37826_i0 | PRJNA1195374 | 38170 | 363 | 1.058621 | 3.84279423 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 52.8 | 1.52e-5 | NR | KAG9397170.1 | 201153 | g37826 | i0 | 54.8 | 0.347107438016529 | 42 | 17 | 33.9 | 2 | 363 | 241 | 132 | 172 | KAG9397170.1 phage late control gene D protein GPD [Carpediemonas membranifera] | diamond | 126 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31450372 | 31450372 | PRJNA1195374_P_NODE_56416_length_289_cov_1.370370_g56072_i0 | PRJNA1195374 | 56416 | 289 | 1.37037 | 3.9603693 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.4 | 9.28e-24 | NR | CAK8817778.1 | 28002 | g56072 | i0 | 48.9 | 11.8546712802768 | 94 | 48 | 97.6 | 0 | 288 | 7 | 38 | 131 | CAK8817778.1 HINF_084084 [Hexamita inflata] | diamond | 3426 | 100 | 0.994 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31494660 | 31494660 | PRJNA1195374_P_NODE_45676_length_327_cov_2.590551_g45332_i0 | PRJNA1195374 | 45676 | 327 | 2.590551 | 8.47110177 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 48.9 | 4.49e-4 | NR | EET01524.1 | 598745 | g45332 | i0 | 34.2 | 1.55045871559633 | 76 | 49 | 69.7 | 1 | 275 | 48 | 135 | 209 | EET01524.1 Translation elongation factor [Giardia intestinalis ATCC 50581] | diamond | 507 | 48.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31652480 | 31652480 | PRJNA1195374_P_NODE_57437_length_286_cov_1.779343_g57093_i0 | PRJNA1195374 | 57437 | 286 | 1.779343 | 5.08892098 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 70.5 | 1.08e-11 | NR | TNJ27700.1 | 5742 | g57093 | i0 | 42.3 | 1.90909090909091 | 97 | 37 | 81.8 | 2 | 1 | 234 | 173 | 269 | TNJ27700.1 putative Ser/Thr phosphatase 2C [Giardia muris] | diamond | 546 | 70.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 32475433 | 32475433 | PRJNA1195374_P_NODE_30639_length_408_cov_2.841791_g30295_i0 | PRJNA1195374 | 30639 | 408 | 2.841791 | 11.59450728 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 65.9 | 1.88e-9 | NR | KAG9390253.1 | 201153 | g30295 | i0 | 33.6 | 1.66176470588235 | 113 | 70 | 83.1 | 1 | 3 | 341 | 373 | 480 | KAG9390253.1 Polycystin cation channel [Carpediemonas membranifera] | diamond | 678 | 65.9 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32809453 | 32809453 | PRJNA1195374_P_NODE_6120_length_858_cov_2.254777_g5839_i0 | PRJNA1195374 | 6120 | 858 | 2.254777 | 19.34598666 | Viridiplantae | 33090 | Fornicata | other_Eukaryota | 87.8 | 1.48e-16 | NR | GIQ86158.1 | 797122 | g5839 | i0 | 46.5 | 1.45104895104895 | 101 | 54 | 35.3 | 0 | 580 | 278 | 131 | 231 | GIQ86158.1 hypothetical protein KIPB_007957, partial [Kipferlia bialata] | diamond | 1245 | 87.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata |
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);;