contig_metadata
11 rows where bioproject = "PRJNA867519", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19974611 | 19974611 | PRJNA867519_P_NODE_14116_length_312_cov_1.552301_g13962_i0 | PRJNA867519 | 14116 | 312 | 1.552301 | 4.84317912 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 176 | 4.54e-50 | NR | GKT19677.1 | 2918883 | g13962 | i0 | 76.7 | 3.96153846153846 | 103 | 24 | 99 | 0 | 310 | 2 | 64 | 166 | GKT19677.1 Phenylalanine--tRNA ligase alpha subunit, partial [Aduncisulcus paluster] | diamond | 1236 | 176 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27252825 | 27252825 | PRJNA867519_P_NODE_23323_length_261_cov_1.287234_g23169_i0 | PRJNA867519 | 23323 | 261 | 1.287234 | 3.35968074 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 1.21e-4 | NR | TNJ26950.1 | 5742 | g23169 | i0 | 37.8 | 3.20689655172414 | 74 | 38 | 83.9 | 3 | 259 | 41 | 185 | 251 | TNJ26950.1 High cysteine membrane protein [Giardia muris] | diamond | 837 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 27276496 | 27276496 | PRJNA867519_P_NODE_20443_length_274_cov_1.149254_g20289_i0 | PRJNA867519 | 20443 | 274 | 1.149254 | 3.14895596 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 44.3 | 0.0148 | NR | ESU38557.1 | 5741 | g20289 | i0 | 54.1 | 2.24452554744526 | 37 | 16 | 40.5 | 1 | 50 | 160 | 32 | 67 | ESU38557.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 615 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29644164 | 29644164 | PRJNA867519_P_NODE_29770_length_246_cov_0.890173_g29616_i0 | PRJNA867519 | 29770 | 246 | 0.890173 | 2.18982558 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 44.3 | 0.0113 | NR | CAK8819608.1 | 28002 | g29616 | i0 | 36.5 | 0.768292682926829 | 63 | 38 | 75.6 | 2 | 17 | 202 | 438 | 499 | CAK8819608.1 HINF_033079 [Hexamita inflata] | diamond | 189 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30529011 | 30529011 | PRJNA867519_P_NODE_5933_length_445_cov_2.053763_g5779_i0 | PRJNA867519 | 5933 | 445 | 2.053763 | 9.13924535 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 110 | 6.309999999999999e-28 | NR | GKT25485.1 | 2918883 | g5779 | i0 | 45.1 | 4.44943820224719 | 133 | 69 | 89.7 | 1 | 5 | 403 | 2 | 130 | GKT25485.1 Ribosomal protein L14 like protein [Aduncisulcus paluster] | diamond | 1980 | 110 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30695127 | 30695127 | PRJNA867519_P_NODE_29893_length_246_cov_0.890173_g29739_i0 | PRJNA867519 | 29893 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52 | 2.12e-5 | NR | ESU42289.1 | 5741 | g29739 | i0 | 42.6 | 6.30487804878049 | 47 | 27 | 57.3 | 0 | 175 | 35 | 136 | 182 | ESU42289.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 1551 | 52 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31011079 | 31011079 | PRJNA867519_P_NODE_6234_length_436_cov_1.964187_g6080_i0 | PRJNA867519 | 6234 | 436 | 1.964187 | 8.56385532 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 4.409999999999999e-23 | NR | KAG9391426.1 | 201153 | g6080 | i0 | 47.3 | 1.54816513761468 | 112 | 48 | 77.1 | 1 | 338 | 3 | 12 | 112 | KAG9391426.1 Hydrogenosomal membrane protein 31-like [Carpediemonas membranifera] | diamond | 675 | 102 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31066457 | 31066457 | PRJNA867519_P_NODE_26175_length_250_cov_1.305085_g26021_i0 | PRJNA867519 | 26175 | 250 | 1.305085 | 3.2627125 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 42.7 | 0.037 | NR | XP_067762584.1 | 348837 | g26021 | i0 | 59.3 | 0.324 | 27 | 11 | 32.4 | 0 | 245 | 165 | 8 | 34 | XP_067762584.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 81 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31572309 | 31572309 | PRJNA867519_P_NODE_31476_length_244_cov_0.900585_g31322_i0 | PRJNA867519 | 31476 | 244 | 0.900585 | 2.1974274 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 74.3 | 8.9e-15 | NR | GKT23581.1 | 2918883 | g31322 | i0 | 46.1 | 0.934426229508197 | 76 | 40 | 93.4 | 1 | 15 | 242 | 6 | 80 | GKT23581.1 hypothetical protein ADUPG1_012472 [Aduncisulcus paluster] | diamond | 228 | 74.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 31580387 | 31580387 | PRJNA867519_P_NODE_23876_length_258_cov_1.664865_g23722_i0 | PRJNA867519 | 23876 | 258 | 1.664865 | 4.2953517 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.2 | 7.21e-8 | NR | KAG9393648.1 | 201153 | g23722 | i0 | 56.1 | 4.04651162790698 | 41 | 18 | 47.7 | 0 | 122 | 244 | 45 | 85 | KAG9393648.1 INO80 complex subunit C, INO80C [Carpediemonas membranifera] | diamond | 1044 | 56.2 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32394752 | 32394752 | PRJNA867519_P_NODE_12879_length_324_cov_1.840637_g12725_i0 | PRJNA867519 | 12879 | 324 | 1.840637 | 5.96366388 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 75.9 | 2.24e-13 | NR | KAG9389941.1 | 201153 | g12725 | i0 | 34.6 | 0.962962962962963 | 104 | 68 | 96.3 | 0 | 12 | 323 | 621 | 724 | KAG9389941.1 Protein kinase domain [Carpediemonas membranifera] | diamond | 312 | 75.9 | 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);;