contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3003208 | 3003208 | PRJNA492406_P_NODE_23063_length_268_cov_1.574359_g22764_i0 | PRJNA492406 | 23063 | 268 | 1.574359 | 4.21928212 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 106 | 2.4e-24 | NR | AAC35357.1 | 5755 | g22764 | i0 | 60 | 1.00746268656716 | 90 | 31 | 99.6 | 2 | 267 | 1 | 498 | 583 | AAC35357.1 Myosin-IA [Acanthamoeba castellanii] | diamond | 270 | 106 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14481448 | 14481448 | PRJNA492406_P_NODE_7872_length_432_cov_3.690808_g7573_i0 | PRJNA492406 | 7872 | 432 | 3.690808 | 15.94429056 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 162 | 1.3799999999999998e-48 | NR | 1PRQ_A | 5755 | g7573 | i0 | 66.4 | 1.73611111111111 | 125 | 42 | 86.8 | 0 | 406 | 32 | 1 | 125 | 1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii] | diamond | 750 | 162 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27234452 | 27234452 | PRJNA492406_P_NODE_28883_length_247_cov_0.885057_g28584_i0 | PRJNA492406 | 28883 | 247 | 0.885057 | 2.18609079 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 84.7 | 6.53e-17 | NR | XP_004334027.1 | 1257118 | g28584 | i0 | 48.2 | 1.0080971659919 | 83 | 42 | 99.6 | 1 | 1 | 246 | 525 | 607 | XP_004334027.1 alphaactinin, putative [Acanthamoeba castellanii str. Neff] | diamond | 249 | 84.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27455843 | 27455843 | PRJNA492406_P_NODE_9323_length_401_cov_7.088415_g9024_i0 | PRJNA492406 | 9323 | 401 | 7.088415 | 28.42454415 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 46.6 | 0.00128 | NR | XP_004351526.1 | 1257118 | g9024 | i0 | 46.9 | 0.366583541147132 | 49 | 26 | 36.7 | 0 | 401 | 255 | 26 | 74 | XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 147 | 46.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27518806 | 27518806 | PRJNA492406_P_NODE_24883_length_259_cov_1.607527_g24584_i0 | PRJNA492406 | 24883 | 259 | 1.607527 | 4.16349493 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 116 | 3.32e-28 | NR | XP_004345994.1 | 1257118 | g24584 | i0 | 52.9 | 0.984555984555985 | 85 | 40 | 98.5 | 0 | 2 | 256 | 197 | 281 | XP_004345994.1 phosphoesterase family protein [Acanthamoeba castellanii str. Neff] | diamond | 255 | 116 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27550231 | 27550231 | PRJNA492406_P_NODE_17464_length_299_cov_1.022124_g17165_i0 | PRJNA492406 | 17464 | 299 | 1.022124 | 3.05615076 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 135 | 5.08e-36 | NR | XP_004335206.1 | 1257118 | g17165 | i0 | 60.2 | 2.93979933110368 | 98 | 39 | 98.3 | 0 | 2 | 295 | 169 | 266 | XP_004335206.1 NAD-dependent epimerase/dehydratase family protein [Acanthamoeba castellanii str. Neff] | diamond | 879 | 135 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28087023 | 28087023 | PRJNA492406_P_NODE_31705_length_241_cov_2.452381_g31406_i0 | PRJNA492406 | 31705 | 241 | 2.452381 | 5.91023821 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 57.8 | 1.73e-7 | NR | XP_004334335.1 | 1257118 | g31406 | i0 | 45.2 | 1.91701244813278 | 73 | 38 | 90.9 | 2 | 231 | 13 | 265 | 335 | XP_004334335.1 actin related protein 2/3 complex, 41 kDa subunit [Acanthamoeba castellanii str. Neff] | diamond | 462 | 57.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28244807 | 28244807 | PRJNA492406_P_NODE_31826_length_241_cov_1.428571_g31527_i0 | PRJNA492406 | 31826 | 241 | 1.428571 | 3.44285611 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 70.9 | 4.09e-12 | NR | XP_004333080.1 | 1257118 | g31527 | i0 | 70.2 | 0.5850622406639 | 47 | 10 | 58.5 | 1 | 99 | 239 | 230 | 272 | XP_004333080.1 glucose repression mediator protein, partial [Acanthamoeba castellanii str. Neff] | diamond | 141 | 70.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28750169 | 28750169 | PRJNA492406_P_NODE_19447_length_286_cov_1.352113_g19148_i0 | PRJNA492406 | 19447 | 286 | 1.352113 | 3.86704318 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 113 | 4.5700000000000005e-27 | NR | XP_004339710.1 | 1257118 | g19148 | i0 | 55.9 | 0.975524475524476 | 93 | 38 | 95.5 | 2 | 274 | 2 | 288 | 379 | XP_004339710.1 rieske [2fe2s] domain containing protein, partial [Acanthamoeba castellanii str. Neff] | diamond | 279 | 113 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28939763 | 28939763 | PRJNA492406_P_NODE_29708_length_245_cov_1.366279_g29409_i0 | PRJNA492406 | 29708 | 245 | 1.366279 | 3.34738355 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 60.5 | 2.17e-8 | NR | XP_004340485.1 | 1257118 | g29409 | i0 | 46.2 | 0.795918367346939 | 65 | 34 | 79.6 | 1 | 209 | 15 | 474 | 537 | XP_004340485.1 SPRY domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 195 | 60.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29539391 | 29539391 | PRJNA492406_P_NODE_12330_length_355_cov_1.531915_g12031_i0 | PRJNA492406 | 12330 | 355 | 1.531915 | 5.43829825 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 58.9 | 2.88e-7 | NR | XP_004337378.1 | 1257118 | g12031 | i0 | 74.6 | 4.48732394366197 | 59 | 15 | 49.9 | 0 | 354 | 178 | 633 | 691 | XP_004337378.1 Major Vault Protein repeatcontaining protein [Acanthamoeba castellanii str. Neff] | diamond | 1593 | 58.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29823449 | 29823449 | PRJNA492406_P_NODE_16991_length_303_cov_2.382609_g16692_i0 | PRJNA492406 | 16991 | 303 | 2.382609 | 7.21930527 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 97.4 | 9.93e-22 | NR | XP_004336616.1 | 1257118 | g16692 | i0 | 51.1 | 0.871287128712871 | 88 | 43 | 87.1 | 0 | 7 | 270 | 190 | 277 | XP_004336616.1 ribosomal protein L10, putative [Acanthamoeba castellanii str. Neff] | diamond | 264 | 97.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30329707 | 30329707 | PRJNA492406_P_NODE_32832_length_227_cov_2.571429_g32533_i0 | PRJNA492406 | 32832 | 227 | 2.571429 | 5.83714383 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 59.7 | 2.73e-8 | NR | XP_004341419.1 | 1257118 | g32533 | i0 | 62.9 | 0.462555066079295 | 35 | 13 | 46.3 | 0 | 18 | 122 | 278 | 312 | XP_004341419.1 TolAlike protein [Acanthamoeba castellanii str. Neff] | diamond | 105 | 59.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30550266 | 30550266 | PRJNA492406_P_NODE_30533_length_244_cov_0.900585_g30234_i0 | PRJNA492406 | 30533 | 244 | 0.900585 | 2.1974274 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 147 | 3.78e-41 | NR | AFD36233.1 | 5755 | g30234 | i0 | 83.8 | 0.983606557377049 | 80 | 13 | 98.4 | 0 | 3 | 242 | 245 | 324 | AFD36233.1 protein kinase C4, partial [Acanthamoeba castellanii] | diamond | 240 | 147 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31546336 | 31546336 | PRJNA492406_P_NODE_29956_length_245_cov_0.895349_g29657_i0 | PRJNA492406 | 29956 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 117 | 2.64e-29 | NR | XP_004334335.1 | 1257118 | g29657 | i0 | 61.5 | 1.92244897959184 | 78 | 30 | 95.5 | 0 | 4 | 237 | 127 | 204 | XP_004334335.1 actin related protein 2/3 complex, 41 kDa subunit [Acanthamoeba castellanii str. Neff] | diamond | 471 | 118 | 0.991525423728814 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31877939 | 31877939 | PRJNA492406_P_NODE_24837_length_259_cov_1.930108_g24538_i0 | PRJNA492406 | 24837 | 259 | 1.930108 | 4.99897972 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 68.2 | 3.47e-11 | NR | XP_004341419.1 | 1257118 | g24538 | i0 | 85.7 | 1.45945945945946 | 42 | 6 | 48.6 | 0 | 3 | 128 | 201 | 242 | XP_004341419.1 TolAlike protein [Acanthamoeba castellanii str. Neff] | diamond | 378 | 68.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32321377 | 32321377 | PRJNA492406_P_NODE_21739_length_275_cov_1.376238_g21440_i0 | PRJNA492406 | 21739 | 275 | 1.376238 | 3.7846545 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 70.1 | 1.35e-11 | NR | XP_004339390.1 | 1257118 | g21440 | i0 | 79.5 | 1.85454545454545 | 39 | 8 | 42.5 | 0 | 252 | 136 | 38 | 76 | XP_004339390.1 UBA/TSN domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 510 | 70.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32668536 | 32668536 | PRJNA492406_P_NODE_30180_length_244_cov_1.520468_g29881_i0 | PRJNA492406 | 30180 | 244 | 1.520468 | 3.70994192 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 74.7 | 1.98e-13 | NR | XP_004339235.1 | 1257118 | g29881 | i0 | 44 | 0.922131147540984 | 75 | 42 | 92.2 | 0 | 239 | 15 | 242 | 316 | XP_004339235.1 Signal transducer and activator of transcription STAT family protein [Acanthamoeba castellanii str. Neff] | diamond | 225 | 74.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;