contig_metadata
20 rows where bioproject = "PRJNA1148190", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 292589 | 292589 | PRJNA1148190_P_NODE_227861_length_356_cov_1.784452_g216691_i0 | PRJNA1148190 | 227861 | 356 | 1.784452 | 6.35264912 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.034 | NTclustered | gi|2794954031|ref|XM_067870203.1| | 2049356 | g216691 | i0 | 100 | 0.0786516853932584 | 28 | 0 | 8 | 0 | 142 | 169 | 5458 | 5431 | Monocercomonoides exilis putative serine/threonine-protein kinase RIM15 (MONOS_17297), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 5393939 | 5393939 | PRJNA1148190_P_NODE_122645_length_476_cov_2.531017_g111482_i0 | PRJNA1148190 | 122645 | 476 | 2.531017 | 12.04764092 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.013 | NTclustered | gi|2794945261|ref|XM_067873713.1| | 2049356 | g111482 | i0 | 94.286 | 0.0735294117647059 | 35 | 2 | 7 | 0 | 359 | 393 | 3074 | 3108 | Monocercomonoides exilis uncharacterized protein (MONOS_3697), partial mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 14328004 | 14328004 | PRJNA1148190_P_NODE_691132_length_246_cov_0.890173_g679959_i0 | PRJNA1148190 | 691132 | 246 | 0.890173 | 2.18982558 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 58.4 | 4.78e-4 | NTclustered | gi|2794978939|ref|XM_067876309.1| | 2049356 | g679959 | i0 | 83.871 | 1.78861788617886 | 62 | 9 | 25 | 1 | 103 | 163 | 3604 | 3543 | Monocercomonoides exilis putative Signal recognition particle receptor FtsY (MONOS_6103fu6104), mRNA | blastn | 440 | 58.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 16871303 | 16871303 | PRJNA1148190_P_NODE_336334_length_305_cov_2.323276_g325161_i0 | PRJNA1148190 | 336334 | 305 | 2.323276 | 7.0859918 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2794958322|ref|XM_067872430.1| | 2049356 | g325161 | i0 | 100 | 0.095081967213114807 | 29 | 0 | 10 | 0 | 187 | 215 | 2620 | 2592 | Monocercomonoides exilis putative casein kinase I (MONOS_2505), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 21974496 | 21974496 | PRJNA1148190_P_NODE_589098_length_251_cov_0.865169_g577925_i0 | PRJNA1148190 | 589098 | 251 | 0.865169 | 2.17157419 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2794935522|ref|XM_067865254.1| | 2049356 | g577925 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 83 | 110 | 294 | 267 | Monocercomonoides exilis uncharacterized protein (MONOS_1262), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28007399 | 28007399 | PRJNA1148190_P_NODE_646585_length_248_cov_0.880000_g635412_i0 | PRJNA1148190 | 646585 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.2 | 6.31e-7 | NR | KAA6388207.1 | 222440 | g635412 | i0 | 35.5 | 5.08064516129032 | 76 | 46 | 91.9 | 1 | 17 | 244 | 153 | 225 | KAA6388207.1 MAG: putative aurora kinase [Streblomastix strix] | diamond | 1260 | 56.6 | 0.992932862190813 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28144870 | 28144870 | PRJNA1148190_P_NODE_20865_length_1773_cov_2.582353_g12645_i0 | PRJNA1148190 | 20865 | 1773 | 2.582353 | 45.78511869 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 76.3 | 1.89e-10 | NR | KAK2960350.1 | 2049346 | g12645 | i0 | 31.2 | 0.287648054145516 | 170 | 93 | 28.8 | 5 | 1320 | 811 | 128 | 273 | KAK2960350.1 putative G2-specific protein kinase nimA [Blattamonas nauphoetae] | diamond | 510 | 76.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28175951 | 28175951 | PRJNA1148190_P_NODE_174566_length_400_cov_0.795107_g163397_i0 | PRJNA1148190 | 174566 | 400 | 0.795107 | 3.180428 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 49.3 | 9.74e-4 | NR | KAJ4456648.1 | 342808 | g163397 | i0 | 29.4 | 0.8175 | 109 | 70 | 76.5 | 1 | 91 | 396 | 97 | 205 | KAJ4456648.1 hypothetical protein PAPYR_8039 [Paratrimastix pyriformis] | diamond | 327 | 49.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28176700 | 28176700 | PRJNA1148190_P_NODE_616466_length_249_cov_2.079545_g605293_i0 | PRJNA1148190 | 616466 | 249 | 2.079545 | 5.17806705 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 51.6 | 2.5e-5 | NR | KAJ4454942.1 | 342808 | g605293 | i0 | 35 | 0.963855421686747 | 80 | 48 | 91.6 | 1 | 9 | 236 | 116 | 195 | KAJ4454942.1 hypothetical protein PAPYR_10236 [Paratrimastix pyriformis] | diamond | 240 | 51.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28366324 | 28366324 | PRJNA1148190_P_NODE_687026_length_246_cov_0.890173_g675853_i0 | PRJNA1148190 | 687026 | 246 | 0.890173 | 2.18982558 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 45.8 | 0.00324 | NR | KAA6378602.1 | 222440 | g675853 | i0 | 38.8 | 0.817073170731707 | 67 | 32 | 80.5 | 3 | 34 | 231 | 154 | 212 | KAA6378602.1 MAG: putative Transposon Ty3-I Gag-Pol polyprotein, partial [Streblomastix strix] | diamond | 201 | 45.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28775857 | 28775857 | PRJNA1148190_P_NODE_100607_length_533_cov_1.236957_g89451_i0 | PRJNA1148190 | 100607 | 533 | 1.236957 | 6.59298081 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 84.3 | 2.4e-15 | NR | KAA6373452.1 | 222440 | g89451 | i0 | 31.3 | 1.02439024390244 | 182 | 101 | 92.3 | 3 | 531 | 40 | 299 | 474 | KAA6373452.1 MAG: putative E3 ubiquitin-protein ligase Nedd-4, partial [Streblomastix strix] | diamond | 546 | 84.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29175681 | 29175681 | PRJNA1148190_P_NODE_765989_length_242_cov_0.911243_g754816_i0 | PRJNA1148190 | 765989 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 66.2 | 1.95e-10 | NR | KAJ4462146.1 | 342808 | g754816 | i0 | 65.1 | 5.55371900826446 | 43 | 15 | 53.3 | 0 | 113 | 241 | 390 | 432 | KAJ4462146.1 putative Protein arginine N-methyltransferase 6 [Paratrimastix pyriformis] | diamond | 1344 | 66.6 | 0.993993993993994 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29218747 | 29218747 | PRJNA1148190_P_NODE_425429_length_281_cov_1.480769_g414256_i0 | PRJNA1148190 | 425429 | 281 | 1.480769 | 4.16096089 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 76.6 | 4.88e-14 | NR | KAA6403113.1 | 222440 | g414256 | i0 | 53.3 | 0.800711743772242 | 75 | 30 | 80.1 | 2 | 56 | 280 | 95 | 164 | KAA6403113.1 MAG: putative serine/threonine-protein kinase Nek1 [Streblomastix strix] | diamond | 225 | 76.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29439781 | 29439781 | PRJNA1148190_P_NODE_745070_length_243_cov_0.905882_g733897_i0 | PRJNA1148190 | 745070 | 243 | 0.905882 | 2.20129326 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 43.1 | 0.0268 | NR | KAA6399035.1 | 222440 | g733897 | i0 | 34.9 | 0.777777777777778 | 63 | 39 | 76.5 | 2 | 226 | 41 | 421 | 482 | KAA6399035.1 MAG: putative sulfite exporter TauE/SafE [Streblomastix strix] | diamond | 189 | 43.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30292226 | 30292226 | PRJNA1148190_P_NODE_125212_length_471_cov_1.859296_g114049_i0 | PRJNA1148190 | 125212 | 471 | 1.859296 | 8.75728416 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 62.4 | 6.4e-8 | NR | KAK2956118.1 | 2049346 | g114049 | i0 | 60.5 | 0.751592356687898 | 38 | 15 | 24.2 | 0 | 15 | 128 | 4868 | 4905 | KAK2956118.1 putative Dynein axonemal heavy chain 5 [Blattamonas nauphoetae] | diamond | 354 | 62.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 30608635 | 30608635 | PRJNA1148190_P_NODE_674173_length_246_cov_1.786127_g663000_i0 | PRJNA1148190 | 674173 | 246 | 1.786127 | 4.39387242 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 45.8 | 0.00327 | NR | XP_067724809.1 | 2049356 | g663000 | i0 | 44 | 0.609756097560976 | 50 | 28 | 61 | 0 | 180 | 31 | 272 | 321 | XP_067724809.1 uncharacterized protein MONOS_11584 [Monocercomonoides exilis] | diamond | 150 | 45.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 30627982 | 30627982 | PRJNA1148190_P_NODE_119873_length_482_cov_2.119804_g108710_i0 | PRJNA1148190 | 119873 | 482 | 2.119804 | 10.21745528 | root | 1 | Root_unresolved | Root_unresolved | 76.6 | 7.35e-13 | NR | KAA6404333.1 | 222440 | g108710 | i0 | 32.9 | 5.54564315352697 | 140 | 86 | 84.6 | 3 | 432 | 25 | 48 | 183 | KAA6404333.1 MAG: putative MAP kinase kinase family domain protein [Streblomastix strix] | diamond | 2673 | 76.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31556617 | 31556617 | PRJNA1148190_P_NODE_330496_length_308_cov_0.982979_g319323_i0 | PRJNA1148190 | 330496 | 308 | 0.982979 | 3.02757532 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 64.7 | 1.6e-9 | NR | XP_067734308.1 | 2049356 | g319323 | i0 | 51.4 | 1.4025974025974 | 72 | 26 | 69.2 | 3 | 214 | 2 | 182 | 245 | XP_067734308.1 putative phospholipid-transporting ATPase VD [Monocercomonoides exilis] | diamond | 432 | 64.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32410264 | 32410264 | PRJNA1148190_P_NODE_111599_length_502_cov_1.622378_g100438_i0 | PRJNA1148190 | 111599 | 502 | 1.622378 | 8.14433756 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 50.1 | 0.00131 | NR | XP_067725419.1 | 2049356 | g100438 | i0 | 29.1 | 5.67131474103586 | 103 | 69 | 61.6 | 1 | 346 | 38 | 17 | 115 | XP_067725419.1 Aurora kinase [Monocercomonoides exilis] | diamond | 2847 | 50.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32494258 | 32494258 | PRJNA1148190_P_NODE_545819_length_258_cov_1.135135_g534646_i0 | PRJNA1148190 | 545819 | 258 | 1.135135 | 2.9286483 | root | 1 | Root_unresolved | Root_unresolved | 124 | 1.31e-30 | NR | KAA6398486.1 | 222440 | g534646 | i0 | 77 | 8.03488372093023 | 87 | 19 | 100 | 1 | 1 | 258 | 958 | 1044 | KAA6398486.1 MAG: putative P-type ATPase [Streblomastix strix] | diamond | 2073 | 124 | 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);;