contig_metadata
19 rows where bioproject = "PRJNA857143", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 843019 | 843019 | PRJNA857143_S_NODE_122501_length_290_cov_1.437788_g121408_i0 | PRJNA857143 | 122501 | 290 | 1.437788 | 4.1695852 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 62.1 | 4.46e-5 | NTclustered | gi|2794940331|ref|XM_067879464.1| | 2049356 | g121408 | i0 | 97.222 | 11.051724137931 | 36 | 1 | 12 | 0 | 148 | 183 | 5333 | 5298 | Monocercomonoides exilis uncharacterized protein (MONOS_9005), partial mRNA | blastn | 3205 | 62.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 2119075 | 2119075 | PRJNA857143_S_NODE_182902_length_247_cov_0.896552_g181809_i0 | PRJNA857143 | 182902 | 247 | 0.896552 | 2.21448344 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 62.1 | 3.71e-5 | NTclustered | gi|2794939566|ref|XM_067879796.1| | 2049356 | g181809 | i0 | 91.111 | 5.80161943319838 | 45 | 4 | 18 | 0 | 130 | 174 | 2718 | 2762 | Monocercomonoides exilis putative breast cancer 2 susceptibility protein (MONOS_9309), partial mRNA | blastn | 1433 | 62.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 22519604 | 22519604 | PRJNA857143_S_NODE_109698_length_302_cov_4.681223_g108605_i0 | PRJNA857143 | 109698 | 302 | 4.681223 | 14.13729346 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 65.8 | 3.61e-6 | NTclustered | gi|2794971734|ref|XM_067872030.1| | 2049356 | g108605 | i0 | 95.238 | 13.6754966887417 | 42 | 1 | 14 | 1 | 101 | 142 | 761 | 801 | Monocercomonoides exilis uncharacterized protein (MONOS_2130), partial mRNA | blastn | 4130 | 65.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27086762 | 27086762 | PRJNA857143_S_NODE_20862_length_523_cov_15.220000_g19780_i0 | PRJNA857143 | 20862 | 523 | 15.22 | 79.6006 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 94 | 2.7100000000000004e-21 | NR | KAJ4453711.1 | 342808 | g19780 | i0 | 57.7 | 0.636711281070746 | 111 | 39 | 59.1 | 2 | 502 | 194 | 3 | 113 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 333 | 94 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27402824 | 27402824 | PRJNA857143_S_NODE_118023_length_294_cov_2.054299_g116930_i0 | PRJNA857143 | 118023 | 294 | 2.054299 | 6.03963906 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 64.3 | 1.91e-9 | NR | XP_067727438.1 | 2049356 | g116930 | i0 | 41.8 | 1.37755102040816 | 67 | 35 | 68.4 | 1 | 294 | 94 | 3145 | 3207 | XP_067727438.1 putative Protein kinase domain [Monocercomonoides exilis] | diamond | 405 | 64.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27497521 | 27497521 | PRJNA857143_S_NODE_118323_length_294_cov_1.411765_g117230_i0 | PRJNA857143 | 118323 | 294 | 1.411765 | 4.1505891 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 63.9 | 2.5e-9 | NR | KAJ4460386.1 | 342808 | g117230 | i0 | 37 | 0.826530612244898 | 81 | 51 | 82.7 | 0 | 292 | 50 | 392 | 472 | KAJ4460386.1 putative Voltage-dependent L-type calcium channel subunit alpha-1C [Paratrimastix pyriformis] | diamond | 243 | 63.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27560405 | 27560405 | PRJNA857143_S_NODE_120564_length_292_cov_1.068493_g119471_i0 | PRJNA857143 | 120564 | 292 | 1.068493 | 3.11999956 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 64.7 | 1.28e-9 | NR | KAJ4460385.1 | 342808 | g119471 | i0 | 41.8 | 0.934931506849315 | 91 | 52 | 92.5 | 1 | 290 | 21 | 1572 | 1662 | KAJ4460385.1 putative Cathepsin D [Paratrimastix pyriformis] | diamond | 273 | 64.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27876282 | 27876282 | PRJNA857143_S_NODE_83165_length_334_cov_2.314176_g82072_i0 | PRJNA857143 | 83165 | 334 | 2.314176 | 7.72934784 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 55.8 | 2.19e-6 | NR | KAJ4458406.1 | 342808 | g82072 | i0 | 44.4 | 0.565868263473054 | 63 | 35 | 56.6 | 0 | 330 | 142 | 226 | 288 | KAJ4458406.1 putative AN1-type zinc finger protein 1 [Paratrimastix pyriformis] | diamond | 189 | 55.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28570884 | 28570884 | PRJNA857143_S_NODE_199427_length_231_cov_2.202532_g198334_i0 | PRJNA857143 | 199427 | 231 | 2.202532 | 5.08784892 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 53.5 | 5e-6 | NR | KAJ4461400.1 | 342808 | g198334 | i0 | 51.2 | 0.532467532467532 | 41 | 20 | 53.2 | 0 | 230 | 108 | 892 | 932 | KAJ4461400.1 putative E3 ubiquitin-protein ligase HECTD1 [Paratrimastix pyriformis] | diamond | 123 | 53.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30181390 | 30181390 | PRJNA857143_S_NODE_185152_length_246_cov_1.132948_g184059_i0 | PRJNA857143 | 185152 | 246 | 1.132948 | 2.78705208 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 71.6 | 2.62e-12 | NR | XP_067731676.1 | 2049356 | g184059 | i0 | 49.3 | 1.74390243902439 | 71 | 36 | 86.6 | 0 | 242 | 30 | 204 | 274 | XP_067731676.1 putative Protein kinase domain [Monocercomonoides exilis] | diamond | 429 | 71.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 30474134 | 30474134 | PRJNA857143_S_NODE_137953_length_276_cov_1.916256_g136860_i0 | PRJNA857143 | 137953 | 276 | 1.916256 | 5.28886656 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 2.71e-22 | NR | KAJ4455595.1 | 342808 | g136860 | i0 | 68.9 | 4.03260869565217 | 61 | 19 | 66.3 | 0 | 2 | 184 | 153 | 213 | KAJ4455595.1 putative 60S ribosomal protein L11 [Paratrimastix pyriformis] | diamond | 1113 | 100 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30568472 | 30568472 | PRJNA857143_S_NODE_102153_length_311_cov_0.983193_g101060_i0 | PRJNA857143 | 102153 | 311 | 0.983193 | 3.05773023 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 3.27e-24 | NR | KAA6402358.1 | 222440 | g101060 | i0 | 72.7 | 4.54340836012862 | 66 | 18 | 63.7 | 0 | 311 | 114 | 407 | 472 | KAA6402358.1 MAG: V-type H+-transporting ATPase subunit B [Streblomastix strix] | diamond | 1413 | 105 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31572211 | 31572211 | PRJNA857143_S_NODE_127696_length_285_cov_1.839623_g126603_i0 | PRJNA857143 | 127696 | 285 | 1.839623 | 5.24292555 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.5 | 5.88e-4 | NR | KAJ4461281.1 | 342808 | g126603 | i0 | 37.1 | 1.43157894736842 | 62 | 37 | 63.2 | 1 | 92 | 271 | 71 | 132 | KAJ4461281.1 hypothetical protein PAPYR_2317 [Paratrimastix pyriformis] | diamond | 408 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31706730 | 31706730 | PRJNA857143_S_NODE_131917_length_281_cov_2.519231_g130824_i0 | PRJNA857143 | 131917 | 281 | 2.519231 | 7.07903911 | root | 1 | Root_unresolved | Root_unresolved | 109 | 5.5e-27 | NR | KAJ4460957.1 | 342808 | g130824 | i0 | 58.5 | 1.7508896797153 | 82 | 34 | 87.5 | 0 | 1 | 246 | 192 | 273 | KAJ4460957.1 putative hydrolase; TatD family protein [Paratrimastix pyriformis] | diamond | 492 | 110 | 0.990909090909091 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31730113 | 31730113 | PRJNA857143_S_NODE_72497_length_350_cov_3.545126_g71404_i0 | PRJNA857143 | 72497 | 350 | 3.5451260000000002 | 12.407941 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 64.3 | 3.46e-9 | NR | KAJ4456371.1 | 342808 | g71404 | i0 | 64.4 | 0.385714285714286 | 45 | 16 | 38.6 | 0 | 348 | 214 | 612 | 656 | KAJ4456371.1 putative Histone deacetylase 6 [Paratrimastix pyriformis] | diamond | 135 | 64.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31824904 | 31824904 | PRJNA857143_S_NODE_151377_length_265_cov_3.427083_g150284_i0 | PRJNA857143 | 151377 | 265 | 3.427083 | 9.08176995 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.1 | 6.33e-4 | NR | KAJ4461400.1 | 342808 | g150284 | i0 | 29.5 | 0.690566037735849 | 61 | 43 | 69.1 | 0 | 259 | 77 | 876 | 936 | KAJ4461400.1 putative E3 ubiquitin-protein ligase HECTD1 [Paratrimastix pyriformis] | diamond | 183 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32141541 | 32141541 | PRJNA857143_S_NODE_92778_length_321_cov_9.528226_g91685_i0 | PRJNA857143 | 92778 | 321 | 9.528226 | 30.58560546 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 45.1 | 0.0093 | NR | XP_067732298.1 | 2049356 | g91685 | i0 | 47.7 | 0.411214953271028 | 44 | 20 | 38.3 | 1 | 320 | 198 | 62 | 105 | XP_067732298.1 uncharacterized protein MONOS_14261 [Monocercomonoides exilis] | diamond | 132 | 45.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32646975 | 32646975 | PRJNA857143_S_NODE_71200_length_352_cov_4.555556_g70107_i0 | PRJNA857143 | 71200 | 352 | 4.555556 | 16.03555712 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 137 | 5.96e-36 | NR | KAA6378089.1 | 222440 | g70107 | i0 | 75 | 13.4744318181818 | 88 | 19 | 75 | 1 | 2 | 265 | 345 | 429 | KAA6378089.1 MAG: Enolase [Streblomastix strix] | diamond | 4743 | 137 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32678543 | 32678543 | PRJNA857143_S_NODE_57980_length_377_cov_6.782895_g56887_i0 | PRJNA857143 | 57980 | 377 | 6.782895 | 25.57151415 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 49.3 | 5.15e-4 | NR | KAA6395684.1 | 222440 | g56887 | i0 | 39 | 0.61273209549071606 | 77 | 32 | 59.7 | 4 | 365 | 141 | 36 | 99 | KAA6395684.1 MAG: hypothetical protein EZS28_008787 [Streblomastix strix] | diamond | 231 | 49.3 | 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);;