contig_metadata
13 rows where bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 523386 | 523386 | PRJNA556992_P_NODE_1131301_length_205_cov_9.090909_g1129110_i0 | PRJNA556992 | 1131301 | 205 | 9.090909 | 18.63636345 | root | 1 | Root_unresolved | Root_unresolved | 100 | 7.729999999999999e-23 | NR | CAK8761882.1 | 28002 | g1129110 | i0 | 77.9 | 2.98536585365854 | 68 | 14 | 99.5 | 1 | 2 | 205 | 32 | 98 | CAK8761882.1 HINF_004284 [Hexamita inflata] | diamond | 612 | 100 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 16430511 | 16430511 | PRJNA556992_P_NODE_860253_length_243_cov_0.905882_g858063_i0 | PRJNA556992 | 860253 | 243 | 0.905882 | 2.20129326 | Giardia | 5740 | Fornicata | other_Eukaryota | 390 | 4.089999999999999e-104 | NTclustered | gi|1940865969|ref|XR_005248676.1| | 5741 | g858063 | i0 | 95.885 | 11.1810699588477 | 243 | 7 | 100 | 1 | 1 | 243 | 1433 | 1672 | Giardia intestinalis 28S ribosomal RNA (GL50803_00r40029), partial rRNA | blastn | 2717 | 390 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 26888804 | 26888804 | PRJNA556992_P_NODE_240241_length_309_cov_3.415254_g238053_i0 | PRJNA556992 | 240241 | 309 | 3.415254 | 10.55313486 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 57.8 | 5.97e-8 | NR | GKT17674.1 | 2918883 | g238053 | i0 | 59.6 | 0.504854368932039 | 52 | 17 | 50.5 | 1 | 158 | 3 | 72 | 119 | GKT17674.1 hypothetical protein ADUPG1_004212, partial [Aduncisulcus paluster] | diamond | 156 | 57.8 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27725013 | 27725013 | PRJNA556992_P_NODE_1057064_length_223_cov_4.613333_g1054874_i0 | PRJNA556992 | 1057064 | 223 | 4.613333 | 10.28773259 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.1 | 0.0212 | NR | ESU43091.1 | 5741 | g1054874 | i0 | 42.4 | 2.48878923766816 | 59 | 32 | 79.4 | 1 | 5 | 181 | 214 | 270 | ESU43091.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 555 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28657672 | 28657672 | PRJNA556992_P_NODE_421427_length_274_cov_3.004975_g419238_i0 | PRJNA556992 | 421427 | 274 | 3.004975 | 8.2336315 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 48.5 | 4.66e-4 | NR | ESU44462.1 | 5741 | g419238 | i0 | 38 | 0.864963503649635 | 79 | 44 | 81 | 1 | 9 | 230 | 221 | 299 | ESU44462.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 237 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28672018 | 28672018 | PRJNA556992_P_NODE_272647_length_295_cov_4.963964_g270458_i0 | PRJNA556992 | 272647 | 295 | 4.963964 | 14.6436938 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 8.42e-6 | NR | GIQ87934.1 | 797122 | g270458 | i0 | 51.7 | 1.24067796610169 | 60 | 23 | 54.9 | 2 | 10 | 171 | 254 | 313 | GIQ87934.1 hypothetical protein KIPB_010079, partial [Kipferlia bialata] | diamond | 366 | 53.9 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29194294 | 29194294 | PRJNA556992_P_NODE_1171589_length_196_cov_15.699187_g1169398_i0 | PRJNA556992 | 1171589 | 196 | 15.699187 | 30.77040652 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 45.4 | 0.00228 | NR | KWX11092.1 | 1394984 | g1169398 | i0 | 55.3 | 1.68367346938776 | 38 | 16 | 58.2 | 1 | 145 | 32 | 564 | 600 | KWX11092.1 hypothetical protein QR46_4954 [Giardia intestinalis assemblage B] | diamond | 330 | 45.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29352588 | 29352588 | PRJNA556992_P_NODE_990549_length_231_cov_4.550633_g988359_i0 | PRJNA556992 | 990549 | 231 | 4.550633 | 10.51196223 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 42 | 0.0307 | NR | XP_067761641.1 | 348837 | g988359 | i0 | 32.3 | 0.805194805194805 | 62 | 41 | 79.2 | 1 | 191 | 9 | 8 | 69 | XP_067761641.1 Calmodulin [Spironucleus salmonicida] | diamond | 186 | 42 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 29762652 | 29762652 | PRJNA556992_P_NODE_702451_length_251_cov_1.398876_g700262_i0 | PRJNA556992 | 702451 | 251 | 1.398876 | 3.51117876 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 44.3 | 0.0119 | NR | ESU44555.1 | 5741 | g700262 | i0 | 50 | 0.454183266932271 | 38 | 19 | 45.4 | 0 | 210 | 97 | 636 | 673 | ESU44555.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 114 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30172992 | 30172992 | PRJNA556992_P_NODE_1038712_length_226_cov_4.790850_g1036522_i0 | PRJNA556992 | 1038712 | 226 | 4.79085 | 10.827321 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 55.1 | 1.3e-6 | NR | ESU42691.1 | 5741 | g1036522 | i0 | 47.6 | 0.836283185840708 | 63 | 26 | 83.6 | 2 | 12 | 200 | 214 | 269 | ESU42691.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 189 | 55.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30472175 | 30472175 | PRJNA556992_P_NODE_831293_length_244_cov_2.385965_g829103_i0 | PRJNA556992 | 831293 | 244 | 2.385965 | 5.8217546 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.1 | 9.04e-5 | NR | TNJ28267.1 | 5742 | g829103 | i0 | 48.3 | 3 | 60 | 28 | 73.8 | 3 | 6 | 185 | 181 | 237 | TNJ28267.1 Kinase, CAMK CAMKL [Giardia muris] | diamond | 732 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 31469391 | 31469391 | PRJNA556992_P_NODE_809896_length_245_cov_3.029070_g807706_i0 | PRJNA556992 | 809896 | 245 | 3.02907 | 7.4212215 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 67.4 | 7.84e-11 | NR | GIQ86879.1 | 797122 | g807706 | i0 | 37.5 | 2.93877551020408 | 80 | 50 | 98 | 0 | 6 | 245 | 212 | 291 | GIQ86879.1 hypothetical protein KIPB_008809 [Kipferlia bialata] | diamond | 720 | 67.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31912035 | 31912035 | PRJNA556992_P_NODE_768957_length_247_cov_4.258621_g766767_i0 | PRJNA556992 | 768957 | 247 | 4.258621 | 10.51879387 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 53.1 | 8.56e-6 | NR | KWX12983.1 | 1394984 | g766767 | i0 | 39.7 | 0.947368421052632 | 78 | 41 | 88.7 | 4 | 237 | 19 | 447 | 523 | KWX12983.1 High cysteine membrane protein Group 2/ Variant-specific surface protein [Giardia intestinalis assemblage B] | diamond | 234 | 53.1 | 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);;