contig_metadata
23 rows where bioproject = "PRJNA741997", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9649863 | 9649863 | PRJNA741997_P_NODE_31308_length_390_cov_1.889590_g30188_i0 | PRJNA741997 | 31308 | 390 | 1.88959 | 7.369401 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 200 | 1.26e-46 | NTclustered | gi|339759403|dbj|AB600315.1| | 797122 | g30188 | i0 | 77.876 | 35.1410256410256 | 339 | 63 | 85 | 10 | 24 | 356 | 1174 | 842 | Kipferlia bialata gene for translation elongation factor 2, partial cds, strain: NY0173 | blastn | 13705 | 200 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 12200668 | 12200668 | PRJNA741997_P_NODE_12290_length_705_cov_2.637658_g11233_i0 | PRJNA741997 | 12290 | 705 | 2.637658 | 18.5954889 | Ergobibamus cyprinoides | 926446 | Fornicata | other_Eukaryota | 462 | 2.75e-125 | NTclustered | gi|339759377|dbj|AB600301.1| | 926446 | g11233 | i0 | 79.669 | 90.0156028368794 | 664 | 118 | 93 | 14 | 51 | 705 | 1279 | 624 | Ergobibamus cyprinoides gene for beta-tubulin, partial cds, strain: CL | blastn | 63461 | 462 | 1 | Eukaryota | Metamonada | Fornicata | Ergobibamus | Ergobibamus cyprinoides | |||||
| 26767699 | 26767699 | PRJNA741997_P_NODE_1021_length_2300_cov_4.533004_g854_i0 | PRJNA741997 | 1021 | 2300 | 4.533004 | 104.259092 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 52.4 | 0.0123 | NR | GIQ80334.1 | 797122 | g854 | i0 | 27.3 | 0.267391304347826 | 205 | 129 | 24.4 | 7 | 1636 | 1076 | 719 | 921 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 615 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 26767721 | 26767721 | PRJNA741997_P_NODE_39141_length_347_cov_1.120438_g38021_i0 | PRJNA741997 | 39141 | 347 | 1.120438 | 3.88791986 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 55.1 | 4.45e-6 | NR | CAK8793668.1 | 28002 | g38021 | i0 | 47.9 | 0.414985590778098 | 48 | 25 | 41.5 | 0 | 62 | 205 | 65 | 112 | CAK8793668.1 HINF_078939 [Hexamita inflata] | diamond | 144 | 55.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27146915 | 27146915 | PRJNA741997_P_NODE_68742_length_258_cov_0.935135_g67622_i0 | PRJNA741997 | 68742 | 258 | 0.935135 | 2.4126483 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 71.6 | 2.06e-12 | NR | KAG9395917.1 | 201153 | g67622 | i0 | 42.4 | 0.988372093023256 | 85 | 48 | 97.7 | 1 | 256 | 5 | 246 | 330 | KAG9395917.1 Casein kinase II subunit alpha [Carpediemonas membranifera] | diamond | 255 | 71.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27273830 | 27273830 | PRJNA741997_P_NODE_55343_length_288_cov_1.432558_g54223_i0 | PRJNA741997 | 55343 | 288 | 1.432558 | 4.12576704 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 80.1 | 6.06e-16 | NR | CAK8803554.1 | 28002 | g54223 | i0 | 57.1 | 1.29166666666667 | 63 | 27 | 65.6 | 0 | 1 | 189 | 18 | 80 | CAK8803554.1 HINF_063621 [Hexamita inflata] | diamond | 372 | 80.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27463514 | 27463514 | PRJNA741997_P_NODE_61183_length_275_cov_1.524752_g60063_i0 | PRJNA741997 | 61183 | 275 | 1.524752 | 4.193068 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 140 | 2.759999999999999e-38 | NR | XP_067760658.1 | 348837 | g60063 | i0 | 71.4 | 0.992727272727273 | 91 | 26 | 99.3 | 0 | 273 | 1 | 10 | 100 | XP_067760658.1 Mitogen-activated protein kinase [Spironucleus salmonicida] | diamond | 273 | 140 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 27663071 | 27663071 | PRJNA741997_P_NODE_34104_length_372_cov_1.545151_g32984_i0 | PRJNA741997 | 34104 | 372 | 1.545151 | 5.74796172 | root | 1 | Root_unresolved | Root_unresolved | 161 | 2.7899999999999993e-43 | NR | KAG9394761.1 | 201153 | g32984 | i0 | 63.2 | 2 | 125 | 40 | 98.4 | 3 | 6 | 371 | 357 | 478 | KAG9394761.1 Methionyl/Leucyl tRNA synthetase [Carpediemonas membranifera] | diamond | 744 | 162 | 0.993827160493827 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27937109 | 27937109 | PRJNA741997_P_NODE_89485_length_241_cov_0.916667_g88365_i0 | PRJNA741997 | 89485 | 241 | 0.916667 | 2.20916747 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 56.6 | 4.58e-7 | NR | GIQ83316.1 | 797122 | g88365 | i0 | 49.1 | 0.659751037344398 | 53 | 27 | 66 | 0 | 73 | 231 | 81 | 133 | GIQ83316.1 hypothetical protein KIPB_004620 [Kipferlia bialata] | diamond | 159 | 56.6 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28000332 | 28000332 | PRJNA741997_P_NODE_45585_length_321_cov_1.552419_g44465_i0 | PRJNA741997 | 45585 | 321 | 1.552419 | 4.98326499 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 43.9 | 0.0361 | NR | ESU41386.1 | 5741 | g44465 | i0 | 50 | 0.429906542056075 | 46 | 20 | 43 | 2 | 318 | 181 | 506 | 548 | ESU41386.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 138 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28126462 | 28126462 | PRJNA741997_P_NODE_20865_length_499_cov_3.859155_g19748_i0 | PRJNA741997 | 20865 | 499 | 3.859155 | 19.25718345 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 63.9 | 2.25e-8 | NR | CAK8757278.1 | 28002 | g19748 | i0 | 31.6 | 1.14228456913828 | 95 | 65 | 57.1 | 0 | 423 | 139 | 628 | 722 | CAK8757278.1 HINF_008052 [Hexamita inflata] | diamond | 570 | 63.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29115394 | 29115394 | PRJNA741997_P_NODE_48728_length_310_cov_0.974684_g47608_i0 | PRJNA741997 | 48728 | 310 | 0.974684 | 3.0215204 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 0.00108 | NR | TNJ29401.1 | 5742 | g47608 | i0 | 46.2 | 1.35483870967742 | 52 | 20 | 46.5 | 2 | 190 | 47 | 918 | 965 | TNJ29401.1 High cysteine membrane protein [Giardia muris] | diamond | 420 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 29483802 | 29483802 | PRJNA741997_P_NODE_30610_length_395_cov_1.913043_g29490_i0 | PRJNA741997 | 30610 | 395 | 1.913043 | 7.55651985 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 67 | 6.06e-11 | NR | CAK8791145.1 | 28002 | g29490 | i0 | 35.3 | 1.74683544303797 | 116 | 61 | 88.1 | 4 | 348 | 1 | 33 | 134 | CAK8791145.1 HINF_096380 [Hexamita inflata] | diamond | 690 | 67 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29547045 | 29547045 | PRJNA741997_P_NODE_21710_length_487_cov_1.253623_g20592_i0 | PRJNA741997 | 21710 | 487 | 1.253623 | 6.10514401 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 100 | 2.11e-21 | NR | XP_067768571.1 | 348837 | g20592 | i0 | 44.5 | 0.677618069815195 | 110 | 60 | 67.1 | 1 | 13 | 339 | 3 | 112 | XP_067768571.1 Aspartate aminotransferase [Spironucleus salmonicida] | diamond | 330 | 100 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 29831400 | 29831400 | PRJNA741997_P_NODE_67771_length_260_cov_1.235294_g66651_i0 | PRJNA741997 | 67771 | 260 | 1.235294 | 3.2117644 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 75.1 | 1.92e-13 | NR | KAG9396651.1 | 201153 | g66651 | i0 | 48.2 | 0.957692307692308 | 83 | 40 | 93.5 | 2 | 244 | 2 | 326 | 407 | KAG9396651.1 DSHCT (NUC185) domain [Carpediemonas membranifera] | diamond | 249 | 75.1 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30557861 | 30557861 | PRJNA741997_P_NODE_59873_length_278_cov_1.502439_g58753_i0 | PRJNA741997 | 59873 | 278 | 1.502439 | 4.17678042 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 52 | 2.98e-5 | NR | ESU40199.1 | 5741 | g58753 | i0 | 37.5 | 1.48920863309353 | 80 | 42 | 77.7 | 3 | 43 | 258 | 28 | 107 | ESU40199.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 414 | 52 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31474751 | 31474751 | PRJNA741997_P_NODE_50656_length_303_cov_1.113043_g49536_i0 | PRJNA741997 | 50656 | 303 | 1.113043 | 3.37252029 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 52 | 4.44e-5 | NR | GKT34662.1 | 2918883 | g49536 | i0 | 46.7 | 1.20792079207921 | 60 | 31 | 59.4 | 1 | 220 | 41 | 2294 | 2352 | GKT34662.1 hypothetical protein ADUPG1_007974 [Aduncisulcus paluster] | diamond | 366 | 52 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 31569789 | 31569789 | PRJNA741997_P_NODE_85596_length_243_cov_0.905882_g84476_i0 | PRJNA741997 | 85596 | 243 | 0.905882 | 2.20129326 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 62.8 | 3.18e-9 | NR | CAK8776862.1 | 28002 | g84476 | i0 | 41.8 | 1.97530864197531 | 79 | 46 | 97.5 | 0 | 238 | 2 | 379 | 457 | CAK8776862.1 HINF_068007 [Hexamita inflata] | diamond | 480 | 62.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31790763 | 31790763 | PRJNA741997_P_NODE_66077_length_264_cov_1.209424_g64957_i0 | PRJNA741997 | 66077 | 264 | 1.209424 | 3.19287936 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 49.7 | 1.76e-4 | NR | CAK8813343.1 | 28002 | g64957 | i0 | 30.1 | 2.875 | 93 | 52 | 90.9 | 3 | 15 | 254 | 409 | 501 | CAK8813343.1 HINF_000064 [Hexamita inflata] | diamond | 759 | 49.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32202246 | 32202246 | PRJNA741997_P_NODE_3178_length_1531_cov_2.447188_g2752_i0 | PRJNA741997 | 3178 | 1531 | 2.447188 | 37.46644828 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 55.8 | 3.53e-4 | NR | ESU40389.1 | 5741 | g2752 | i0 | 39.5 | 0.864141084258654 | 81 | 34 | 15.5 | 3 | 411 | 175 | 127 | 194 | ESU40389.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 1323 | 55.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32234196 | 32234196 | PRJNA741997_P_NODE_90238_length_238_cov_2.927273_g89118_i0 | PRJNA741997 | 90238 | 238 | 2.927273 | 6.96690974 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 49.7 | 4.77e-5 | NR | AAK31249.1 | 5741 | g89118 | i0 | 32.3 | 0.781512605042017 | 62 | 40 | 75.6 | 1 | 181 | 2 | 29 | 90 | AAK31249.1 variable surface protein IVg, partial [Giardia intestinalis] | diamond | 186 | 49.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32654553 | 32654553 | PRJNA741997_P_NODE_1240_length_2160_cov_2.481073_g1052_i0 | PRJNA741997 | 1240 | 2160 | 2.481073 | 53.5911768 | root | 1 | Root_unresolved | Root_unresolved | 52 | 0.0148 | NR | GIQ80334.1 | 797122 | g1052 | i0 | 30.2 | 1.17083333333333 | 281 | 144 | 33.9 | 13 | 667 | 1398 | 1029 | 1294 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 2529 | 52 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32739418 | 32739418 | PRJNA741997_P_NODE_16520_length_580_cov_2.664694_g15414_i0 | PRJNA741997 | 16520 | 580 | 2.664694 | 15.4552252 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 76.6 | 1.58e-14 | NR | GIQ89704.1 | 797122 | g15414 | i0 | 47.9 | 0.367241379310345 | 71 | 37 | 36.7 | 0 | 215 | 3 | 20 | 90 | GIQ89704.1 ornithine decarboxylase, partial [Kipferlia bialata] | diamond | 213 | 76.6 | 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);;