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

5 rows where bioproject = "PRJNA934332", tax_clade = "Sar" and tax_phylum = "Cercozoa"

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
8563584	8563584	PRJNA934332_P_NODE_5267_length_290_cov_1.161290_g5180_i0	PRJNA934332	5267	290	1.16129	3.367741	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	405	1.79e-108	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g5180	i0	99.111	100.458620689655	225	2	78	0	66	290	1	225	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	29133	405	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
8563600	8563600	PRJNA934332_P_NODE_6647_length_266_cov_1.409326_g6560_i0	PRJNA934332	6647	266	1.409326	3.74880716	Paulinella chromatophora	39717	SAR_Eukaryotes	SAR_Eukaryotes	309	1.31e-79	NTclustered	gi\|224549833\|gb\|FJ456915.1\|	39717	g6560	i0	87.732	93.8195488721804	269	27	100	5	1	266	776	511	Paulinella chromatophora strain FK01 actin gene, partial cds	blastn	24956	309	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella chromatophora
27214437	27214437	PRJNA934332_P_NODE_3742_length_336_cov_1.171103_g3655_i0	PRJNA934332	3742	336	1.171103	3.93490608	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	124	2.2299999999999996e-31	NR	MES1907803.1	1215613	g3655	i0	60.8	0.866071428571429	97	33	86.6	3	45	335	20	111	MES1907803.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	291	124	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28351413	28351413	PRJNA934332_P_NODE_8286_length_249_cov_0.875000_g8199_i0	PRJNA934332	8286	249	0.875	2.17875	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	81.6	8.49e-16	NR	MES1907960.1	1215613	g8199	i0	51.9	0.975903614457831	81	32	97.6	1	246	4	812	885	MES1907960.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	243	81.6	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
32048101	32048101	PRJNA934332_P_NODE_2818_length_376_cov_0.993399_g2731_i0	PRJNA934332	2818	376	0.993399	3.73518024	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	197	1.56e-62	NR	ADK26622.1	323453	g2731	i0	82.3	0.901595744680851	113	20	90.2	0	342	4	1	113	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	339	197	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74

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