metadata: contig_metadata: 4 rows where bioproject = "PRJNA672101", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA672101", 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
28092417	28092417	PRJNA672101_S_NODE_3205_length_450_cov_7.058355_g3174_i0	PRJNA672101	3205	450	7.058355	31.7625975	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	70.1	7.43e-11	NR	KAL4429461.1	5901	g3174	i0	43.4	2.14	83	40	50.7	2	235	8	277	359	KAL4429461.1 hypothetical protein ABPG74_001306 [Tetrahymena malaccensis]	diamond	963	70.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
29398845	29398845	PRJNA672101_S_NODE_5949_length_392_cov_2.896552_g5918_i0	PRJNA672101	5949	392	2.896552	11.35448384	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	48.9	0.00126	NR	XP_004037229.1	5932	g5918	i0	67.6	0.818877551020408	37	12	28.3	0	297	187	419	455	XP_004037229.1 hypothetical protein IMG5_057980 [Ichthyophthirius multifiliis]	diamond	321	49.3	0.991886409736308	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
31041881	31041881	PRJNA672101_S_NODE_5515_length_399_cov_2.880368_g5484_i0	PRJNA672101	5515	399	2.880368	11.49266832	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	93.6	1.1e-20	NR	KRX10339.1	266149	g5484	i0	43.6	37.390977443609	101	50	72.2	2	105	392	10	108	KRX10339.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus]	diamond	14919	94.4	0.991525423728813	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
32326782	32326782	PRJNA672101_S_NODE_21299_length_279_cov_4.407767_g21268_i0	PRJNA672101	21299	279	4.407767	12.29766993	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	82	8.92e-16	NR	KRX00755.1	266149	g21268	i0	58.9	4.76344086021505	56	23	60.2	0	1	168	494	549	KRX00755.1 Ubiquitin-conjugating enzyme/RWD-like protein [Pseudocohnilembus persalinus]	diamond	1329	82	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus

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