contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA796639" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4608859 | 4608859 | PRJNA796639_P_NODE_1884_length_408_cov_1.376119_g1759_i0 | PRJNA796639 | 1884 | 408 | 1.376119 | 5.61456552 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 241 | 2.57e-76 | NR | XP_067718893.1 | 2049356 | g1759 | i0 | 86.7 | 0.992647058823529 | 135 | 18 | 99.3 | 0 | 3 | 407 | 201 | 335 | XP_067718893.1 conventional actin [Monocercomonoides exilis] | diamond | 405 | 241 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 4608911 | 4608911 | PRJNA796639_P_NODE_7324_length_243_cov_0.905882_g7199_i0 | PRJNA796639 | 7324 | 243 | 0.905882 | 2.20129326 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 114 | 1.7300000000000003e-27 | NR | XP_067729163.1 | 2049356 | g7199 | i0 | 70 | 0.987654320987654 | 80 | 24 | 98.8 | 0 | 243 | 4 | 518 | 597 | XP_067729163.1 putative cytosolic heat shock 70 protein [Monocercomonoides exilis] | diamond | 240 | 114 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 19907351 | 19907351 | PRJNA796639_P_NODE_6816_length_246_cov_0.890173_g6691_i0 | PRJNA796639 | 6816 | 246 | 0.890173 | 2.18982558 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 146 | 1.14e-38 | NR | XP_067729693.1 | 2049356 | g6691 | i0 | 81.5 | 1.96341463414634 | 81 | 15 | 98.8 | 0 | 245 | 3 | 167 | 247 | XP_067729693.1 starch phosphorylase [Monocercomonoides exilis] | diamond | 483 | 146 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 20343067 | 20343067 | PRJNA796639_P_NODE_2276_length_371_cov_1.050336_g2151_i0 | PRJNA796639 | 2276 | 371 | 1.050336 | 3.89674656 | Polymastigidae | 302780 | Preaxostyla | other_Eukaryota | 213 | 1.11e-65 | NR | KAK2957160.1 | 2049346 | g2151 | i0 | 87.2 | 1.8921832884097 | 117 | 15 | 94.6 | 0 | 2 | 352 | 260 | 376 | KAK2957160.1 putative Actin [Blattamonas nauphoetae] | diamond | 702 | 213 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27180015 | 27180015 | PRJNA796639_P_NODE_6482_length_247_cov_0.885057_g6357_i0 | PRJNA796639 | 6482 | 247 | 0.885057 | 2.18609079 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 2.42e-6 | NR | XP_067723605.1 | 2049356 | g6357 | i0 | 50 | 0.607287449392713 | 50 | 25 | 60.7 | 0 | 91 | 240 | 299 | 348 | XP_067723605.1 putative NAK protein kinase [Monocercomonoides exilis] | diamond | 150 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27401630 | 27401630 | PRJNA796639_P_NODE_3863_length_289_cov_1.236111_g3738_i0 | PRJNA796639 | 3863 | 289 | 1.236111 | 3.57236079 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 57 | 1.44e-7 | NR | KAK2946320.1 | 2049346 | g3738 | i0 | 37.3 | 0.778546712802768 | 75 | 47 | 77.9 | 0 | 31 | 255 | 86 | 160 | KAK2946320.1 hypothetical protein BLNAU_18770 [Blattamonas nauphoetae] | diamond | 225 | 57 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27685999 | 27685999 | PRJNA796639_P_NODE_6244_length_248_cov_0.880000_g6119_i0 | PRJNA796639 | 6244 | 248 | 0.88 | 2.1824 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 125 | 2.68e-33 | NR | KAK2953328.1 | 2049346 | g6119 | i0 | 72 | 0.991935483870968 | 82 | 23 | 99.2 | 0 | 248 | 3 | 37 | 118 | KAK2953328.1 putative 40S ribosomal protein S1-B [Blattamonas nauphoetae] | diamond | 246 | 125 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27812188 | 27812188 | PRJNA796639_P_NODE_6344_length_248_cov_0.880000_g6219_i0 | PRJNA796639 | 6344 | 248 | 0.88 | 2.1824 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 92.8 | 2.62e-20 | NR | XP_067722001.1 | 2049356 | g6219 | i0 | 71 | 0.75 | 62 | 18 | 75 | 0 | 188 | 3 | 9 | 70 | XP_067722001.1 Cysteine synthase [Monocercomonoides exilis] | diamond | 186 | 92.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28190633 | 28190633 | PRJNA796639_P_NODE_6026_length_249_cov_0.875000_g5901_i0 | PRJNA796639 | 6026 | 249 | 0.875 | 2.17875 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 49.7 | 1.14e-4 | NR | XP_067733214.1 | 2049356 | g5901 | i0 | 45.5 | 0.530120481927711 | 44 | 24 | 53 | 0 | 118 | 249 | 2 | 45 | XP_067733214.1 putative SGS domain-containing protein [Monocercomonoides exilis] | diamond | 132 | 49.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 29705956 | 29705956 | PRJNA796639_P_NODE_3170_length_315_cov_1.272727_g3045_i0 | PRJNA796639 | 3170 | 315 | 1.272727 | 4.00909005 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 138 | 8.149999999999999e-40 | NR | KAK2961404.1 | 2049346 | g3045 | i0 | 66.3 | 1.98095238095238 | 104 | 35 | 99 | 0 | 314 | 3 | 1 | 104 | KAK2961404.1 putative profilin I [Blattamonas nauphoetae] | diamond | 624 | 138 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 29801010 | 29801010 | PRJNA796639_P_NODE_7531_length_242_cov_0.911243_g7406_i0 | PRJNA796639 | 7531 | 242 | 0.911243 | 2.20520806 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 76.6 | 4.34e-14 | NR | XP_067736311.1 | 2049356 | g7406 | i0 | 49.2 | 2.78925619834711 | 63 | 32 | 78.1 | 0 | 7 | 195 | 455 | 517 | XP_067736311.1 putative CoA-substrate-specific enzyme activase [Monocercomonoides exilis] | diamond | 675 | 76.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 29841847 | 29841847 | PRJNA796639_P_NODE_5571_length_251_cov_0.865169_g5446_i0 | PRJNA796639 | 5571 | 251 | 0.865169 | 2.17157419 | Oxymonadida | 66288 | Preaxostyla | other_Eukaryota | 159 | 9.64e-49 | NR | KAA6355689.1 | 222440 | g5446 | i0 | 91.3 | 2.90438247011952 | 80 | 7 | 95.6 | 0 | 11 | 250 | 9 | 88 | KAA6355689.1 MAG: putative Actin, partial [Streblomastix strix] | diamond | 729 | 160 | 0.99375 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30180125 | 30180125 | PRJNA796639_P_NODE_7812_length_241_cov_0.916667_g7687_i0 | PRJNA796639 | 7812 | 241 | 0.916667 | 2.20916747 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 92.8 | 8.48e-20 | NR | KAA6369919.1 | 222440 | g7687 | i0 | 59.7 | 0.95850622406639 | 77 | 30 | 94.6 | 1 | 1 | 228 | 365 | 441 | KAA6369919.1 MAG: putative protein kinase,serine/threonine-protein kinase [Streblomastix strix] | diamond | 231 | 92.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30275287 | 30275287 | PRJNA796639_P_NODE_3072_length_320_cov_0.935223_g2947_i0 | PRJNA796639 | 3072 | 320 | 0.935223 | 2.9927136 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 104 | 1.71e-25 | NR | XP_067729267.1 | 2049356 | g2947 | i0 | 56.1 | 0.91875 | 98 | 36 | 90.9 | 2 | 319 | 29 | 99 | 190 | XP_067729267.1 Rac2b, Rho family GTPase [Monocercomonoides exilis] | diamond | 294 | 104 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 30505363 | 30505363 | PRJNA796639_P_NODE_6693_length_246_cov_0.890173_g6568_i0 | PRJNA796639 | 6693 | 246 | 0.890173 | 2.18982558 | Polymastigidae | 302780 | Preaxostyla | other_Eukaryota | 71.6 | 2.55e-12 | NR | KAK2956029.1 | 2049346 | g6568 | i0 | 56.9 | 2.70731707317073 | 65 | 28 | 79.3 | 0 | 244 | 50 | 582 | 646 | KAK2956029.1 putative Heat shock protein 82 [Blattamonas nauphoetae] | diamond | 666 | 72 | 0.994444444444444 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31507751 | 31507751 | PRJNA796639_P_NODE_5996_length_249_cov_0.875000_g5871_i0 | PRJNA796639 | 5996 | 249 | 0.875 | 2.17875 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 92.8 | 5.5200000000000005e-22 | NR | XP_067721948.1 | 2049356 | g5871 | i0 | 61.4 | 0.843373493975904 | 70 | 26 | 84.3 | 1 | 25 | 234 | 4 | 72 | XP_067721948.1 cofilin/ADF [Monocercomonoides exilis] | diamond | 210 | 92.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31823722 | 31823722 | PRJNA796639_P_NODE_7817_length_241_cov_0.916667_g7692_i0 | PRJNA796639 | 7817 | 241 | 0.916667 | 2.20916747 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 46.6 | 0.00157 | NR | KAA6380552.1 | 222440 | g7692 | i0 | 27.6 | 0.946058091286307 | 76 | 50 | 88.4 | 1 | 25 | 237 | 362 | 437 | KAA6380552.1 MAG: putative group XV phospholipase A2 [Streblomastix strix] | diamond | 228 | 46.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31950303 | 31950303 | PRJNA796639_P_NODE_5577_length_251_cov_0.865169_g5452_i0 | PRJNA796639 | 5577 | 251 | 0.865169 | 2.17157419 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 117 | 2.18e-28 | NR | XP_067729721.1 | 2049356 | g5452 | i0 | 78 | 0.9800796812749 | 82 | 18 | 98 | 0 | 247 | 2 | 212 | 293 | XP_067729721.1 acetyl-CoA synthetase (ADP-forming) [Monocercomonoides exilis] | diamond | 246 | 117 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32076982 | 32076982 | PRJNA796639_P_NODE_7618_length_242_cov_0.911243_g7493_i0 | PRJNA796639 | 7618 | 242 | 0.911243 | 2.20520806 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 82 | 5.18e-16 | NR | XP_067726921.1 | 2049356 | g7493 | i0 | 59.3 | 0.731404958677686 | 59 | 24 | 73.1 | 0 | 240 | 64 | 111 | 169 | XP_067726921.1 putative OTU domain-containing protein [Monocercomonoides exilis] | diamond | 177 | 82 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32623641 | 32623641 | PRJNA796639_P_NODE_7800_length_241_cov_0.916667_g7675_i0 | PRJNA796639 | 7800 | 241 | 0.916667 | 2.20916747 | Oxymonadida | 66288 | Preaxostyla | other_Eukaryota | 80.9 | 1.3e-15 | NR | KAA6404369.1 | 222440 | g7675 | i0 | 53.2 | 1.9045643153527 | 79 | 36 | 98.3 | 1 | 239 | 3 | 7 | 84 | KAA6404369.1 MAG: hypothetical protein EZS28_000104 [Streblomastix strix] | diamond | 459 | 80.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix |
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);;