metadata: contig_metadata: 5 rows where bioproject = "PRJNA602115", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA602115", tax_clade = "Sar" and tax_phylum = "Ciliophora"

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_class	tax_order	tax_family	tax_genus	tax_species
26636698	26636698	PRJNA602115_P_NODE_9241_length_208_cov_0.870748_g9216_i0	PRJNA602115	9241	208	0.870748	1.81115584	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	68.2	2.54e-11	NR	KRX04630.1	266149	g9216	i0	55.4	0.9375	65	27	92.3	2	192	1	211	274	KRX04630.1 hypothetical protein PPERSA_04445 [Pseudocohnilembus persalinus]	diamond	195	68.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
27869474	27869474	PRJNA602115_P_NODE_7665_length_228_cov_1.353293_g7640_i0	PRJNA602115	7665	228	1.353293	3.08550804	Paramecium primaurelia	5886	SAR_Eukaryotes	SAR_Eukaryotes	89	7.22e-20	NR	CAD8053185.1	5886	g7640	i0	67.2	1.60526315789474	61	20	80.3	0	185	3	2	62	CAD8053185.1 unnamed protein product [Paramecium primaurelia]	diamond	366	89	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia
28564296	28564296	PRJNA602115_P_NODE_6027_length_259_cov_1.242424_g6002_i0	PRJNA602115	6027	259	1.242424	3.21787816	Tetrahymena utriculariae	2486642	SAR_Eukaryotes	SAR_Eukaryotes	97.8	9.9899999999999993e-24	NR	KAL4475992.1	2486642	g6002	i0	61.6	0.996138996138996	86	31	97.3	2	253	2	4	89	KAL4475992.1 hypothetical protein ABPG72_007878 [Tetrahymena utriculariae]	diamond	258	97.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena utriculariae
30333195	30333195	PRJNA602115_P_NODE_7432_length_232_cov_1.122807_g7407_i0	PRJNA602115	7432	232	1.1228070000000001	2.60491224	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0424	NR	CAD8213220.1	43137	g7407	i0	31.2	0.995689655172414	77	37	99.6	1	231	1	15	75	CAD8213220.1 unnamed protein product [Paramecium octaurelia]	diamond	231	42.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
31420433	31420433	PRJNA602115_P_NODE_10696_length_204_cov_0.895105_g10671_i0	PRJNA602115	10696	204	0.895105	1.8260142	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0165	NR	CAD8189747.1	43138	g10671	i0	39.6	1.44117647058824	53	28	76.5	2	158	3	999	1048	CAD8189747.1 unnamed protein product [Paramecium pentaurelia]	diamond	294	43.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium pentaurelia

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