metadata: contig_metadata: 6 rows where bioproject = "PRJEB10140", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJEB10140", tax_clade = "Sar" and tax_phylum = "Foraminifera"

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_order	tax_family	tax_genus	tax_species
21689670	21689670	PRJEB10140_P_NODE_292618_length_162_cov_0.867257_g275309_i0	PRJEB10140	292618	162	0.867257	1.40495634	Bathysiphon sp. 3980	323409	SAR_Eukaryotes	SAR_Eukaryotes	226	7.509999999999998e-55	NTclustered	gi\|79677317\|emb\|AJ937550.1\|	323409	g275309	i0	92.405	39.4506172839506	158	12	98	0	5	162	219	62	Bathysiphon sp. 3980 partial pub gene, clone 1	blastn	6391	226	1	Eukaryota	Sar	Foraminifera	Astrorhizida	Bathysiphonidae	Bathysiphon	Bathysiphon sp. 3980
27121095	27121095	PRJEB10140_P_NODE_209022_length_189_cov_1.471429_g191713_i0	PRJEB10140	209022	189	1.471429	2.78100081	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	81.3	4.78e-16	NR	ETO27461.1	46433	g191713	i0	57.4	3.88888888888889	61	26	96.8	0	184	2	1280	1340	ETO27461.1 HECT type ubiquitin ligase [Reticulomyxa filosa]	diamond	735	81.3	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27759574	27759574	PRJEB10140_P_NODE_33164_length_1044_cov_4.789950_g20593_i0	PRJEB10140	33164	1044	4.78995	50.007078	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	71.2	2.04e-9	NR	ETO28127.1	46433	g20593	i0	34.1	0.370689655172414	129	63	34.8	4	363	725	596	710	ETO28127.1 hypothetical protein RFI_09007, partial [Reticulomyxa filosa]	diamond	387	71.2	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28390689	28390689	PRJEB10140_P_NODE_292846_length_162_cov_0.867257_g275537_i0	PRJEB10140	292846	162	0.867257	1.40495634	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	67	3.11e-12	NR	ETN97645.1	46433	g275537	i0	61.7	0.87037037037037	47	18	87	0	1	141	47	93	ETN97645.1 hypothetical protein RFI_39884, partial [Reticulomyxa filosa]	diamond	141	67	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29811422	29811422	PRJEB10140_P_NODE_285931_length_163_cov_0.859649_g268622_i0	PRJEB10140	285931	163	0.859649	1.40122787	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	52.8	2.57e-6	NR	ETO33571.1	46433	g268622	i0	50	1.12269938650307	40	20	73.6	0	1	120	174	213	ETO33571.1 hypothetical protein RFI_03533 [Reticulomyxa filosa]	diamond	183	52.8	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31802420	31802420	PRJEB10140_P_NODE_199017_length_196_cov_1.333333_g181708_i0	PRJEB10140	199017	196	1.333333	2.61333268	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	46.6	8.18e-4	NR	ETO30463.1	46433	g181708	i0	37.7	0.933673469387755	61	38	93.4	0	9	191	26	86	ETO30463.1 hypothetical protein RFI_06656 [Reticulomyxa filosa]	diamond	183	46.6	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa

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