contig_metadata
4 rows where bioproject = "PRJNA800090", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27906672 | 27906672 | PRJNA800090_P_NODE_157565_length_249_cov_1.416667_g155380_i0 | PRJNA800090 | 157565 | 249 | 1.416667 | 3.52750083 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 129 | 2.51e-33 | NR | GIQ81592.1 | 797122 | g155380 | i0 | 72.5 | 0.963855421686747 | 80 | 22 | 96.4 | 0 | 247 | 8 | 312 | 391 | GIQ81592.1 hypothetical protein KIPB_002573 [Kipferlia bialata] | diamond | 240 | 129 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28128059 | 28128059 | PRJNA800090_P_NODE_122485_length_288_cov_2.000000_g120300_i0 | PRJNA800090 | 122485 | 288 | 2 | 5.76 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 82.8 | 2.58e-16 | NR | GKT22958.1 | 2918883 | g120300 | i0 | 49.4 | 0.864583333333333 | 83 | 40 | 84.4 | 1 | 266 | 24 | 1 | 83 | GKT22958.1 hypothetical protein ADUPG1_012278 [Aduncisulcus paluster] | diamond | 249 | 82.8 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30117138 | 30117138 | PRJNA800090_P_NODE_105412_length_315_cov_6.495935_g103227_i0 | PRJNA800090 | 105412 | 315 | 6.495935 | 20.46219525 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 57.4 | 3.11e-7 | NR | TNJ27030.1 | 5742 | g103227 | i0 | 40.5 | 1.61904761904762 | 84 | 48 | 80 | 2 | 53 | 304 | 136 | 217 | TNJ27030.1 Translation elongation factor 1-beta [Giardia muris] | diamond | 510 | 57.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 31539584 | 31539584 | PRJNA800090_P_NODE_192476_length_228_cov_0.918239_g190291_i0 | PRJNA800090 | 192476 | 228 | 0.918239 | 2.09358492 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 103 | 8.59e-24 | NR | KAG9393968.1 | 201153 | g190291 | i0 | 59.5 | 1.92105263157895 | 74 | 30 | 97.4 | 0 | 223 | 2 | 523 | 596 | KAG9393968.1 Zinc carboxypeptidase [Carpediemonas membranifera] | diamond | 438 | 103 | 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);;