metadata: contig_metadata: 10 rows where bioproject = "PRJNA915212", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA915212", 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
2170542	2170542	PRJNA915212_P_NODE_3362_length_343_cov_1.918367_g3325_i0	PRJNA915212	3362	343	1.918367	6.57999881	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	276	1.77e-69	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g3325	i0	94.886	43.2069970845481	176	9	51	0	168	343	3839	3664	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	14820	276	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
9823017	9823017	PRJNA915212_P_NODE_2068_length_460_cov_2.340633_g2033_i0	PRJNA915212	2068	460	2.340633	10.7669118	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	222	1.1799999999999998e-69	NR	MES1911029.1	1215613	g2033	i0	71.1	3	152	44	99.1	0	458	3	1	152	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	1380	222	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
13648734	13648734	PRJNA915212_P_NODE_1791_length_496_cov_2.040268_g1756_i0	PRJNA915212	1791	496	2.040268	10.11972928	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	229	8.23e-75	NR	ADK26622.1	323453	g1756	i0	82.3	0.786290322580645	130	23	78.6	0	470	81	1	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	390	229	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
16197983	16197983	PRJNA915212_P_NODE_10533_length_177_cov_1.617188_g10495_i0	PRJNA915212	10533	177	1.617188	2.86242276	Thaumatomonas seravini	188939	SAR_Eukaryotes	SAR_Eukaryotes	195	2.35e-45	NTclustered	gi\|160337323\|gb\|EF455755.1\|	188939	g10495	i0	86.782	97.8135593220339	174	23	98	0	2	175	784	611	Thaumatomonas seravini actin gene, partial cds	blastn	17313	195	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Thaumatomonas	Thaumatomonas seravini
17473300	17473300	PRJNA915212_P_NODE_12114_length_166_cov_1.307692_g12076_i0	PRJNA915212	12114	166	1.307692	2.17076872	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	291	2.7099999999999998e-74	NTclustered	gi\|225216798\|gb\|FJ176713.1\|	458884	g12076	i0	98.193	98.6385542168675	166	3	100	0	1	166	201	36	Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence	blastn	16374	291	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
17473337	17473337	PRJNA915212_P_NODE_3234_length_352_cov_1.679868_g3197_i0	PRJNA915212	3234	352	1.679868	5.91313536	Gymnophrys sp. ATCC 50923	646463	SAR_Eukaryotes	SAR_Eukaryotes	429	1.32e-115	NTclustered	gi\|302026152\|gb\|GQ377656.1\|	646463	g3197	i0	88.636	99.8465909090909	352	40	100	0	1	352	85	436	Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds	blastn	35146	429	1	Eukaryota	Sar	Cercozoa				Gymnophrys	Gymnophrys sp. ATCC 50923
20021837	20021837	PRJNA915212_P_NODE_4836_length_273_cov_1.352679_g4798_i0	PRJNA915212	4836	273	1.352679	3.69281367	Paulinella micropora	1928728	SAR_Eukaryotes	SAR_Eukaryotes	311	3.75e-80	NTclustered	gi\|1389527545\|dbj\|LC383945.1\|	1928728	g4798	i0	87.179	83.1868131868132	273	35	100	0	1	273	1071	799	Paulinella micropora gene for actin, complete cds	blastn	22710	311	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella micropora
20377336	20377336	PRJNA915212_P_NODE_8756_length_197_cov_1.168919_g8718_i0	PRJNA915212	8756	197	1.168919	2.30277043	root	1	Root_unresolved	Root_unresolved	204	4.449999999999999e-48	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g8718	i0	99.115	58.8781725888325	113	1	57	0	1	113	2454	2342	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	11599	206	0.990291262135922	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
22572223	22572223	PRJNA915212_P_NODE_4518_length_285_cov_1.131356_g4480_i0	PRJNA915212	4518	285	1.131356	3.2243646	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	272	1.86e-68	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g4480	i0	84.727	78.3017543859649	275	39	96	3	1	275	1273	1544	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	22316	272	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
26898112	26898112	PRJNA915212_P_NODE_5141_length_263_cov_2.144860_g5103_i0	PRJNA915212	5141	263	2.14486	5.6409818	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.27e-13	NR	MES1912547.1	1215613	g5103	i0	55	0.91254752851711	80	35	91.3	1	263	24	5	83	MES1912547.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	240	70.9	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM

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