metadata: contig_metadata: 7 rows where bioproject = "PRJNA437204" and tax

7 rows where bioproject = "PRJNA437204" 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
2984325	2984325	PRJNA437204_P_NODE_98223_length_247_cov_0.885057_g97924_i0	PRJNA437204	98223	247	0.885057	2.18609079	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	252	2.05e-62	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g97924	i0	85.375	47.1376518218623	253	25	99	7	3	247	1879	1631	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	11643	252	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
9360841	9360841	PRJNA437204_P_NODE_51548_length_297_cov_1.375000_g51249_i0	PRJNA437204	51548	297	1.375	4.08375	Lecythium sp. 3678_261K	238773	SAR_Eukaryotes	SAR_Eukaryotes	204	7.199999999999999e-48	NTclustered	gi\|33089893\|gb\|AY283756.1\|	238773	g51249	i0	93.431	56.006734006734	137	9	46	0	161	297	768	632	Lecythium sp. 3678_261K actin gene, partial cds	blastn	16634	204	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Tectofilosida	Chlamydophryidae	Lecythium	Lecythium sp. 3678_261K
16392322	16392322	PRJNA437204_P_NODE_36913_length_333_cov_1.184615_g36614_i0	PRJNA437204	36913	333	1.184615	3.94476795	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	98.6	3.700000000000001e-22	NR	MES1911029.1	1215613	g36614	i0	49.1	0.990990990990991	110	55	99.1	1	331	2	197	305	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	330	98.6	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
24041410	24041410	PRJNA437204_P_NODE_23999_length_385_cov_1.480769_g23700_i0	PRJNA437204	23999	385	1.480769	5.70096065	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	318	3.28e-82	NTclustered	gi\|160337323\|gb\|EF455755.1\|	188939	g23700	i0	81.701	101.527272727273	388	65	100	6	1	385	656	272	Thaumatomonas seravini actin gene, partial cds	blastn	39088	318	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Thaumatomonas	Thaumatomonas seravini
28591882	28591882	PRJNA437204_P_NODE_122127_length_242_cov_0.911243_g121828_i0	PRJNA437204	122127	242	0.911243	2.20520806	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	85.5	1.34e-17	NR	MES1910793.1	1215613	g121828	i0	57.1	2.72727272727273	70	30	86.8	0	31	240	1	70	MES1910793.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	660	85.5	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
30913903	30913903	PRJNA437204_P_NODE_55154_length_290_cov_0.995392_g54855_i0	PRJNA437204	55154	290	0.995392	2.8866368	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	120	4.27e-33	NR	ACF24578.1	67809	g54855	i0	61.1	3.7448275862069	90	35	93.1	0	21	290	1	90	ACF24578.1 60S ribosomal protein L34 [Gymnochlora stellata]	diamond	1086	120	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
32667995	32667995	PRJNA437204_P_NODE_70860_length_263_cov_2.536842_g70561_i0	PRJNA437204	70860	263	2.536842	6.67189446	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	56.6	8.53e-8	NR	MES1913255.1	1215613	g70561	i0	40.9	0.752851711026616	66	38	74.1	1	197	3	31	96	MES1913255.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	198	56.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);;