metadata: contig_metadata: 8 rows where bioproject = "PRJEB14803" and tax

8 rows where bioproject = "PRJEB14803" 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
13739269	13739269	PRJEB14803_P_NODE_35371_length_178_cov_3.440559_g34905_i0	PRJEB14803	35371	178	3.440559	6.12419502	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	1.4500000000000002e-27	NTclustered	gi\|339759361\|dbj\|AB600293.1\|	658077	g34905	i0	83.803	63.2022471910112	142	23	80	0	1	142	583	724	Hicanonectes teleskopos gene for translation elongation factor 1 alpha, partial cds, strain: SB	blastn	11250	135	1	Eukaryota	Metamonada	Fornicata			Hicanonectes	Hicanonectes teleskopos
26684790	26684790	PRJEB14803_P_NODE_34421_length_182_cov_0.972789_g33955_i0	PRJEB14803	34421	182	0.972789	1.77047598	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	53.1	3.45e-6	NR	KAG9392546.1	201153	g33955	i0	44.6	0.923076923076923	56	31	92.3	0	182	15	191	246	KAG9392546.1 Rap/ran-GAP [Carpediemonas membranifera]	diamond	168	53.1	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
26709821	26709821	PRJEB14803_P_NODE_30221_length_197_cov_1.432099_g29755_i0	PRJEB14803	30221	197	1.432099	2.82123503	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	112	6.0100000000000005e-27	NR	CAK8817354.1	28002	g29755	i0	73.8	6.92893401015228	65	17	99	0	195	1	317	381	CAK8817354.1 HINF_007045 [Hexamita inflata]	diamond	1365	113	0.991150442477876	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
28233019	28233019	PRJEB14803_P_NODE_17026_length_288_cov_1.624506_g16560_i0	PRJEB14803	17026	288	1.624506	4.67857728	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	62.4	7.96e-9	NR	XP_067763548.1	348837	g16560	i0	38.8	0.885416666666667	85	49	88.5	2	21	275	217	298	XP_067763548.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida]	diamond	255	62.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
29306719	29306719	PRJEB14803_P_NODE_16869_length_290_cov_1.400000_g16403_i0	PRJEB14803	16869	290	1.4	4.06	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	48.1	8.05e-4	NR	EFO64479.1	658858	g16403	i0	41.5	0.548275862068966	53	31	54.8	0	285	127	110	162	EFO64479.1 Topoisomerase I-related protein [Giardia lamblia P15]	diamond	159	48.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29432776	29432776	PRJEB14803_P_NODE_21570_length_246_cov_1.943128_g21104_i0	PRJEB14803	21570	246	1.943128	4.78009488	Hexamita inflata	28002	Fornicata	other_Eukaryota	54.7	2.14e-6	NR	CAK8758084.1	28002	g21104	i0	50	1.17073170731707	48	24	58.5	0	201	58	254	301	CAK8758084.1 HINF_079860 [Hexamita inflata]	diamond	288	54.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
30349596	30349596	PRJEB14803_P_NODE_13412_length_336_cov_3.049834_g12947_i0	PRJEB14803	13412	336	3.049834	10.24744224	Hexamita inflata	28002	Fornicata	other_Eukaryota	54.7	7.1e-6	NR	CAK8749789.1	28002	g12947	i0	36	0.669642857142857	75	48	67	0	227	3	29	103	CAK8749789.1 HINF_079049 [Hexamita inflata]	diamond	225	54.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
30822974	30822974	PRJEB14803_P_NODE_11174_length_379_cov_1.909884_g10709_i0	PRJEB14803	11174	379	1.909884	7.23846036	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	67.8	2.92e-10	NR	KAG9391656.1	201153	g10709	i0	33.6	0.965699208443272	122	76	95.8	3	15	377	368	485	KAG9391656.1 Protein kinase domain [Carpediemonas membranifera]	diamond	366	67.8	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);;