metadata: contig_metadata: 9 rows where bioproject = "PRJNA575566", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA575566", 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
560293	560293	PRJNA575566_P_NODE_5821_length_434_cov_13.217158_g5624_i0	PRJNA575566	5821	434	13.217158	57.36246572	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	758	0	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g5624	i0	98.157	17.2327188940092	434	8	100	0	1	434	278	711	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	7479	758	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
1835294	1835294	PRJNA575566_P_NODE_10462_length_323_cov_1.667939_g10265_i0	PRJNA575566	10462	323	1.667939	5.38744297	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	588	1.8699999999999998e-163	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g10265	i0	99.385	100.842105263158	325	0	100	1	1	323	21	345	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	32572	588	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
1835366	1835366	PRJNA575566_P_NODE_15062_length_271_cov_3.352381_g14865_i0	PRJNA575566	15062	271	3.352381	9.08495251	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	305	1.73e-78	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g14865	i0	87.085	83.1254612546125	271	33	100	2	1	271	1581	1313	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	22527	305	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
3688081	3688081	PRJNA575566_P_NODE_19983_length_234_cov_3.699422_g19786_i0	PRJNA575566	19983	234	3.699422	8.65664748	Bodomorpha	188949	SAR_Eukaryotes	SAR_Eukaryotes	433	6.41e-117	NTclustered	gi\|225216798\|gb\|FJ176713.1\|	458884	g19786	i0	100	101.444444444444	234	0	100	0	1	234	351	118	Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence	blastn	23738	433	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
4387552	4387552	PRJNA575566_P_NODE_24524_length_209_cov_0.864865_g24327_i0	PRJNA575566	24524	209	0.864865	1.80756785	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	112	1.92e-29	NR	AAT09077.1	227086	g24327	i0	76.8	0.990430622009569	69	16	99	0	208	2	40	108	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	207	112	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
8212949	8212949	PRJNA575566_P_NODE_10387_length_324_cov_4.935361_g10190_i0	PRJNA575566	10387	324	4.935361	15.99056964	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	198	3.69e-46	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g10190	i0	79.048	26.3672839506173	315	47	97	11	12	324	4021	3724	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	8543	198	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
15862678	15862678	PRJNA575566_P_NODE_18373_length_245_cov_1.739130_g18176_i0	PRJNA575566	18373	245	1.73913	4.2608685	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	453	5.1900000000000006e-123	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g18176	i0	100	1	245	0	100	0	1	245	786	542	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	245	453	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
15862962	15862962	PRJNA575566_P_NODE_8813_length_352_cov_10.147766_g8616_i0	PRJNA575566	8813	352	10.147766	35.72013632	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	490	5.949999999999998e-134	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g8616	i0	99.627	99.3579545454545	268	1	76	0	85	352	1	268	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	34974	490	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
20962325	20962325	PRJNA575566_P_NODE_26637_length_205_cov_4.375000_g26440_i0	PRJNA575566	26637	205	4.375	8.96875	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	379	7.229999999999999e-101	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g26440	i0	100	101.10243902439	205	0	100	0	1	205	734	938	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	20726	379	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92

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