metadata: contig_metadata: 8 rows where bioproject = "PRJNA1111077", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA1111077", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

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
9142039	9142039	PRJNA1111077_P_NODE_1348_length_868_cov_3.769811_g1165_i0	PRJNA1111077	1348	868	3.769811	32.72195948	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	411	1.2499999999999998e-109	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g1165	i0	87.088	60.4135944700461	364	45	42	2	241	603	23	385	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	52439	411	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
27478556	27478556	PRJNA1111077_P_NODE_31003_length_250_cov_0.870056_g30782_i0	PRJNA1111077	31003	250	0.870056	2.17514	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	101	3.639999999999999e-23	NR	CAJ1954423.1	2856	g30782	i0	58.8	2.928	80	33	96	0	10	249	240	319	CAJ1954423.1 unnamed protein product [Cylindrotheca closterium]	diamond	732	101	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
27573267	27573267	PRJNA1111077_P_NODE_11204_length_354_cov_1.078292_g10983_i0	PRJNA1111077	11204	354	1.078292	3.81715368	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	193	1.3e-56	NR	KAG7367577.1	303405	g10983	i0	78	7	118	26	100	0	354	1	378	495	KAG7367577.1 methylmalonate-semialdehyde dehydrogenase [Nitzschia inconspicua]	diamond	2478	193	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
27722835	27722835	PRJNA1111077_P_NODE_20824_length_284_cov_1.459716_g20603_i0	PRJNA1111077	20824	284	1.459716	4.14559344	Stephanodiscaceae	1365474	SAR_Eukaryotes	SAR_Eukaryotes	82	9.14e-16	NR	KAL3826868.1	382380	g20603	i0	50.6	2.91549295774648	77	38	81.3	0	42	272	314	390	KAL3826868.1 hypothetical protein ACHAXA_005710 [Cyclostephanos tholiformis]	diamond	828	82.4	0.995145631067961	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
28954047	28954047	PRJNA1111077_P_NODE_36588_length_241_cov_0.916667_g36367_i0	PRJNA1111077	36588	241	0.916667	2.20916747	Naviculaceae	67474	SAR_Eukaryotes	SAR_Eukaryotes	84.7	5.29e-18	NR	GAX13102.1	1519565	g36367	i0	62.5	1.99170124481328	80	30	99.6	0	2	241	22	101	GAX13102.1 charged multivesicular body protein 2A [Fistulifera solaris]	diamond	480	85.1	0.995299647473561	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
30257678	30257678	PRJNA1111077_P_NODE_38272_length_214_cov_4.290780_g38051_i0	PRJNA1111077	38272	214	4.29078	9.1822692	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	136	5.83e-39	NR	GKZ01120.1	2872254	g38051	i0	87.1	5.85981308411215	70	9	98.1	0	212	3	81	150	GKZ01120.1 hypothetical protein MPSEU_001063600 [Mayamaea pseudoterrestris]	diamond	1254	136	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
32090944	32090944	PRJNA1111077_P_NODE_26778_length_263_cov_3.768421_g26557_i0	PRJNA1111077	26778	263	3.768421	9.91094723	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	77.4	2.83e-14	NR	GFH45868.1	426638	g26557	i0	76.6	1.58555133079848	47	11	53.6	0	1	141	422	468	GFH45868.1 udp-d-glucose 6-dehydrogenase [Chaetoceros tenuissimus]	diamond	417	77.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
32840041	32840041	PRJNA1111077_P_NODE_31840_length_248_cov_2.960000_g31619_i0	PRJNA1111077	31840	248	2.96	7.3408	root	1	Root_unresolved	Root_unresolved	43.1	0.0286	NR	CAJ1958728.1	2856	g31619	i0	35	2.52822580645161	80	45	89.5	3	224	3	120	198	CAJ1958728.1 unnamed protein product [Cylindrotheca closterium]	diamond	627	43.5	0.990804597701149	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium

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