contig_metadata
5 rows where bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26781454 | 26781454 | PRJNA1010662_P_NODE_1261_length_455_cov_2.610837_g1202_i0 | PRJNA1010662 | 1261 | 455 | 2.610837 | 11.87930835 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 60.1 | 3.47e-7 | NR | GIQ80339.1 | 797122 | g1202 | i0 | 31.9 | 0.784615384615385 | 119 | 72 | 72.5 | 2 | 39 | 368 | 2887 | 3005 | GIQ80339.1 hypothetical protein KIPB_001119, partial [Kipferlia bialata] | diamond | 357 | 60.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28574450 | 28574450 | PRJNA1010662_P_NODE_5087_length_238_cov_1.100529_g5028_i0 | PRJNA1010662 | 5087 | 238 | 1.100529 | 2.61925902 | Geminigeraceae | 589343 | Fornicata | other_Eukaryota | 45.1 | 0.00562 | NR | GIQ80339.1 | 797122 | g5028 | i0 | 60 | 1.32352941176471 | 30 | 12 | 37.8 | 0 | 238 | 149 | 2719 | 2748 | GIQ80339.1 hypothetical protein KIPB_001119, partial [Kipferlia bialata] | diamond | 315 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29971320 | 29971320 | PRJNA1010662_P_NODE_1431_length_426_cov_3.257294_g1372_i0 | PRJNA1010662 | 1431 | 426 | 3.257294 | 13.87607244 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 99.4 | 6.05e-22 | NR | KAG9391426.1 | 201153 | g1372 | i0 | 48.1 | 1.47183098591549 | 104 | 43 | 73.2 | 1 | 318 | 7 | 12 | 104 | KAG9391426.1 Hydrogenosomal membrane protein 31-like [Carpediemonas membranifera] | diamond | 627 | 99.4 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30445428 | 30445428 | PRJNA1010662_P_NODE_16073_length_163_cov_0.912281_g16014_i0 | PRJNA1010662 | 16073 | 163 | 0.912281 | 1.48701803 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 53.1 | 2.27e-7 | NR | GKT25222.1 | 2918883 | g16014 | i0 | 60.5 | 0.791411042944785 | 43 | 14 | 79.1 | 1 | 2 | 130 | 39 | 78 | GKT25222.1 Sdc1/DPY30 like protein [Aduncisulcus paluster] | diamond | 129 | 53.1 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 31488473 | 31488473 | PRJNA1010662_P_NODE_476_length_715_cov_2.352853_g426_i0 | PRJNA1010662 | 476 | 715 | 2.352853 | 16.82289895 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 214 | 4.26e-65 | NR | KAG9396194.1 | 201153 | g426 | i0 | 51.2 | 4.42657342657343 | 211 | 95 | 88.5 | 1 | 74 | 706 | 1 | 203 | KAG9396194.1 Ribosomal protein L10/acidic P0 [Carpediemonas membranifera] | diamond | 3165 | 214 | 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);;