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

4 rows where bioproject = "PRJNA534016", 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
6221869	6221869	PRJNA534016_P_NODE_12585_length_259_cov_1.483871_g12495_i0	PRJNA534016	12585	259	1.483871	3.84322589	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	302	2.1200000000000002e-77	NTclustered	gi\|92790151\|emb\|AJ965261.1\|	47897	g12495	i0	87.938	194.644787644788	257	29	99	2	4	259	371	116	Isotricha intestinalis partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene)	blastn	50413	302	1	Eukaryota	Sar	Ciliophora	Litostomatea	Vestibuliferida	Isotrichidae	Isotricha	Isotricha intestinalis
13261232	13261232	PRJNA534016_P_NODE_1031_length_812_cov_6.081191_g954_i0	PRJNA534016	1031	812	6.081191	49.37927092	Tetrahymena pyriformis	5908	SAR_Eukaryotes	SAR_Eukaryotes	412	3.25e-110	NTclustered	gi\|10792\|emb\|X12768.1\|	5908	g954	i0	83.871	52.5911330049261	434	68	53	2	1	433	1018	1450	Tetrahymena pyriformis beta-tubulin gene 1 (beta-TT1)	blastn	42704	412	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena pyriformis
13261429	13261429	PRJNA534016_P_NODE_7411_length_311_cov_1.361345_g7321_i0	PRJNA534016	7411	311	1.361345	4.23378295	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.029	NTclustered	gi\|471220273\|ref\|XM_004025160.1\|	5932	g7321	i0	100	0.090032154340836	28	0	9	0	167	194	263	236	Ichthyophthirius multifiliis ubiquitin- hect domain protein, putative (IMG5_189580) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
27661538	27661538	PRJNA534016_P_NODE_2324_length_539_cov_1.487124_g2235_i0	PRJNA534016	2324	539	1.487124	8.01559836	root	1	Root_unresolved	Root_unresolved	317	6.579999999999999e-107	NR	CAD8081379.1	5886	g2235	i0	94.9	31.469387755102	156	8	86.8	0	71	538	1	156	CAD8081379.1 unnamed protein product [Paramecium primaurelia]	diamond	16962	319	0.993730407523511	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia

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