contig_metadata
13 rows where bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4752441 | 4752441 | PRJNA944406_P_NODE_10044_length_393_cov_2.353125_g9085_i0 | PRJNA944406 | 10044 | 393 | 2.353125 | 9.24778125 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 473 | 6.769999999999999e-129 | NTclustered | gi|2319615589|ref|XR_007835968.1| | 412133 | g9085 | i0 | 90.358 | 18.2875318066158 | 363 | 31 | 92 | 4 | 28 | 389 | 1248 | 889 | Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0033920), rRNA | blastn | 7187 | 473 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 4752891 | 4752891 | PRJNA944406_P_NODE_38144_length_274_cov_1.532338_g37185_i0 | PRJNA944406 | 38144 | 274 | 1.532338 | 4.19860612 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|123478648|ref|XM_001322451.1| | 412133 | g37185 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 221 | 248 | 279 | 306 | Trichomonas vaginalis G3 regulation of centriole replication (TVAGG3_0958720), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 9853081 | 9853081 | PRJNA944406_P_NODE_9388_length_406_cov_0.924925_g8429_i0 | PRJNA944406 | 9388 | 406 | 0.924925 | 3.7551955 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 693 | 0 | NTclustered | gi|2319615589|ref|XR_007835968.1| | 412133 | g8429 | i0 | 97.537 | 76.7315270935961 | 406 | 9 | 100 | 1 | 1 | 406 | 2559 | 2155 | Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0033920), rRNA | blastn | 31153 | 693 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 11128189 | 11128189 | PRJNA944406_P_NODE_41529_length_271_cov_1.510101_g40570_i0 | PRJNA944406 | 41529 | 271 | 1.510101 | 4.09237371 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 71.2 | 3.99e-12 | NR | KAJ5072673.1 | 1746090 | g40570 | i0 | 72.3 | 3.70848708487085 | 47 | 13 | 52 | 0 | 127 | 267 | 2 | 48 | KAJ5072673.1 nad-dependent epimerase/dehydratase [Anaeramoeba ignava] | diamond | 1005 | 71.2 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 14013420 | 14013420 | PRJNA944406_P_NODE_43811_length_269_cov_1.382653_g42852_i0 | PRJNA944406 | 43811 | 269 | 1.382653 | 3.71933657 | Giardia | 5740 | Fornicata | other_Eukaryota | 497 | 2.63e-136 | NTclustered | gi|1940865969|ref|XR_005248676.1| | 5741 | g42852 | i0 | 100 | 11 | 269 | 0 | 100 | 0 | 1 | 269 | 836 | 1104 | Giardia intestinalis 28S ribosomal RNA (GL50803_00r40029), partial rRNA | blastn | 2959 | 497 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 17502954 | 17502954 | PRJNA944406_P_NODE_58454_length_255_cov_1.692308_g57495_i0 | PRJNA944406 | 58454 | 255 | 1.692308 | 4.3153854 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2806453984|ref|XM_068491875.1| | 1144522 | g57495 | i0 | 100 | 0.235294117647059 | 29 | 0 | 11 | 0 | 61 | 89 | 1563 | 1535 | Tritrichomonas foetus uncharacterized protein (TRFO_04403), partial mRNA | blastn | 60 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 21326488 | 21326488 | PRJNA944406_P_NODE_26317_length_285_cov_2.009434_g25358_i0 | PRJNA944406 | 26317 | 285 | 2.009434 | 5.7268869 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 412 | 1.0499999999999999e-110 | NTclustered | gi|2319615589|ref|XR_007835968.1| | 412133 | g25358 | i0 | 92.982 | 64.8350877192982 | 285 | 16 | 100 | 4 | 1 | 285 | 716 | 436 | Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0033920), rRNA | blastn | 18478 | 412 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 22602154 | 22602154 | PRJNA944406_P_NODE_9078_length_413_cov_2.035294_g8119_i0 | PRJNA944406 | 9078 | 413 | 2.035294 | 8.40576422 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 713 | 0 | NTclustered | gi|2319615589|ref|XR_007835968.1| | 412133 | g8119 | i0 | 97.821 | 35.452784503632 | 413 | 9 | 100 | 0 | 1 | 413 | 1473 | 1885 | Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0033920), rRNA | blastn | 14642 | 713 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27972937 | 27972937 | PRJNA944406_P_NODE_35085_length_277_cov_1.509804_g34126_i0 | PRJNA944406 | 35085 | 277 | 1.509804 | 4.18215708 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 53.5 | 3.32e-6 | NR | KAJ4457922.1 | 342808 | g34126 | i0 | 36.7 | 0.649819494584838 | 60 | 38 | 65 | 0 | 276 | 97 | 114 | 173 | KAJ4457922.1 putative integral membrane protein [Paratrimastix pyriformis] | diamond | 180 | 53.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28478139 | 28478139 | PRJNA944406_P_NODE_28486_length_283_cov_1.828571_g27527_i0 | PRJNA944406 | 28486 | 283 | 1.828571 | 5.17485593 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 134 | 6.22e-35 | NR | KAJ5067249.1 | 1746090 | g27527 | i0 | 63.4 | 0.985865724381625 | 93 | 34 | 98.6 | 0 | 3 | 281 | 217 | 309 | KAJ5067249.1 coronin [Anaeramoeba ignava] | diamond | 279 | 134 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31953412 | 31953412 | PRJNA944406_P_NODE_41077_length_271_cov_2.171717_g40118_i0 | PRJNA944406 | 41077 | 271 | 2.171717 | 5.88535307 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 79.3 | 6.87e-15 | NR | KAJ5077328.1 | 1746090 | g40118 | i0 | 43.8 | 0.985239852398524 | 89 | 49 | 98.5 | 1 | 3 | 269 | 644 | 731 | KAJ5077328.1 hypothetical protein M0811_05850 [Anaeramoeba ignava] | diamond | 267 | 79.3 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32491594 | 32491594 | PRJNA944406_P_NODE_95619_length_244_cov_0.900585_g94660_i0 | PRJNA944406 | 95619 | 244 | 0.900585 | 2.1974274 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 58.5 | 1.02e-7 | NR | KAJ5076984.1 | 1746090 | g94660 | i0 | 35.4 | 0.971311475409836 | 79 | 48 | 97.1 | 2 | 244 | 8 | 336 | 411 | KAJ5076984.1 hypothetical protein M0811_00304 [Anaeramoeba ignava] | diamond | 237 | 58.5 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32648894 | 32648894 | PRJNA944406_P_NODE_86480_length_246_cov_0.890173_g85521_i0 | PRJNA944406 | 86480 | 246 | 0.890173 | 2.18982558 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 49.3 | 1.92e-4 | NR | KAG9394630.1 | 201153 | g85521 | i0 | 44.4 | 0.548780487804878 | 45 | 20 | 48.8 | 1 | 29 | 148 | 809 | 853 | KAG9394630.1 Periplasmic binding protein [Carpediemonas membranifera] | diamond | 135 | 49.3 | 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);;