metadata: contig_metadata: 5 rows where bioproject = "PRJEB28062", tax_clade = "Metamonada" and tax

5 rows where bioproject = "PRJEB28062", tax_clade = "Metamonada" and tax_superkingdom = "Eukaryota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_order	tax_family	tax_genus	tax_species
7676917	7676917	PRJEB28062_P_NODE_38987_length_583_cov_44.029412_g36657_i0	PRJEB28062	38987	583	44.029412	256.69147196	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	800	0	NTclustered	gi\|2319615589\|ref\|XR_007835968.1\|	412133	g36657	i0	93.669	79.1921097770154	537	31	92	3	30	564	2602	2067	Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0033920), rRNA	blastn	46169	800	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
12778803	12778803	PRJEB28062_P_NODE_65031_length_430_cov_11.910364_g62670_i0	PRJEB28062	65031	430	11.910364	51.2145652	Giardia muris	5742	Fornicata	other_Eukaryota	715	0	NTclustered	gi\|9378\|emb\|X65063.1\|	5742	g62670	i0	99.744	70.7581395348837	391	0	91	1	24	414	2961	3350	G.muris ribosomal RNA operon DNA encoding 16S, 23S and 5.8S ribosomal RNA	blastn	30426	715	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
26684855	26684855	PRJEB28062_P_NODE_11381_length_1142_cov_45.537886_g9697_i0	PRJEB28062	11381	1142	45.537886	520.04265812	Giardia muris	5742	Fornicata	other_Eukaryota	362	2.6199999999999998e-110	NR	TNJ26563.1	5742	g9697	i0	89.7	0.509632224168126	194	18	50.4	1	607	32	1214	1407	TNJ26563.1 High cysteine membrane protein [Giardia muris]	diamond	582	362	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
30412651	30412651	PRJEB28062_P_NODE_101713_length_310_cov_1.299578_g99350_i0	PRJEB28062	101713	310	1.299578	4.0286918	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	61.2	2.42e-8	NR	XP_001303962.2	412133	g99350	i0	43.2	3.90967741935484	81	38	70.6	1	246	28	169	249	XP_001303962.2 glycine-rich protein family [Trichomonas vaginalis G3]	diamond	1212	61.2	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
31803049	31803049	PRJEB28062_P_NODE_133077_length_232_cov_12.333333_g130713_i0	PRJEB28062	133077	232	12.333333	28.61333256	Giardia muris	5742	Fornicata	other_Eukaryota	141	3.86e-37	NR	TNJ27684.1	5742	g130713	i0	100	0.866379310344828	67	0	86.6	0	25	225	627	693	TNJ27684.1 Glutamate-tRNA ligase [Giardia muris]	diamond	201	141	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris

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);;