contig_metadata
15 rows where bioproject = "PRJNA980585", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4783331 | 4783331 | PRJNA980585_P_NODE_57084_length_243_cov_0.905882_g56830_i0 | PRJNA980585 | 57084 | 243 | 0.905882 | 2.20129326 | Carpediemonas sp. NC | 797131 | Fornicata | other_Eukaryota | 182 | 2.68e-41 | NTclustered | gi|339759391|dbj|AB600309.1| | 797131 | g56830 | i0 | 81.416 | 88.9094650205761 | 226 | 38 | 92 | 4 | 6 | 229 | 1164 | 941 | Carpediemonas sp. NC gene for translation elongation factor 1 alpha, partial cds | blastn | 21605 | 182 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas sp. NC | |||||
| 23907603 | 23907603 | PRJNA980585_P_NODE_54739_length_244_cov_0.900585_g54485_i0 | PRJNA980585 | 54739 | 244 | 0.900585 | 2.1974274 | Ergobibamus cyprinoides | 926446 | Fornicata | other_Eukaryota | 204 | 5.74e-48 | NTclustered | gi|339759379|dbj|AB600302.1| | 926446 | g54485 | i0 | 82.305 | 135.80737704918 | 243 | 35 | 98 | 7 | 6 | 244 | 909 | 671 | Ergobibamus cyprinoides hsp70 gene for heat shock protein 70, partial cds, strain: CL | blastn | 33137 | 204 | 1 | Eukaryota | Metamonada | Fornicata | Ergobibamus | Ergobibamus cyprinoides | |||||
| 27057814 | 27057814 | PRJNA980585_P_NODE_6502_length_506_cov_1.341801_g6248_i0 | PRJNA980585 | 6502 | 506 | 1.341801 | 6.78951306 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 64.7 | 1.24e-8 | NR | XP_001707611.1 | 5741 | g6248 | i0 | 40.7 | 0.539525691699605 | 91 | 44 | 51 | 4 | 483 | 226 | 112 | 197 | XP_001707611.1 High cysteine membrane protein Group 5 [Giardia intestinalis] | diamond | 273 | 64.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27816150 | 27816150 | PRJNA980585_P_NODE_9244_length_437_cov_1.266484_g8990_i0 | PRJNA980585 | 9244 | 437 | 1.266484 | 5.53453508 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 45.4 | 0.0206 | NR | ESU41635.1 | 5741 | g8990 | i0 | 39.7 | 0.535469107551487 | 78 | 32 | 45.3 | 3 | 1 | 198 | 138 | 212 | ESU41635.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 234 | 45.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28321008 | 28321008 | PRJNA980585_P_NODE_17426_length_340_cov_1.441948_g17172_i0 | PRJNA980585 | 17426 | 340 | 1.441948 | 4.9026232 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 59.3 | 1.8e-7 | NR | EFO63768.1 | 658858 | g17172 | i0 | 37.8 | 3.69705882352941 | 74 | 44 | 64.4 | 2 | 246 | 28 | 496 | 568 | EFO63768.1 High cysteine membrane protein Group 3 [Giardia lamblia P15] | diamond | 1257 | 59.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29047375 | 29047375 | PRJNA980585_P_NODE_16188_length_350_cov_0.978339_g15934_i0 | PRJNA980585 | 16188 | 350 | 0.978339 | 3.4241865 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 49.7 | 9.28e-5 | NR | KAG9393428.1 | 201153 | g15934 | i0 | 40.7 | 0.694285714285714 | 81 | 41 | 68.6 | 3 | 346 | 107 | 52 | 126 | KAG9393428.1 Profilin [Carpediemonas membranifera] | diamond | 243 | 49.7 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29589828 | 29589828 | PRJNA980585_P_NODE_33050_length_271_cov_1.555556_g32796_i0 | PRJNA980585 | 33050 | 271 | 1.555556 | 4.21555676 | Giardia | 5740 | Fornicata | other_Eukaryota | 50.4 | 1.02e-4 | NR | ESU40393.1 | 5741 | g32796 | i0 | 33.3 | 5.11439114391144 | 69 | 39 | 68.6 | 2 | 190 | 5 | 285 | 353 | ESU40393.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 1386 | 50.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30120854 | 30120854 | PRJNA980585_P_NODE_8932_length_442_cov_8.349593_g8678_i0 | PRJNA980585 | 8932 | 442 | 8.349593 | 36.90520106 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.1 | 0.0337 | NR | XP_067762115.1 | 348837 | g8678 | i0 | 37.5 | 0.380090497737557 | 56 | 34 | 38 | 1 | 247 | 80 | 41 | 95 | XP_067762115.1 Dynein light chain [Spironucleus salmonicida] | diamond | 168 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 30658105 | 30658105 | PRJNA980585_P_NODE_9153_length_438_cov_4.219178_g8899_i0 | PRJNA980585 | 9153 | 438 | 4.219178 | 18.47999964 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 117 | 9.61e-31 | NR | KAG9397047.1 | 201153 | g8899 | i0 | 46.6 | 1.62328767123288 | 116 | 61 | 79.5 | 1 | 46 | 393 | 19 | 133 | KAG9397047.1 Ribosomal protein S12e [Carpediemonas membranifera] | diamond | 711 | 117 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30942604 | 30942604 | PRJNA980585_P_NODE_28434_length_284_cov_1.265403_g28180_i0 | PRJNA980585 | 28434 | 284 | 1.265403 | 3.59374452 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 66.2 | 3.11e-10 | NR | GIQ81406.1 | 797122 | g28180 | i0 | 52.4 | 0.665492957746479 | 63 | 30 | 66.5 | 0 | 3 | 191 | 172 | 234 | GIQ81406.1 hypothetical protein KIPB_002359 [Kipferlia bialata] | diamond | 189 | 66.2 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31100265 | 31100265 | PRJNA980585_P_NODE_41235_length_251_cov_0.865169_g40981_i0 | PRJNA980585 | 41235 | 251 | 0.865169 | 2.17157419 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 56.6 | 9.33e-8 | NR | GCA62038.1 | 797122 | g40981 | i0 | 51.5 | 1.48207171314741 | 66 | 24 | 69.3 | 1 | 178 | 5 | 8 | 73 | GCA62038.1 hypothetical protein KIPB_000788 [Kipferlia bialata] | diamond | 372 | 56.6 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31827619 | 31827619 | PRJNA980585_P_NODE_47117_length_248_cov_0.880000_g46863_i0 | PRJNA980585 | 47117 | 248 | 0.88 | 2.1824 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 60.8 | 1.64e-8 | NR | XP_001705344.1 | 5741 | g46863 | i0 | 44.8 | 0.701612903225806 | 58 | 30 | 67.7 | 1 | 172 | 5 | 402 | 459 | XP_001705344.1 High cysteine membrane protein Group 5 [Giardia intestinalis] | diamond | 174 | 60.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31833746 | 31833746 | PRJNA980585_P_NODE_21937_length_312_cov_1.288703_g21683_i0 | PRJNA980585 | 21937 | 312 | 1.288703 | 4.02075336 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.3 | 0.0241 | NR | ESU39976.1 | 5741 | g21683 | i0 | 39.6 | 1 | 48 | 27 | 46.2 | 1 | 246 | 103 | 486 | 531 | ESU39976.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 312 | 44.7 | 0.991051454138702 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32017617 | 32017617 | PRJNA980585_P_NODE_52878_length_245_cov_0.895349_g52624_i0 | PRJNA980585 | 52878 | 245 | 0.895349 | 2.19360505 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 59.7 | 4.13e-8 | NR | CAK8809694.1 | 28002 | g52624 | i0 | 35.9 | 2.82857142857143 | 78 | 48 | 93.1 | 1 | 6 | 233 | 355 | 432 | CAK8809694.1 HINF_012001 [Hexamita inflata] | diamond | 693 | 59.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32270875 | 32270875 | PRJNA980585_P_NODE_28658_length_283_cov_1.466667_g28404_i0 | PRJNA980585 | 28658 | 283 | 1.466667 | 4.15066761 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 48.5 | 5.66e-4 | NR | EFO64937.1 | 658858 | g28404 | i0 | 45 | 1.886925795053 | 60 | 31 | 61.5 | 1 | 7 | 180 | 488 | 547 | EFO64937.1 High cysteine membrane VSP-like protein [Giardia lamblia P15] | diamond | 534 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis |
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);;