contig_metadata
20 rows where bioproject = "PRJNA811237", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7187039 | 7187039 | PRJNA811237_S_NODE_17146_length_200_cov_1.841060_g16906_i0 | PRJNA811237 | 17146 | 200 | 1.84106 | 3.68212 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 79 | 3.64e-15 | NR | ESU37696.1 | 5741 | g16906 | i0 | 63.8 | 21.39 | 58 | 21 | 87 | 0 | 22 | 195 | 513 | 570 | ESU37696.1 RNase L inhibitor [Giardia intestinalis] | diamond | 4278 | 79.7 | 0.991217063989962 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 13562343 | 13562343 | PRJNA811237_S_NODE_13111_length_220_cov_1.789474_g12871_i0 | PRJNA811237 | 13111 | 220 | 1.789474 | 3.9368428 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 99.8 | 1.25e-24 | NR | KAG9394003.1 | 201153 | g12871 | i0 | 75.4 | 2.72727272727273 | 65 | 16 | 88.6 | 0 | 219 | 25 | 92 | 156 | KAG9394003.1 ISC system FeS cluster assembly, IscU scaffold [Carpediemonas membranifera] | diamond | 600 | 99.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 26959129 | 26959129 | PRJNA811237_S_NODE_12282_length_225_cov_1.738636_g12042_i0 | PRJNA811237 | 12282 | 225 | 1.738636 | 3.911931 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 58.5 | 3.76e-9 | NR | KAG9389513.1 | 201153 | g12042 | i0 | 56.8 | 1.17333333333333 | 44 | 18 | 58.7 | 1 | 224 | 93 | 47 | 89 | KAG9389513.1 Dynein light chain, type 1/2 [Carpediemonas membranifera] | diamond | 264 | 58.5 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27212106 | 27212106 | PRJNA811237_S_NODE_31582_length_164_cov_0.886957_g31342_i0 | PRJNA811237 | 31582 | 164 | 0.886957 | 1.45460948 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 47.8 | 2.18e-4 | NR | KAG9393968.1 | 201153 | g31342 | i0 | 57.9 | 1.42682926829268 | 38 | 16 | 69.5 | 0 | 160 | 47 | 694 | 731 | KAG9393968.1 Zinc carboxypeptidase [Carpediemonas membranifera] | diamond | 234 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27695189 | 27695189 | PRJNA811237_S_NODE_924_length_727_cov_2.141593_g723_i0 | PRJNA811237 | 924 | 727 | 2.141593 | 15.56938111 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.9 | 3.48e-6 | NR | CAK8749978.1 | 28002 | g723 | i0 | 41.7 | 4.22145804676754 | 96 | 50 | 39.2 | 3 | 286 | 2 | 113 | 203 | CAK8749978.1 HINF_063865 [Hexamita inflata] | diamond | 3069 | 59.3 | 0.993254637436762 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28601816 | 28601816 | PRJNA811237_S_NODE_13667_length_217_cov_1.214286_g13427_i0 | PRJNA811237 | 13667 | 217 | 1.214286 | 2.63500062 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 52 | 1.47e-5 | NR | XP_001705344.1 | 5741 | g13427 | i0 | 38.8 | 3.02764976958525 | 49 | 30 | 67.7 | 0 | 216 | 70 | 424 | 472 | XP_001705344.1 High cysteine membrane protein Group 5 [Giardia intestinalis] | diamond | 657 | 52.4 | 0.99236641221374 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29043936 | 29043936 | PRJNA811237_S_NODE_6828_length_284_cov_1.519149_g6588_i0 | PRJNA811237 | 6828 | 284 | 1.519149 | 4.31438316 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 44.7 | 0.00767 | NR | CAK8764237.1 | 28002 | g6588 | i0 | 40.6 | 0.676056338028169 | 64 | 33 | 62.3 | 2 | 5 | 181 | 98 | 161 | CAK8764237.1 HINF_097394 [Hexamita inflata] | diamond | 192 | 44.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29170197 | 29170197 | PRJNA811237_S_NODE_4309_length_349_cov_9.700000_g4069_i0 | PRJNA811237 | 4309 | 349 | 9.7 | 33.853 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 70.5 | 2.01e-12 | NR | KAG9392754.1 | 201153 | g4069 | i0 | 40.3 | 1.02292263610315 | 119 | 61 | 98.9 | 6 | 345 | 1 | 1 | 113 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 357 | 70.5 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29391200 | 29391200 | PRJNA811237_S_NODE_4729_length_332_cov_3.204947_g4489_i0 | PRJNA811237 | 4729 | 332 | 3.204947 | 10.64042404 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 60.1 | 8.92e-8 | NR | GKT24632.1 | 2918883 | g4489 | i0 | 37.5 | 0.795180722891566 | 88 | 49 | 79.5 | 1 | 65 | 328 | 557 | 638 | GKT24632.1 hypothetical protein ADUPG1_012796, partial [Aduncisulcus paluster] | diamond | 264 | 60.1 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 29485547 | 29485547 | PRJNA811237_S_NODE_6890_length_283_cov_1.307692_g6650_i0 | PRJNA811237 | 6890 | 283 | 1.307692 | 3.70076836 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.5 | 0.0316 | NR | XP_067766637.1 | 348837 | g6650 | i0 | 32.6 | 0.911660777385159 | 86 | 56 | 91.2 | 1 | 278 | 21 | 319 | 402 | XP_067766637.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 258 | 43.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 29715334 | 29715334 | PRJNA811237_S_NODE_31590_length_164_cov_0.886957_g31350_i0 | PRJNA811237 | 31590 | 164 | 0.886957 | 1.45460948 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.1 | 0.00192 | NR | XP_067762661.1 | 348837 | g31350 | i0 | 50 | 2.67073170731707 | 52 | 20 | 95.1 | 3 | 159 | 4 | 47 | 92 | XP_067762661.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 438 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 29905274 | 29905274 | PRJNA811237_S_NODE_691_length_832_cov_3.480204_g509_i0 | PRJNA811237 | 691 | 832 | 3.480204 | 28.95529728 | root | 1 | Root_unresolved | Root_unresolved | 66.6 | 2.44e-8 | NR | KAG9389986.1 | 201153 | g509 | i0 | 27.4 | 2.27524038461538 | 208 | 117 | 75 | 4 | 53 | 676 | 334 | 507 | KAG9389986.1 putative enzymatic polyprotein [Carpediemonas membranifera] | diamond | 1893 | 66.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30085728 | 30085728 | PRJNA811237_S_NODE_17732_length_198_cov_1.275168_g17492_i0 | PRJNA811237 | 17732 | 198 | 1.275168 | 2.52483264 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 42 | 0.0381 | NR | KAG9393895.1 | 201153 | g17492 | i0 | 30.3 | 1 | 66 | 45 | 100 | 1 | 198 | 1 | 68 | 132 | KAG9393895.1 START domain [Carpediemonas membranifera] | diamond | 198 | 42 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30307514 | 30307514 | PRJNA811237_S_NODE_23932_length_176_cov_2.157480_g23692_i0 | PRJNA811237 | 23932 | 176 | 2.15748 | 3.7971648 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 73.2 | 5.72e-14 | NR | GKT28404.1 | 2918883 | g23692 | i0 | 54.9 | 0.869318181818182 | 51 | 23 | 86.9 | 0 | 176 | 24 | 34 | 84 | GKT28404.1 Glycoside hydrolase, family 25 like protein [Aduncisulcus paluster] | diamond | 153 | 73.2 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30339086 | 30339086 | PRJNA811237_S_NODE_35192_length_161_cov_0.910714_g34952_i0 | PRJNA811237 | 35192 | 161 | 0.910714 | 1.46624954 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 43.1 | 0.00896 | NR | GIQ83316.1 | 797122 | g34952 | i0 | 42.9 | 0.91304347826087 | 49 | 27 | 91.3 | 1 | 14 | 160 | 62 | 109 | GIQ83316.1 hypothetical protein KIPB_004620 [Kipferlia bialata] | diamond | 147 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30907531 | 30907531 | PRJNA811237_S_NODE_27374_length_167_cov_1.296610_g27134_i0 | PRJNA811237 | 27374 | 167 | 1.29661 | 2.1653387 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 41.2 | 0.0482 | NR | KAG9395747.1 | 201153 | g27134 | i0 | 69.4 | 0.646706586826347 | 36 | 11 | 64.7 | 0 | 135 | 28 | 3006 | 3041 | KAG9395747.1 Dynein heavy chain and region D6 of dynein motor [Carpediemonas membranifera] | diamond | 108 | 41.2 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31223081 | 31223081 | PRJNA811237_S_NODE_11835_length_228_cov_1.424581_g11595_i0 | PRJNA811237 | 11835 | 228 | 1.424581 | 3.24804468 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 52.4 | 6.51e-6 | NR | CAK8774055.1 | 28002 | g11595 | i0 | 48 | 0.657894736842105 | 50 | 26 | 65.8 | 0 | 77 | 226 | 93 | 142 | CAK8774055.1 HINF_058378 [Hexamita inflata] | diamond | 150 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31318136 | 31318136 | PRJNA811237_S_NODE_19195_length_192_cov_1.664336_g18955_i0 | PRJNA811237 | 19195 | 192 | 1.664336 | 3.19552512 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 67.8 | 1.85e-11 | NR | XP_067760422.1 | 348837 | g18955 | i0 | 66 | 7.234375 | 53 | 14 | 82.8 | 1 | 192 | 34 | 46 | 94 | XP_067760422.1 Kinase, CMGC CDK [Spironucleus salmonicida] | diamond | 1389 | 67.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31318146 | 31318146 | PRJNA811237_S_NODE_28875_length_166_cov_0.871795_g28635_i0 | PRJNA811237 | 28875 | 166 | 0.871795 | 1.4471797 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 61.6 | 2.88e-9 | NR | GKT37275.1 | 2918883 | g28635 | i0 | 59.6 | 0.939759036144578 | 52 | 21 | 94 | 0 | 5 | 160 | 113 | 164 | GKT37275.1 Glycine--tRNA ligase, mitochondrial 1 [Aduncisulcus paluster] | diamond | 156 | 61.6 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 31991185 | 31991185 | PRJNA811237_S_NODE_32318_length_163_cov_1.342105_g32078_i0 | PRJNA811237 | 32318 | 163 | 1.342105 | 2.18763115 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.5 | 1.72e-7 | NR | CAK8793140.1 | 28002 | g32078 | i0 | 46 | 25.398773006135 | 50 | 27 | 92 | 0 | 152 | 3 | 58 | 107 | CAK8793140.1 HINF_058954 [Hexamita inflata] | diamond | 4140 | 55.8 | 0.99462365591397806 | 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);;