contig_metadata
10 rows where bioproject = "PRJNA560029" and tax_clade = "Metamonada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28910295 | 28910295 | PRJNA560029_S_NODE_9148_length_375_cov_2.731788_g8924_i0 | PRJNA560029 | 9148 | 375 | 2.731788 | 10.244205 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 83.2 | 1.21e-15 | NR | KAJ4456197.1 | 342808 | g8924 | i0 | 45 | 0.64 | 80 | 44 | 64 | 0 | 9 | 248 | 1922 | 2001 | KAJ4456197.1 putative Auxin transport protein BIG [Paratrimastix pyriformis] | diamond | 240 | 83.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29240368 | 29240368 | PRJNA560029_S_NODE_25369_length_278_cov_1.453659_g25145_i0 | PRJNA560029 | 25369 | 278 | 1.453659 | 4.04117202 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 2.28e-5 | NR | KAJ5066594.1 | 1746090 | g25145 | i0 | 47.5 | 0.906474820143885 | 40 | 21 | 43.2 | 0 | 1 | 120 | 556 | 595 | KAJ5066594.1 wd repeat-containing protein [Anaeramoeba ignava] | diamond | 252 | 52.8 | 0.992424242424242 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29984227 | 29984227 | PRJNA560029_S_NODE_15451_length_327_cov_6.704724_g15227_i0 | PRJNA560029 | 15451 | 327 | 6.704724 | 21.92444748 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 83.6 | 4.83e-16 | NR | KAJ5078559.1 | 1746090 | g15227 | i0 | 41.8 | 5.84403669724771 | 91 | 53 | 83.5 | 0 | 327 | 55 | 753 | 843 | KAJ5078559.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava] | diamond | 1911 | 83.6 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 30173688 | 30173688 | PRJNA560029_S_NODE_3652_length_478_cov_2.446914_g3429_i0 | PRJNA560029 | 3652 | 478 | 2.446914 | 11.69624892 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 121 | 1.42e-28 | NR | KAJ5066873.1 | 1746090 | g3429 | i0 | 54.8 | 3.26359832635983 | 104 | 47 | 65.3 | 0 | 4 | 315 | 1031 | 1134 | KAJ5066873.1 alpha-actinin [Anaeramoeba ignava] | diamond | 1560 | 121 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 30395337 | 30395337 | PRJNA560029_S_NODE_9353_length_373_cov_2.530000_g9129_i0 | PRJNA560029 | 9353 | 373 | 2.53 | 9.4369 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 61.6 | 3.94e-8 | NR | KAG9389819.1 | 201153 | g9129 | i0 | 45.5 | 1.06970509383378 | 66 | 34 | 52.3 | 2 | 368 | 174 | 885 | 949 | KAG9389819.1 dihydropyrimidine dehydrogenase [Carpediemonas membranifera] | diamond | 399 | 61.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30552766 | 30552766 | PRJNA560029_S_NODE_25033_length_279_cov_3.893204_g24809_i0 | PRJNA560029 | 25033 | 279 | 3.893204 | 10.86203916 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 44.3 | 0.0166 | NR | KAJ5080783.1 | 1746090 | g24809 | i0 | 69.2 | 0.548387096774194 | 26 | 8 | 28 | 0 | 254 | 177 | 970 | 995 | KAJ5080783.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 153 | 44.3 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31279579 | 31279579 | PRJNA560029_S_NODE_7175_length_398_cov_3.116923_g6951_i0 | PRJNA560029 | 7175 | 398 | 3.116923 | 12.40535354 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 68.9 | 1.45e-10 | NR | KAJ5078559.1 | 1746090 | g6951 | i0 | 49.3 | 1.51507537688442 | 67 | 34 | 50.5 | 0 | 397 | 197 | 777 | 843 | KAJ5078559.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava] | diamond | 603 | 68.9 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31659044 | 31659044 | PRJNA560029_S_NODE_19457_length_305_cov_6.081897_g19233_i0 | PRJNA560029 | 19457 | 305 | 6.081897 | 18.54978585 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 76.3 | 1.07e-13 | NR | KAJ5078011.1 | 1746090 | g19233 | i0 | 56.9 | 0.708196721311475 | 72 | 26 | 70.8 | 3 | 301 | 86 | 330 | 396 | KAJ5078011.1 arginine deiminase [Anaeramoeba ignava] | diamond | 216 | 76.3 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31659056 | 31659056 | PRJNA560029_S_NODE_8817_length_378_cov_4.488525_g8593_i0 | PRJNA560029 | 8817 | 378 | 4.488525 | 16.966624500000002 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 107 | 5.4499999999999996e-24 | NR | KAJ5076917.1 | 1746090 | g8593 | i0 | 43.8 | 8.01587301587302 | 112 | 63 | 88.9 | 0 | 378 | 43 | 884 | 995 | KAJ5076917.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 3030 | 107 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32545342 | 32545342 | PRJNA560029_S_NODE_18379_length_311_cov_1.983193_g18155_i0 | PRJNA560029 | 18379 | 311 | 1.983193 | 6.16773023 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 135 | 1.86e-37 | NR | XP_068364355.1 | 1144522 | g18155 | i0 | 69.6 | 0.983922829581994 | 102 | 31 | 98.4 | 0 | 307 | 2 | 91 | 192 | XP_068364355.1 60S ribosomal protein L16 [Tritrichomonas foetus] | diamond | 306 | 135 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus |
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);;