contig_metadata
12 rows where bioproject = "PRJNA1204310", tax_clade = "Metamonada" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6707613 | 6707613 | PRJNA1204310_P_NODE_6986_length_653_cov_1.370690_g6703_i0 | PRJNA1204310 | 6986 | 653 | 1.37069 | 8.9506057 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 288 | 7.25e-93 | NR | KAG9395607.1 | 201153 | g6703 | i0 | 66.2 | 0.992343032159265 | 216 | 71 | 99.2 | 1 | 652 | 5 | 64 | 277 | KAG9395607.1 Enolase [Carpediemonas membranifera] | diamond | 648 | 288 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 7982159 | 7982159 | PRJNA1204310_P_NODE_13867_length_475_cov_3.723881_g13570_i0 | PRJNA1204310 | 13867 | 475 | 3.723881 | 17.68843475 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 166 | 5.3799999999999997e-48 | NR | GIQ79376.1 | 797122 | g13570 | i0 | 60.8 | 0.966315789473684 | 153 | 59 | 96.6 | 1 | 16 | 474 | 16 | 167 | GIQ79376.1 ribosomal protein L7, eukaryotic [Kipferlia bialata] | diamond | 459 | 166 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 18180654 | 18180654 | PRJNA1204310_P_NODE_29815_length_341_cov_0.869403_g29518_i0 | PRJNA1204310 | 29815 | 341 | 0.869403 | 2.96466423 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 177 | 5.93e-54 | NR | KAG9391952.1 | 201153 | g29518 | i0 | 75.5 | 18.782991202346 | 106 | 26 | 93.3 | 0 | 318 | 1 | 1 | 106 | KAG9391952.1 transcription factor IIB [Carpediemonas membranifera] | diamond | 6405 | 177 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27862178 | 27862178 | PRJNA1204310_P_NODE_33965_length_320_cov_1.894737_g33668_i0 | PRJNA1204310 | 33965 | 320 | 1.894737 | 6.0631584 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 132 | 1.87e-37 | NR | KAG9393782.1 | 201153 | g33668 | i0 | 66.3 | 1.846875 | 98 | 33 | 91.9 | 0 | 27 | 320 | 1 | 98 | KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera] | diamond | 591 | 132 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28083219 | 28083219 | PRJNA1204310_P_NODE_46685_length_269_cov_1.239796_g46388_i0 | PRJNA1204310 | 46685 | 269 | 1.239796 | 3.33505124 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 44.7 | 0.0106 | NR | CAK8780198.1 | 28002 | g46388 | i0 | 32.4 | 1.51672862453532 | 68 | 46 | 75.8 | 0 | 242 | 39 | 417 | 484 | CAK8780198.1 HINF_069409 [Hexamita inflata] | diamond | 408 | 44.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28714862 | 28714862 | PRJNA1204310_P_NODE_42547_length_284_cov_1.592417_g42250_i0 | PRJNA1204310 | 42547 | 284 | 1.592417 | 4.52246428 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 65.5 | 3.2e-10 | NR | GIQ83702.1 | 797122 | g42250 | i0 | 41.3 | 0.971830985915493 | 92 | 48 | 97.2 | 2 | 277 | 2 | 46 | 131 | GIQ83702.1 hypothetical protein KIPB_005059 [Kipferlia bialata] | diamond | 276 | 65.5 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29125531 | 29125531 | PRJNA1204310_P_NODE_46949_length_268_cov_1.200000_g46652_i0 | PRJNA1204310 | 46949 | 268 | 1.2 | 3.216 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 58.2 | 1.99e-7 | NR | GIQ81104.1 | 797122 | g46652 | i0 | 41 | 0.873134328358209 | 78 | 43 | 84 | 1 | 20 | 244 | 1743 | 1820 | GIQ81104.1 conserved hypothetical protein CHP02452 [Kipferlia bialata] | diamond | 234 | 58.2 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29788132 | 29788132 | PRJNA1204310_P_NODE_41631_length_287_cov_1.630841_g41334_i0 | PRJNA1204310 | 41631 | 287 | 1.630841 | 4.68051367 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 43.5 | 0.0338 | NR | KAG9392444.1 | 201153 | g41334 | i0 | 34.5 | 0.909407665505226 | 87 | 50 | 83.6 | 3 | 19 | 258 | 147 | 233 | KAG9392444.1 hypothetical protein J8273_5435 [Carpediemonas membranifera] | diamond | 261 | 43.5 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30357454 | 30357454 | PRJNA1204310_P_NODE_14492_length_466_cov_1.376590_g14195_i0 | PRJNA1204310 | 14492 | 466 | 1.37659 | 6.4149094 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 141 | 4.68e-36 | NR | GKT31530.1 | 2918883 | g14195 | i0 | 57 | 0.914163090128755 | 142 | 55 | 88.8 | 2 | 465 | 52 | 36 | 175 | GKT31530.1 Diphthamide synthesis DPH1/DPH2 like protein [Aduncisulcus paluster] | diamond | 426 | 141 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30451981 | 30451981 | PRJNA1204310_P_NODE_41013_length_289_cov_1.833333_g40716_i0 | PRJNA1204310 | 41013 | 289 | 1.833333 | 5.29833237 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 51.2 | 5.58e-5 | NR | GIQ88010.1 | 797122 | g40716 | i0 | 34.4 | 0.965397923875433 | 93 | 60 | 96.5 | 1 | 288 | 10 | 118 | 209 | GIQ88010.1 hypothetical protein KIPB_010167 [Kipferlia bialata] | diamond | 279 | 51.2 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30830842 | 30830842 | PRJNA1204310_P_NODE_25354_length_365_cov_5.695205_g25057_i0 | PRJNA1204310 | 25354 | 365 | 5.695205 | 20.78749825 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 78.6 | 1.36e-16 | NR | KAG9391114.1 | 201153 | g25057 | i0 | 69.4 | 1.53698630136986 | 62 | 18 | 50.1 | 1 | 29 | 211 | 1 | 62 | KAG9391114.1 ribosomal protein S30 [Carpediemonas membranifera] | diamond | 561 | 78.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31228715 | 31228715 | PRJNA1204310_P_NODE_37295_length_305_cov_1.344828_g36998_i0 | PRJNA1204310 | 37295 | 305 | 1.344828 | 4.1017254 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 123 | 3.43e-34 | NR | KAG9393782.1 | 201153 | g36998 | i0 | 65.3 | 3.92459016393443 | 101 | 34 | 99.3 | 1 | 304 | 2 | 2 | 101 | KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera] | diamond | 1197 | 123 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera |
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);;