metadata: contig_metadata: 14 rows where bioproject = "PRJEB2925" and tax

14 rows where bioproject = "PRJEB2925" 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
26027	26027	PRJEB2925_P_NODE_12421_length_303_cov_6.608209_g11144_i0	PRJEB2925	12421	303	6.6082090000000004	20.02287327	Euglypha rotunda	39714	SAR_Eukaryotes	SAR_Eukaryotes	544	3.82e-150	NTclustered	gi\|18075905\|emb\|AJ418782.1\|	39714	g11144	i0	99.01	95.1617161716172	303	3	100	0	1	303	433	131	Euglypha rotunda 18S rRNA gene, strain Costa Rica	blastn	28834	544	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Euglyphidae	Euglypha	Euglypha rotunda
2575930	2575930	PRJEB2925_P_NODE_13423_length_284_cov_21.301205_g12146_i0	PRJEB2925	13423	284	21.301205	60.4954222	Placocista sp. CC-Grouse Mountain	741089	SAR_Eukaryotes	SAR_Eukaryotes	318	2.34e-82	NTclustered	gi\|290760485\|gb\|GQ144688.1\|	741089	g12146	i0	87.063	41.4718309859155	286	31	100	5	1	284	2092	2373	Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence	blastn	11778	318	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Euglyphidae	Placocista	Placocista sp. CC-Grouse Mountain
2576012	2576012	PRJEB2925_P_NODE_6543_length_507_cov_45.675847_g5407_i0	PRJEB2925	6543	507	45.675847	231.57654429	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	468	4.16e-127	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g5407	i0	98.134	68.9368836291913	268	5	53	0	240	507	1	268	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	34951	468	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
6091182	6091182	PRJEB2925_P_NODE_13445_length_284_cov_2.469880_g12168_i0	PRJEB2925	13445	284	2.46988	7.0144592	Euglyphida	178369	SAR_Eukaryotes	SAR_Eukaryotes	361	3.8399999999999996e-95	NTclustered	gi\|558761202\|gb\|KF539406.1\|	1427721	g12168	i0	89.474	92.0669014084507	285	28	99	1	1	283	120	404	Sphenoderia macrolepis isolate SMAC small subunit ribosomal RNA gene, partial sequence	blastn	26147	361	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Sphenoderiidae	Sphenoderia	Sphenoderia macrolepis
7678293	7678293	PRJEB2925_P_NODE_11067_length_335_cov_10.623333_g9793_i0	PRJEB2925	11067	335	10.623333	35.58816555	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	580	3.2599999999999993e-161	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g9793	i0	97.91	99.8865671641791	335	7	100	0	1	335	5	339	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	33462	580	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
7678368	7678368	PRJEB2925_P_NODE_2567_length_961_cov_24.407127_g1925_i0	PRJEB2925	2567	961	24.407127	234.55249047	Placocista sp. CC-Grouse Mountain	741089	SAR_Eukaryotes	SAR_Eukaryotes	961	0	NTclustered	gi\|290760485\|gb\|GQ144688.1\|	741089	g1925	i0	90.746	91.2788761706556	724	61	87	6	1	721	1430	2150	Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence	blastn	87719	961	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Euglyphidae	Placocista	Placocista sp. CC-Grouse Mountain
8641256	8641256	PRJEB2925_P_NODE_17007_length_228_cov_3.000000_g15729_i0	PRJEB2925	17007	228	3	6.84	Cercomonas	45109	SAR_Eukaryotes	SAR_Eukaryotes	255	1.44e-63	NTclustered	gi\|161015709\|gb\|EF681943.1\|	458869	g15729	i0	98.611	16.530701754386	144	2	100	0	1	144	699	556	Cercomonas sp. HFCC541 28S ribosomal RNA gene, partial sequence	blastn	3769	255	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Cercomonas	Cercomonas sp. HFCC541
10228965	10228965	PRJEB2925_P_NODE_9469_length_383_cov_11.132184_g8199_i0	PRJEB2925	9469	383	11.132184	42.63626472	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	318	3.26e-82	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g8199	i0	82.632	55.1723237597911	380	47	99	11	1	378	3659	4021	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	21131	318	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
12779670	12779670	PRJEB2925_P_NODE_17231_length_216_cov_8.060773_g15953_i0	PRJEB2925	17231	216	8.060773	17.41126968	Euglypha rotunda	39714	SAR_Eukaryotes	SAR_Eukaryotes	383	5.95e-102	NTclustered	gi\|541673\|emb\|X77692.1\|	39714	g15953	i0	98.611	100.861111111111	216	3	100	0	1	216	1437	1652	E.rotunda (strain CCAP 1520/1) cytoplasmic small subunit 16S-like rRNA gene	blastn	21786	383	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Euglyphidae	Euglypha	Euglypha rotunda
15328326	15328326	PRJEB2925_P_NODE_8273_length_429_cov_10.055838_g7039_i0	PRJEB2925	8273	429	10.055838	43.13954502	Paracercomonas marina	372086	SAR_Eukaryotes	SAR_Eukaryotes	765	0	NTclustered	gi\|88792583\|gb\|DQ386164.1\|	372086	g7039	i0	98.834	100.634032634033	429	5	100	0	1	429	1557	1985	Paracercomonas marina 28S ribosomal RNA gene, partial sequence	blastn	43172	765	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Paracercomonas	Paracercomonas marina
16602966	16602966	PRJEB2925_P_NODE_6474_length_511_cov_14.876050_g5342_i0	PRJEB2925	6474	511	14.87605	76.0166155	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	329	2.0599999999999996e-85	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g5342	i0	83.74	41.9628180039139	369	38	71	16	147	511	4009	3659	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	21443	329	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
17877825	17877825	PRJEB2925_P_NODE_9875_length_370_cov_17.089552_g8603_i0	PRJEB2925	9875	370	17.089552	63.2313424	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	662	0	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g8603	i0	98.919	27.5162162162162	370	4	100	0	1	370	250	619	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	10181	662	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
19151602	19151602	PRJEB2925_P_NODE_12796_length_296_cov_3.670498_g11519_i0	PRJEB2925	12796	296	3.670498	10.86467408	Clautriavia biflagellata	645452	SAR_Eukaryotes	SAR_Eukaryotes	95.3	4.5e-15	NTclustered	gi\|290760479\|gb\|GQ144682.1\|	645452	g11519	i0	90.278	35.4594594594595	72	7	24	0	1	72	2895	2824	Cercozoa sp. Brady Beach 2007 large subunit ribosomal RNA gene, partial sequence	blastn	10496	95.3	1	Eukaryota	Sar	Cercozoa				Clautriavia	Clautriavia biflagellata
30823123	30823123	PRJEB2925_P_NODE_10694_length_346_cov_14.080386_g9421_i0	PRJEB2925	10694	346	14.080386	48.71813556	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	83.6	6.02e-18	NR	MES1912234.1	1215613	g9421	i0	54.7	1.30057803468208	75	31	65	2	324	100	49	120	MES1912234.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	450	83.6	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);;