contig_metadata
15 rows where bioproject = "PRJNA1000943", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14173780 | 14173780 | PRJNA1000943_P_NODE_4412_length_376_cov_1.029703_g4275_i0 | PRJNA1000943 | 4412 | 376 | 1.029703 | 3.87168328 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 162 | 2.5399999999999993e-43 | NR | KAJ4460566.1 | 342808 | g4275 | i0 | 62.9 | 21.75 | 124 | 45 | 98.9 | 1 | 3 | 374 | 722 | 844 | KAJ4460566.1 putative 60S ribosomal protein L4-B [Paratrimastix pyriformis] | diamond | 8178 | 163 | 0.993865030674847 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27571480 | 27571480 | PRJNA1000943_P_NODE_15284_length_242_cov_0.923077_g15146_i0 | PRJNA1000943 | 15284 | 242 | 0.923077 | 2.23384634 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 64.7 | 6.6e-10 | NR | KAJ4460290.1 | 342808 | g15146 | i0 | 47 | 0.818181818181818 | 66 | 35 | 81.8 | 0 | 199 | 2 | 256 | 321 | KAJ4460290.1 putative Ubiquitin carboxyl-terminal hydrolase 14 [Paratrimastix pyriformis] | diamond | 198 | 64.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27666406 | 27666406 | PRJNA1000943_P_NODE_7824_length_295_cov_1.031532_g7686_i0 | PRJNA1000943 | 7824 | 295 | 1.031532 | 3.0430194 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 50.4 | 1.35e-4 | NR | KAJ4462627.1 | 342808 | g7686 | i0 | 52.6 | 0.84406779661017 | 38 | 18 | 38.6 | 0 | 295 | 182 | 145 | 182 | KAJ4462627.1 hypothetical protein PAPYR_622 [Paratrimastix pyriformis] | diamond | 249 | 50.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27698171 | 27698171 | PRJNA1000943_P_NODE_2684_length_468_cov_1.301266_g2547_i0 | PRJNA1000943 | 2684 | 468 | 1.301266 | 6.08992488 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 60.1 | 2.17e-7 | NR | KAJ4462876.1 | 342808 | g2547 | i0 | 32.4 | 0.653846153846154 | 102 | 59 | 59 | 3 | 41 | 316 | 115 | 216 | KAJ4462876.1 hypothetical protein PAPYR_83 [Paratrimastix pyriformis] | diamond | 306 | 60.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27981996 | 27981996 | PRJNA1000943_P_NODE_11565_length_252_cov_0.871508_g11427_i0 | PRJNA1000943 | 11565 | 252 | 0.871508 | 2.19620016 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 90.1 | 9.01e-19 | NR | KAJ4454688.1 | 342808 | g11427 | i0 | 52.6 | 1.85714285714286 | 78 | 35 | 92.9 | 1 | 18 | 251 | 843 | 918 | KAJ4454688.1 putative Protein EXPORTIN 1A [Paratrimastix pyriformis] | diamond | 468 | 90.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28487217 | 28487217 | PRJNA1000943_P_NODE_12627_length_249_cov_0.886364_g12489_i0 | PRJNA1000943 | 12627 | 249 | 0.886364 | 2.20704636 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 95.9 | 8.390000000000001e-21 | NR | KAJ4455439.1 | 342808 | g12489 | i0 | 48.2 | 8.59036144578313 | 83 | 43 | 100 | 0 | 1 | 249 | 388 | 470 | KAJ4455439.1 putative Thymus-specific serine protease [Paratrimastix pyriformis] | diamond | 2139 | 96.7 | 0.991726990692865 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28921664 | 28921664 | PRJNA1000943_P_NODE_12728_length_249_cov_0.886364_g12590_i0 | PRJNA1000943 | 12728 | 249 | 0.886364 | 2.20704636 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 5.01e-4 | NR | KAJ4459678.1 | 342808 | g12590 | i0 | 33.3 | 6.44578313253012 | 93 | 49 | 97.6 | 3 | 2 | 244 | 73 | 164 | KAJ4459678.1 putative S-adenosyl-L-methionine-dependent methyltransferases superfamily protein [Paratrimastix pyriformis] | diamond | 1605 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29024292 | 29024292 | PRJNA1000943_P_NODE_5528_length_341_cov_1.391791_g5390_i0 | PRJNA1000943 | 5528 | 341 | 1.391791 | 4.74600731 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 67.4 | 2.69e-10 | NR | KAJ4454715.1 | 342808 | g5390 | i0 | 55.8 | 0.457478005865103 | 52 | 23 | 45.7 | 0 | 307 | 152 | 188 | 239 | KAJ4454715.1 putative protein kinase [Paratrimastix pyriformis] | diamond | 156 | 67.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30097452 | 30097452 | PRJNA1000943_P_NODE_3132_length_436_cov_4.460055_g2995_i0 | PRJNA1000943 | 3132 | 436 | 4.460055 | 19.4458398 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 94 | 2.61e-21 | NR | KAK2944236.1 | 2049346 | g2995 | i0 | 43.1 | 1.59633027522936 | 116 | 58 | 79.1 | 4 | 45 | 389 | 19 | 127 | KAK2944236.1 hypothetical protein BLNAU_20846 [Blattamonas nauphoetae] | diamond | 696 | 94 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31045754 | 31045754 | PRJNA1000943_P_NODE_15835_length_233_cov_2.543750_g15697_i0 | PRJNA1000943 | 15835 | 233 | 2.54375 | 5.9269375 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 55.8 | 5.03e-7 | NR | KAK2962854.1 | 2049346 | g15697 | i0 | 52.9 | 0.656652360515021 | 51 | 23 | 64.4 | 1 | 166 | 17 | 36 | 86 | KAK2962854.1 hypothetical protein BLNAU_2289 [Blattamonas nauphoetae] | diamond | 153 | 55.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31551581 | 31551581 | PRJNA1000943_P_NODE_14176_length_245_cov_0.906977_g14038_i0 | PRJNA1000943 | 14176 | 245 | 0.906977 | 2.22209365 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 55.1 | 1.71e-6 | NR | KAJ4461644.1 | 342808 | g14038 | i0 | 41.7 | 0.587755102040816 | 48 | 28 | 58.8 | 0 | 60 | 203 | 320 | 367 | KAJ4461644.1 hypothetical protein PAPYR_1757 [Paratrimastix pyriformis] | diamond | 144 | 55.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31583132 | 31583132 | PRJNA1000943_P_NODE_7176_length_306_cov_1.141631_g7038_i0 | PRJNA1000943 | 7176 | 306 | 1.141631 | 3.49339086 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 125 | 5.5800000000000005e-33 | NR | XP_067718709.1 | 2049356 | g7038 | i0 | 60.6 | 11.9803921568627 | 94 | 37 | 92.2 | 0 | 282 | 1 | 1 | 94 | XP_067718709.1 putative 60S ribosomal protein L2 [Monocercomonoides exilis] | diamond | 3666 | 125 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31828421 | 31828421 | PRJNA1000943_P_NODE_6177_length_325_cov_1.857143_g6039_i0 | PRJNA1000943 | 6177 | 325 | 1.857143 | 6.03571475 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.3 | 4.78e-11 | NR | KAJ4454393.1 | 342808 | g6039 | i0 | 40.4 | 1.78153846153846 | 94 | 54 | 84.9 | 1 | 277 | 2 | 1363 | 1456 | KAJ4454393.1 putative Alpha-actinin A [Paratrimastix pyriformis] | diamond | 579 | 69.7 | 0.994261119081779 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31930800 | 31930800 | PRJNA1000943_P_NODE_15517_length_242_cov_0.923077_g15379_i0 | PRJNA1000943 | 15517 | 242 | 0.923077 | 2.23384634 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 103 | 1.6499999999999995e-23 | NR | KAK2959370.1 | 2049346 | g15379 | i0 | 58.8 | 3.90495867768595 | 80 | 33 | 99.2 | 0 | 3 | 242 | 150 | 229 | KAK2959370.1 putative T-complex protein 1 subunit theta [Blattamonas nauphoetae] | diamond | 945 | 103 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 32815575 | 32815575 | PRJNA1000943_P_NODE_10040_length_264_cov_1.607330_g9902_i0 | PRJNA1000943 | 10040 | 264 | 1.60733 | 4.2433512 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 45.4 | 0.00549 | NR | KAJ4461702.1 | 342808 | g9902 | i0 | 41.9 | 1.11363636363636 | 43 | 25 | 48.9 | 0 | 130 | 2 | 1119 | 1161 | KAJ4461702.1 putative Importin subunit alpha-1a [Paratrimastix pyriformis] | diamond | 294 | 45.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis |
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);;