contig_metadata
13 rows where bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13031229 | 13031229 | PRJNA1122875_P_NODE_2291_length_927_cov_2.632319_g2139_i0 | PRJNA1122875 | 2291 | 927 | 2.632319 | 24.40159713 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 192 | 2.2299999999999998e-54 | NR | KAG9393620.1 | 201153 | g2139 | i0 | 59.1 | 0.585760517799353 | 181 | 64 | 58.3 | 2 | 3 | 542 | 231 | 402 | KAG9393620.1 Aminomethyltransferase [Carpediemonas membranifera] | diamond | 543 | 192 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 15580822 | 15580822 | PRJNA1122875_P_NODE_8933_length_551_cov_1.487448_g8714_i0 | PRJNA1122875 | 8933 | 551 | 1.487448 | 8.19583848 | Ergobibamus cyprinoides | 926446 | Fornicata | other_Eukaryota | 359 | 2.8499999999999996e-94 | NTclustered | gi|339759383|dbj|AB600304.1| | 926446 | g8714 | i0 | 81.128 | 82.7604355716878 | 461 | 75 | 83 | 12 | 1 | 455 | 824 | 1278 | Ergobibamus cyprinoides gene for translation elongation factor 1 alpha, complete cds, strain: CL | blastn | 45601 | 359 | 1 | Eukaryota | Metamonada | Fornicata | Ergobibamus | Ergobibamus cyprinoides | |||||
| 26774659 | 26774659 | PRJNA1122875_P_NODE_3261_length_824_cov_2.372836_g3078_i0 | PRJNA1122875 | 3261 | 824 | 2.372836 | 19.55216864 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 66.6 | 2.79e-8 | NR | XP_067766868.1 | 348837 | g3078 | i0 | 39.3 | 0.746359223300971 | 107 | 56 | 37.1 | 5 | 23 | 328 | 428 | 530 | XP_067766868.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 615 | 66.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 27544164 | 27544164 | PRJNA1122875_P_NODE_50264_length_244_cov_1.339181_g50040_i0 | PRJNA1122875 | 50264 | 244 | 1.339181 | 3.26760164 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 43.9 | 0.0149 | NR | ESU44771.1 | 5741 | g50040 | i0 | 32.4 | 2.54508196721311 | 68 | 41 | 83.6 | 2 | 207 | 4 | 407 | 469 | ESU44771.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 621 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28017842 | 28017842 | PRJNA1122875_P_NODE_45545_length_249_cov_0.875000_g45321_i0 | PRJNA1122875 | 45545 | 249 | 0.875 | 2.17875 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 57.8 | 1.88e-7 | NR | GIQ84238.1 | 797122 | g45321 | i0 | 56.8 | 0.530120481927711 | 44 | 17 | 50.6 | 1 | 248 | 123 | 325 | 368 | GIQ84238.1 glycoside hydrolase, family 13 [Kipferlia bialata] | diamond | 132 | 57.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28743886 | 28743886 | PRJNA1122875_P_NODE_1547_length_1050_cov_1.919140_g1427_i0 | PRJNA1122875 | 1547 | 1050 | 1.91914 | 20.15097 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 136 | 5.83e-33 | NR | KAG9391109.1 | 201153 | g1427 | i0 | 30.7 | 1.78285714285714 | 322 | 200 | 88.9 | 6 | 47 | 979 | 9 | 318 | KAG9391109.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 1872 | 136 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29690750 | 29690750 | PRJNA1122875_P_NODE_17290_length_402_cov_1.161094_g17066_i0 | PRJNA1122875 | 17290 | 402 | 1.161094 | 4.66759788 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 87.4 | 1.88e-18 | NR | KAG9397400.1 | 201153 | g17066 | i0 | 39.4 | 0.985074626865672 | 132 | 76 | 97.8 | 3 | 398 | 6 | 25 | 153 | KAG9397400.1 EF-hand domain pair [Carpediemonas membranifera] | diamond | 396 | 87.4 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30701987 | 30701987 | PRJNA1122875_P_NODE_21914_length_354_cov_2.192171_g21690_i0 | PRJNA1122875 | 21914 | 354 | 2.192171 | 7.76028534 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 94 | 1.86e-21 | NR | CAK8788203.1 | 28002 | g21690 | i0 | 50 | 1.59322033898305 | 94 | 47 | 79.7 | 0 | 351 | 70 | 73 | 166 | CAK8788203.1 HINF_045896 [Hexamita inflata] | diamond | 564 | 94 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31681830 | 31681830 | PRJNA1122875_P_NODE_50857_length_244_cov_0.900585_g50633_i0 | PRJNA1122875 | 50857 | 244 | 0.900585 | 2.1974274 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 54.7 | 1.26e-7 | NR | GKT31054.1 | 2918883 | g50633 | i0 | 47.1 | 0.627049180327869 | 51 | 26 | 62.7 | 1 | 217 | 65 | 26 | 75 | GKT31054.1 hypothetical protein ADUPG1_005738, partial [Aduncisulcus paluster] | diamond | 153 | 54.7 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 31734305 | 31734305 | PRJNA1122875_P_NODE_6257_length_638_cov_1.826549_g6041_i0 | PRJNA1122875 | 6257 | 638 | 1.826549 | 11.65338262 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 164 | 8.93e-46 | NR | KAG9391426.1 | 201153 | g6041 | i0 | 44.6 | 2.86363636363636 | 193 | 98 | 90.8 | 2 | 625 | 47 | 40 | 223 | KAG9391426.1 Hydrogenosomal membrane protein 31-like [Carpediemonas membranifera] | diamond | 1827 | 164 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31839996 | 31839996 | PRJNA1122875_P_NODE_22297_length_351_cov_1.661871_g22073_i0 | PRJNA1122875 | 22297 | 351 | 1.661871 | 5.83316721 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 52.4 | 3.77e-6 | NR | CAK8811890.1 | 28002 | g22073 | i0 | 47.1 | 0.905982905982906 | 51 | 26 | 42.7 | 1 | 350 | 201 | 11 | 61 | CAK8811890.1 HINF_040402 [Hexamita inflata] | diamond | 318 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32093225 | 32093225 | PRJNA1122875_P_NODE_15498_length_424_cov_1.091168_g15274_i0 | PRJNA1122875 | 15498 | 424 | 1.091168 | 4.62655232 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 60.8 | 2.33e-8 | NR | GCA62031.1 | 797122 | g15274 | i0 | 35.7 | 0.813679245283019 | 115 | 60 | 76.4 | 4 | 96 | 419 | 53 | 160 | GCA62031.1 hypothetical protein KIPB_000762 [Kipferlia bialata] | diamond | 345 | 60.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32156733 | 32156733 | PRJNA1122875_P_NODE_30758_length_294_cov_1.823529_g30534_i0 | PRJNA1122875 | 30758 | 294 | 1.823529 | 5.3611752600000004 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 94.7 | 3.89e-20 | NR | KAG9392656.1 | 201153 | g30534 | i0 | 48.3 | 0.908163265306122 | 89 | 46 | 90.8 | 0 | 10 | 276 | 508 | 596 | KAG9392656.1 ABC transporter transmembrane region 2 [Carpediemonas membranifera] | diamond | 267 | 94.7 | 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);;