contig_metadata
15 rows where bioproject = "PRJNA966993", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27847075 | 27847075 | PRJNA966993_P_NODE_77564_length_258_cov_1.664865_g77112_i0 | PRJNA966993 | 77564 | 258 | 1.664865 | 4.2953517 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 108 | 1.7000000000000003e-28 | NR | GCA62516.1 | 797122 | g77112 | i0 | 62.5 | 1.02325581395349 | 88 | 30 | 98.8 | 1 | 257 | 3 | 2 | 89 | GCA62516.1 peptidyl-prolyl cis-trans isomerase, FKBP-type [Kipferlia bialata] | diamond | 264 | 108 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28036743 | 28036743 | PRJNA966993_P_NODE_68385_length_272_cov_2.658291_g67933_i0 | PRJNA966993 | 68385 | 272 | 2.658291 | 7.23055152 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 42.7 | 0.0466 | NR | ESU43281.1 | 5741 | g67933 | i0 | 32.9 | 0.805147058823529 | 73 | 42 | 73.9 | 3 | 69 | 269 | 76 | 147 | ESU43281.1 Nucleoporin NSP1, partial [Giardia intestinalis] | diamond | 219 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29047139 | 29047139 | PRJNA966993_P_NODE_84228_length_250_cov_0.870056_g83776_i0 | PRJNA966993 | 84228 | 250 | 0.870056 | 2.17514 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 52.8 | 1.17e-5 | NR | XP_001710073.1 | 5741 | g83776 | i0 | 39.3 | 1.992 | 56 | 33 | 66 | 1 | 3 | 167 | 513 | 568 | XP_001710073.1 High cysteine membrane protein VSP-like [Giardia intestinalis] | diamond | 498 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29267818 | 29267818 | PRJNA966993_P_NODE_60469_length_284_cov_1.459716_g60017_i0 | PRJNA966993 | 60469 | 284 | 1.459716 | 4.14559344 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 48.1 | 7.31e-4 | NR | GIQ84505.1 | 797122 | g60017 | i0 | 49 | 0.538732394366197 | 51 | 26 | 53.9 | 0 | 284 | 132 | 287 | 337 | GIQ84505.1 hypothetical protein KIPB_006005 [Kipferlia bialata] | diamond | 153 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29362873 | 29362873 | PRJNA966993_P_NODE_91569_length_246_cov_0.890173_g91117_i0 | PRJNA966993 | 91569 | 246 | 0.890173 | 2.18982558 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 44.3 | 0.011 | NR | EFO65737.1 | 658858 | g91117 | i0 | 32.9 | 0.963414634146341 | 79 | 49 | 95.1 | 3 | 235 | 2 | 347 | 422 | EFO65737.1 VSP [Giardia lamblia P15] | diamond | 237 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29425702 | 29425702 | PRJNA966993_P_NODE_98289_length_241_cov_1.833333_g97837_i0 | PRJNA966993 | 98289 | 241 | 1.833333 | 4.41833253 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 45.1 | 0.00554 | NR | EES99242.1 | 598745 | g97837 | i0 | 40 | 0.560165975103734 | 45 | 25 | 56 | 1 | 161 | 27 | 966 | 1008 | EES99242.1 High cysteine membrane protein Group 1 [Giardia intestinalis ATCC 50581] | diamond | 135 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29583411 | 29583411 | PRJNA966993_P_NODE_16410_length_517_cov_0.959459_g15968_i0 | PRJNA966993 | 16410 | 517 | 0.959459 | 4.96040303 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 103 | 6.38e-22 | NR | GIQ82421.1 | 797122 | g15968 | i0 | 35.9 | 1.05029013539652 | 181 | 93 | 99.8 | 4 | 517 | 2 | 640 | 806 | GIQ82421.1 hypothetical protein KIPB_003556 [Kipferlia bialata] | diamond | 543 | 103 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29899682 | 29899682 | PRJNA966993_P_NODE_60031_length_285_cov_1.089623_g59579_i0 | PRJNA966993 | 60031 | 285 | 1.089623 | 3.10542555 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 52.8 | 6.63e-6 | NR | CAK8805233.1 | 28002 | g59579 | i0 | 32 | 6.10526315789474 | 97 | 61 | 96.8 | 2 | 1 | 276 | 50 | 146 | CAK8805233.1 HINF_078122 [Hexamita inflata] | diamond | 1740 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30657748 | 30657748 | PRJNA966993_P_NODE_101233_length_228_cov_3.451613_g100781_i0 | PRJNA966993 | 101233 | 228 | 3.451613 | 7.86967764 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 57.4 | 8.61e-8 | NR | CAK8774055.1 | 28002 | g100781 | i0 | 42.6 | 1.77631578947368 | 61 | 35 | 80.3 | 0 | 218 | 36 | 93 | 153 | CAK8774055.1 HINF_058378 [Hexamita inflata] | diamond | 405 | 57.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30784157 | 30784157 | PRJNA966993_P_NODE_40694_length_338_cov_0.833962_g40242_i0 | PRJNA966993 | 40694 | 338 | 0.833962 | 2.81879156 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 52.8 | 3.4e-5 | NR | GIQ86879.1 | 797122 | g40242 | i0 | 33.3 | 0.772189349112426 | 87 | 57 | 77.2 | 1 | 265 | 5 | 584 | 669 | GIQ86879.1 hypothetical protein KIPB_008809 [Kipferlia bialata] | diamond | 261 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31289698 | 31289698 | PRJNA966993_P_NODE_74595_length_263_cov_1.621053_g74143_i0 | PRJNA966993 | 74595 | 263 | 1.621053 | 4.26336939 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 58.2 | 1.77e-7 | NR | EFO61119.1 | 658858 | g74143 | i0 | 43.6 | 0.889733840304182 | 78 | 40 | 84.4 | 2 | 261 | 40 | 187 | 264 | EFO61119.1 VSP [Giardia lamblia P15] | diamond | 234 | 58.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31391171 | 31391171 | PRJNA966993_P_NODE_85956_length_249_cov_0.875000_g85504_i0 | PRJNA966993 | 85956 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 1.45e-6 | NR | CAK8814716.1 | 28002 | g85504 | i0 | 47.5 | 6.37349397590361 | 59 | 31 | 71.1 | 0 | 21 | 197 | 128 | 186 | CAK8814716.1 HINF_006105 [Hexamita inflata] | diamond | 1587 | 54.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31707288 | 31707288 | PRJNA966993_P_NODE_60477_length_284_cov_1.459716_g60025_i0 | PRJNA966993 | 60477 | 284 | 1.459716 | 4.14559344 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.6 | 4.15e-12 | NR | KAG9394237.1 | 201153 | g60025 | i0 | 37.9 | 9.95070422535211 | 87 | 53 | 91.9 | 1 | 278 | 18 | 1 | 86 | KAG9394237.1 WD domain, G-beta repeat [Carpediemonas membranifera] | diamond | 2826 | 72 | 0.994444444444444 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31897096 | 31897096 | PRJNA966993_P_NODE_8397_length_722_cov_2.417565_g7990_i0 | PRJNA966993 | 8397 | 722 | 2.417565 | 17.4548193 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.2 | 0.00198 | NR | ESU40394.1 | 5741 | g7990 | i0 | 33.6 | 3.53601108033241 | 113 | 64 | 47 | 4 | 661 | 323 | 228 | 329 | ESU40394.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 2553 | 51.6 | 0.992248062015504 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32175719 | 32175719 | PRJNA966993_P_NODE_101218_length_228_cov_4.967742_g100766_i0 | PRJNA966993 | 101218 | 228 | 4.967742 | 11.32645176 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 75.5 | 4.95e-14 | NR | KAG9392521.1 | 201153 | g100766 | i0 | 42.3 | 6.03947368421053 | 71 | 41 | 93.4 | 0 | 227 | 15 | 245 | 315 | KAG9392521.1 Papain family cysteine protease [Carpediemonas membranifera] | diamond | 1377 | 75.5 | 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);;