contig_metadata
7 rows where bioproject = "PRJNA550047", tax_clade = "Metamonada" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5622094 | 5622094 | PRJNA550047_P_NODE_592265_length_200_cov_11.196850_g590292_i0 | PRJNA550047 | 592265 | 200 | 11.19685 | 22.3937 | Tritrichomonas muris | 5726 | Parabasalia | other_Eukaryota | 359 | 9.14e-95 | NTclustered | gi|62466089|gb|AY886846.1| | 5726 | g590292 | i0 | 99 | 99.765 | 200 | 2 | 100 | 0 | 1 | 200 | 1045 | 1244 | Tritrichomonas muris clone 1-6 16S-like ribosomal RNA gene, partial sequence | blastn | 19953 | 359 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas muris | |||
| 13875519 | 13875519 | PRJNA550047_P_NODE_44731_length_357_cov_1.866197_g42775_i0 | PRJNA550047 | 44731 | 357 | 1.866197 | 6.66232329 | Tritrichomonas | 5723 | Parabasalia | other_Eukaryota | 636 | 7.339999999999998e-178 | NTclustered | gi|62466089|gb|AY886846.1| | 5726 | g42775 | i0 | 99.429 | 98.8795518207283 | 350 | 2 | 98 | 0 | 8 | 357 | 1 | 350 | Tritrichomonas muris clone 1-6 16S-like ribosomal RNA gene, partial sequence | blastn | 35300 | 636 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas muris | |||
| 14546095 | 14546095 | PRJNA550047_P_NODE_495372_length_232_cov_5.402516_g493399_i0 | PRJNA550047 | 495372 | 232 | 5.402516 | 12.53383712 | Tritrichomonas augusta | 5725 | Parabasalia | other_Eukaryota | 283 | 6.76e-72 | NTclustered | gi|2274983416|gb|OP038912.1| | 5725 | g493399 | i0 | 93.264 | 43.9353448275862 | 193 | 11 | 82 | 2 | 42 | 232 | 162 | 354 | Tritrichomonas augusta isolate T1 large subunit ribosomal RNA gene, partial sequence | blastn | 10193 | 283 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas augusta | |||
| 19639464 | 19639464 | PRJNA550047_P_NODE_175496_length_345_cov_2.959559_g173536_i0 | PRJNA550047 | 175496 | 345 | 2.959559 | 10.21047855 | Tritrichomonas augusta | 5725 | Parabasalia | other_Eukaryota | 204 | 8.519999999999999e-48 | NTclustered | gi|2274983416|gb|OP038912.1| | 5725 | g173536 | i0 | 91.391 | 4.61159420289855 | 151 | 10 | 81 | 3 | 1 | 150 | 1187 | 1335 | Tritrichomonas augusta isolate T1 large subunit ribosomal RNA gene, partial sequence | blastn | 1591 | 204 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas augusta | |||
| 19641776 | 19641776 | PRJNA550047_P_NODE_362996_length_279_cov_23.834951_g361025_i0 | PRJNA550047 | 362996 | 279 | 23.834951 | 66.49951329 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 82.4 | 3.28e-11 | NTclustered | gi|124000930|ref|XM_001276885.1| | 412133 | g361025 | i0 | 89.394 | 9.49820788530466 | 66 | 5 | 23 | 2 | 21 | 85 | 145 | 209 | Trichomonas vaginalis G3 GTPase protein (TVAGG3_0992610), partial mRNA | blastn | 2650 | 82.4 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27172732 | 27172732 | PRJNA550047_P_NODE_461622_length_243_cov_9.200000_g459649_i0 | PRJNA550047 | 461622 | 243 | 9.2 | 22.356 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 79.7 | 3.53e-15 | NR | KAJ3427699.1 | 1746091 | g459649 | i0 | 45 | 0.987654320987654 | 80 | 44 | 98.8 | 0 | 241 | 2 | 458 | 537 | KAJ3427699.1 inter-alpha-trypsin inhibitor heavy chain family member [Anaeramoeba flamelloides] | diamond | 240 | 79.7 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 27850779 | 27850779 | PRJNA550047_P_NODE_521624_length_223_cov_9.053333_g519651_i0 | PRJNA550047 | 521624 | 223 | 9.053333 | 20.18893259 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0164 | NR | CAK8802789.1 | 28002 | g519651 | i0 | 55.6 | 1.30493273542601 | 36 | 16 | 48.4 | 0 | 221 | 114 | 36 | 71 | CAK8802789.1 HINF_057919 [Hexamita inflata] | diamond | 291 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata |
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);;