contig_metadata
10 rows where bioproject = "PRJNA795983", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13533802 | 13533802 | PRJNA795983_S_NODE_34751_length_253_cov_6.250000_g34626_i0 | PRJNA795983 | 34751 | 253 | 6.25 | 15.8125 | Carpediemonas sp. NC | 797131 | Fornicata | other_Eukaryota | 276 | 1.2499999999999998e-69 | NTclustered | gi|339759391|dbj|AB600309.1| | 797131 | g34626 | i0 | 87.243 | 98.9683794466403 | 243 | 29 | 96 | 2 | 12 | 253 | 5 | 246 | Carpediemonas sp. NC gene for translation elongation factor 1 alpha, partial cds | blastn | 25039 | 276 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas sp. NC | |||||
| 27085498 | 27085498 | PRJNA795983_S_NODE_22182_length_297_cov_1.299107_g22057_i0 | PRJNA795983 | 22182 | 297 | 1.299107 | 3.85834779 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 45.8 | 0.00587 | NR | CAK8755281.1 | 28002 | g22057 | i0 | 34.2 | 0.767676767676768 | 76 | 45 | 74.7 | 2 | 76 | 297 | 395 | 467 | CAK8755281.1 HINF_072566 [Hexamita inflata] | diamond | 228 | 45.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29327390 | 29327390 | PRJNA795983_S_NODE_16829_length_325_cov_1.376984_g16704_i0 | PRJNA795983 | 16829 | 325 | 1.376984 | 4.475198 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 48.1 | 0.00115 | NR | ESU40462.1 | 5741 | g16704 | i0 | 48.3 | 1.66153846153846 | 58 | 22 | 46.2 | 2 | 297 | 148 | 226 | 283 | ESU40462.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 540 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30180119 | 30180119 | PRJNA795983_S_NODE_8592_length_410_cov_3.397626_g8467_i0 | PRJNA795983 | 8592 | 410 | 3.397626 | 13.9302666 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 136 | 9.9e-36 | NR | CAK8746233.1 | 28002 | g8467 | i0 | 50 | 1.87317073170732 | 128 | 64 | 93.7 | 0 | 26 | 409 | 3 | 130 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 768 | 136 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30590873 | 30590873 | PRJNA795983_S_NODE_33893_length_256_cov_1.442623_g33768_i0 | PRJNA795983 | 33893 | 256 | 1.442623 | 3.69311488 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 51.2 | 4.63e-5 | NR | XP_067766864.1 | 348837 | g33768 | i0 | 40.9 | 0.7734375 | 66 | 34 | 73.8 | 3 | 49 | 237 | 929 | 992 | XP_067766864.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 198 | 51.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 30875293 | 30875293 | PRJNA795983_S_NODE_24654_length_286_cov_1.769953_g24529_i0 | PRJNA795983 | 24654 | 286 | 1.769953 | 5.06206558 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 56.6 | 7.97e-7 | NR | TNJ26588.1 | 5742 | g24529 | i0 | 56.4 | 0.409090909090909 | 39 | 17 | 40.9 | 0 | 99 | 215 | 148 | 186 | TNJ26588.1 pVSP [Giardia muris] | diamond | 117 | 56.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 31168582 | 31168582 | PRJNA795983_S_NODE_23195_length_292_cov_3.283105_g23070_i0 | PRJNA795983 | 23195 | 292 | 3.283105 | 9.5866666 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94 | 2.93e-20 | NR | CAK8746233.1 | 28002 | g23070 | i0 | 58.8 | 3.92465753424658 | 85 | 35 | 87.3 | 0 | 5 | 259 | 150 | 234 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 1146 | 94.4 | 0.995762711864407 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32108571 | 32108571 | PRJNA795983_S_NODE_15778_length_332_cov_1.297297_g15653_i0 | PRJNA795983 | 15778 | 332 | 1.297297 | 4.30702604 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 104 | 1.9499999999999994e-23 | NR | CAK8776523.1 | 28002 | g15653 | i0 | 54.6 | 2.60240963855422 | 97 | 43 | 87.7 | 1 | 328 | 38 | 1210 | 1305 | CAK8776523.1 HINF_030324 [Hexamita inflata] | diamond | 864 | 104 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32740710 | 32740710 | PRJNA795983_S_NODE_22900_length_294_cov_1.244344_g22775_i0 | PRJNA795983 | 22900 | 294 | 1.244344 | 3.65837136 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 59.7 | 6.83e-8 | NR | ESU40462.1 | 5741 | g22775 | i0 | 52.6 | 0.581632653061224 | 57 | 21 | 52 | 2 | 2 | 154 | 227 | 283 | ESU40462.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 171 | 59.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32897840 | 32897840 | PRJNA795983_S_NODE_8120_length_419_cov_2.361272_g7995_i0 | PRJNA795983 | 8120 | 419 | 2.361272 | 9.89372968 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 55.1 | 1.19e-5 | NR | TNJ30320.1 | 5742 | g7995 | i0 | 47.4 | 1.40334128878282 | 57 | 27 | 40.8 | 2 | 3 | 173 | 36 | 89 | TNJ30320.1 VSP protein [Giardia muris] | diamond | 588 | 55.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris |
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);;