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

5 rows where bioproject = "PRJNA565778", 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
10762673	10762673	PRJNA565778_S_NODE_33949_length_187_cov_9.000000_g33653_i0	PRJNA565778	33949	187	9	16.83	Philasterides dicentrarchi	282688	SAR_Eukaryotes	SAR_Eukaryotes	235	1.4799999999999998e-57	NTclustered	gi\|49616744\|gb\|AY643504.1\|	282688	g33653	i0	90.857	93.7700534759358	175	16	94	0	1	175	301	127	Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence	blastn	17535	235	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Philasteridae	Philasterides	Philasterides dicentrarchi
10762777	10762777	PRJNA565778_S_NODE_43029_length_150_cov_3.840708_g42733_i0	PRJNA565778	43029	150	3.840708	5.761062	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	268	1.11e-67	NTclustered	gi\|194245783\|gb\|EU828456.1\|	5888	g42733	i0	98.684	95.2466666666667	152	0	100	1	1	150	3164	3013	Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence	blastn	14287	268	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
12037173	12037173	PRJNA565778_S_NODE_1550_length_725_cov_2.648256_g1443_i0	PRJNA565778	1550	725	2.648256	19.199856	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	346	9.689999999999998e-117	NR	CAD8176655.1	43137	g1443	i0	67.1	0.968275862068966	234	76	96.4	1	703	5	6	239	CAD8176655.1 unnamed protein product [Paramecium octaurelia]	diamond	702	346	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
31881000	31881000	PRJNA565778_S_NODE_15577_length_280_cov_3.473251_g15281_i0	PRJNA565778	15577	280	3.473251	9.7251028	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	68.6	2.99e-11	NR	KRX01349.1	266149	g15281	i0	50.9	5.11071428571429	53	26	56.8	0	39	197	240	292	KRX01349.1 hypothetical protein PPERSA_01252 [Pseudocohnilembus persalinus]	diamond	1431	68.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
32432860	32432860	PRJNA565778_S_NODE_26159_length_216_cov_2.787709_g25863_i0	PRJNA565778	26159	216	2.787709	6.02145144	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	75.1	9.98e-14	NR	YP_740803.1	5905	g25863	i0	63.5	4.33333333333333	52	19	72.2	0	41	196	330	381	YP_740803.1 NADH dehydrogenase subunit 4 [Tetrahymena paravorax]	diamond	936	75.5	0.994701986754967	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena paravorax

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