contig_metadata
5 rows where bioproject = "PRJNA939415", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31067965 | 31067965 | PRJNA939415_P_NODE_87355_length_247_cov_5.057471_g86933_i0 | PRJNA939415 | 87355 | 247 | 5.057471 | 12.49195337 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 43.1 | 0.029 | NR | KAJ3423573.1 | 1746091 | g86933 | i0 | 38.2 | 3.30364372469636 | 68 | 36 | 78.9 | 3 | 6 | 200 | 751 | 815 | KAJ3423573.1 ccr4-not transcription complex [Anaeramoeba flamelloides] | diamond | 816 | 43.1 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 31162319 | 31162319 | PRJNA939415_P_NODE_93255_length_243_cov_0.905882_g92833_i0 | PRJNA939415 | 93255 | 243 | 0.905882 | 2.20129326 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 82.8 | 1.28e-16 | NR | XP_001307871.1 | 412133 | g92833 | i0 | 44.9 | 4.90123456790123 | 78 | 43 | 96.3 | 0 | 2 | 235 | 156 | 233 | XP_001307871.1 arginine omega-N asymmetric methyltransferase protein [Trichomonas vaginalis G3] | diamond | 1191 | 82.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31193746 | 31193746 | PRJNA939415_P_NODE_56235_length_277_cov_3.514706_g55813_i0 | PRJNA939415 | 56235 | 277 | 3.514706 | 9.73573562 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 48.5 | 5.39e-4 | NR | KAJ5079376.1 | 1746090 | g55813 | i0 | 33.8 | 0.833935018050541 | 77 | 42 | 73.6 | 1 | 2 | 205 | 1144 | 1220 | KAJ5079376.1 no mechanoreceptor potential c isoform d-related [Anaeramoeba ignava] | diamond | 231 | 48.5 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31794879 | 31794879 | PRJNA939415_P_NODE_69937_length_264_cov_1.492147_g69515_i0 | PRJNA939415 | 69937 | 264 | 1.492147 | 3.93926808 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 131 | 8.22e-35 | NR | KAJ3427686.1 | 1746091 | g69515 | i0 | 69 | 1.97727272727273 | 87 | 27 | 98.9 | 0 | 2 | 262 | 94 | 180 | KAJ3427686.1 ribosomal protein L5-RELATED [Anaeramoeba flamelloides] | diamond | 522 | 131 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 32624260 | 32624260 | PRJNA939415_P_NODE_71800_length_262_cov_2.169312_g71378_i0 | PRJNA939415 | 71800 | 262 | 2.169312 | 5.68359744 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 4.22e-9 | NR | KAK2962110.1 | 2049346 | g71378 | i0 | 33.7 | 4.94656488549618 | 86 | 57 | 98.5 | 0 | 261 | 4 | 413 | 498 | KAK2962110.1 putative DNA mismatch repair protein Msh2 [Blattamonas nauphoetae] | diamond | 1296 | 62.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae |
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);;