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

5 rows where bioproject = "PRJNA390533", 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
3628916	3628916	PRJNA390533_P_NODE_31443_length_237_cov_2.525253_g30416_i0	PRJNA390533	31443	237	2.525253	5.98484961	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	407	3.94e-109	NTclustered	gi\|1837628855\|gb\|MN158348.1\|	5909	g30416	i0	97.5	93.8649789029536	240	3	100	1	1	237	2737	2976	Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	22246	407	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena rostrata
16987088	16987088	PRJNA390533_P_NODE_22494_length_347_cov_3.516234_g21470_i0	PRJNA390533	22494	347	3.516234	12.20133198	Chilodonella piscicola	1654720	SAR_Eukaryotes	SAR_Eukaryotes	497	3.51e-136	NTclustered	gi\|1389430804\|gb\|MH341632.1\|	1654720	g21470	i0	95.779	34.6397694524496	308	13	89	0	40	347	19	326	Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence	blastn	12020	497	1	Eukaryota	Sar	Ciliophora	Phyllopharyngea	Chlamydodontida	Chilodonellidae	Chilodonella	Chilodonella piscicola
27106707	27106707	PRJNA390533_P_NODE_14982_length_481_cov_3.789593_g13987_i0	PRJNA390533	14982	481	3.789593	18.22794233	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	62.4	4.16e-8	NR	CDW91853.1	5949	g13987	i0	30.1	2.71309771309771	136	87	79.8	4	21	404	150	285	CDW91853.1 UNKNOWN [Stylonychia lemnae]	diamond	1305	62.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28243672	28243672	PRJNA390533_P_NODE_4946_length_865_cov_4.645278_g4327_i0	PRJNA390533	4946	865	4.645278	40.1816547	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	59.3	8.19e-7	NR	CDW86772.1	5949	g4327	i0	36.7	0.378034682080925	109	60	37.5	4	756	433	14	114	CDW86772.1 UNKNOWN [Stylonychia lemnae]	diamond	327	59.3	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29917432	29917432	PRJNA390533_P_NODE_28811_length_266_cov_2.488987_g27784_i0	PRJNA390533	28811	266	2.488987	6.62070542	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	98.2	2.1999999999999996e-24	NR	CAI2385228.1	5936	g27784	i0	48.8	0.969924812030075	86	44	97	0	3	260	19	104	CAI2385228.1 unnamed protein product [Moneuplotes crassus]	diamond	258	98.2	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus

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