metadata: contig_metadata: 6 rows where bioproject = "PRJNA980587", tax_clade = "Metamonada" and tax

6 rows where bioproject = "PRJNA980587", tax_clade = "Metamonada" and tax_phylum = "Fornicata"

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
29489192	29489192	PRJNA980587_P_NODE_45450_length_343_cov_1.018519_g44657_i0	PRJNA980587	45450	343	1.018519	3.49352017	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	117	1.48e-28	NR	KAG9394081.1	201153	g44657	i0	70.7	0.65597667638484	75	22	65.6	0	342	118	365	439	KAG9394081.1 DEAD/DEAH box helicase [Carpediemonas membranifera]	diamond	225	117	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
29842764	29842764	PRJNA980587_P_NODE_52271_length_317_cov_2.413934_g51478_i0	PRJNA980587	52271	317	2.413934	7.65217078	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	4.98e-24	NR	TNJ30284.1	5742	g51478	i0	48.1	2.95268138801262	104	53	98.4	1	314	3	62	164	TNJ30284.1 Ribosomal protein L7a [Giardia muris]	diamond	936	101	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
30790578	30790578	PRJNA980587_P_NODE_46254_length_339_cov_2.139098_g45461_i0	PRJNA980587	46254	339	2.139098	7.25154222	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	130	9.6e-37	NR	KAG9393782.1	201153	g45461	i0	64.4	3.71681415929204	104	36	92	1	8	319	1	103	KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera]	diamond	1260	130	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
30879229	30879229	PRJNA980587_P_NODE_62114_length_288_cov_1.190698_g61321_i0	PRJNA980587	62114	288	1.190698	3.42921024	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	94	6.38e-20	NR	KAG9391581.1	201153	g61321	i0	48.5	10.3541666666667	99	41	99	4	287	3	472	564	KAG9391581.1 serine/threonine-protein kinase WNK4 [Carpediemonas membranifera]	diamond	2982	94	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32687516	32687516	PRJNA980587_P_NODE_9920_length_884_cov_3.602959_g9254_i0	PRJNA980587	9920	884	3.602959	31.85015756	root	1	Root_unresolved	Root_unresolved	48.9	0.0225	NR	TNJ27286.1	5742	g9254	i0	30.1	2.60972850678733	176	104	57.4	8	799	293	319	482	TNJ27286.1 High cysteine membrane protein [Giardia muris]	diamond	2307	49.3	0.991886409736308	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
32901815	32901815	PRJNA980587_P_NODE_74920_length_258_cov_2.362162_g74127_i0	PRJNA980587	74920	258	2.362162	6.09437796	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	65.5	5.78e-11	NR	KAG9392754.1	201153	g74127	i0	41.6	0.895348837209302	77	40	89.5	1	3	233	92	163	KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera]	diamond	231	65.5	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);;