metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA193544" 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
18217591	18217591	PRJNA193544_S_NODE_2575_length_172_cov_7.286713_g2560_i0	PRJNA193544	2575	172	7.286713	12.53314636	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	109	2.29e-28	NR	KAG7356920.1	303405	g2560	i0	93.1	1.01162790697674	58	3	99.4	1	1	171	63	120	KAG7356920.1 chlorophyll A-B binding protein [Nitzschia inconspicua]	diamond	174	109	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
29112893	29112893	PRJNA193544_S_NODE_1528_length_212_cov_17.836066_g1513_i0	PRJNA193544	1528	212	17.836066	37.81245992	Bacillariaceae	33852	SAR_Eukaryotes	SAR_Eukaryotes	48.9	1.71e-4	NR	CAJ1946497.1	2856	g1513	i0	37.7	2.19339622641509	69	41	96.2	2	3	206	3676	3743	CAJ1946497.1 unnamed protein product, partial [Cylindrotheca closterium]	diamond	465	49.3	0.991886409736308	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
29221498	29221498	PRJNA193544_S_NODE_1869_length_197_cov_5.089286_g1854_i0	PRJNA193544	1869	197	5.089286	10.02589342	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	119	1.64e-29	NR	KAG7343238.1	303405	g1854	i0	78.5	0.989847715736041	65	14	99	0	3	197	9679	9743	KAG7343238.1 DUF3349 domain containing protein [Nitzschia inconspicua]	diamond	195	119	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
29537021	29537021	PRJNA193544_S_NODE_130_length_435_cov_13.004926_g117_i0	PRJNA193544	130	435	13.004926	56.5714281	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	139	8.42e-36	NR	KAL3915793.1	3061772	g117	i0	56.1	2.88965517241379	139	54	94.5	4	416	6	236	369	KAL3915793.1 MAG: hypothetical protein SGILL_005479 [Bacillariaceae sp.]	diamond	1257	139	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
30136748	30136748	PRJNA193544_S_NODE_1832_length_199_cov_5.035294_g1817_i0	PRJNA193544	1832	199	5.035294	10.02023506	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	64.7	3.59e-10	NR	KAL3915793.1	3061772	g1817	i0	54.1	0.919597989949749	61	26	88.9	1	182	6	309	369	KAL3915793.1 MAG: hypothetical protein SGILL_005479 [Bacillariaceae sp.]	diamond	183	64.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
30376533	30376533	PRJNA193544_S_NODE_1772_length_201_cov_2.686047_g1757_i0	PRJNA193544	1772	201	2.686047	5.39895447	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	136	2.56e-39	NR	5DKK_A	2850	g1757	i0	95.5	7.88059701492537	66	3	98.5	0	3	200	30	95	5DKK_A Chain A, LOV domain [Phaeodactylum tricornutum]	diamond	1584	137	0.992700729927007	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
30674155	30674155	PRJNA193544_S_NODE_733_length_282_cov_22.814229_g718_i0	PRJNA193544	733	282	22.814229	64.33612578	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	58.5	1.52e-7	NR	KAL3908317.1	3061772	g718	i0	45.1	1.53191489361702	71	36	74.5	3	229	20	1	69	KAL3908317.1 MAG: hypothetical protein SGARI_003117 [Bacillariaceae sp.]	diamond	432	58.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
31039908	31039908	PRJNA193544_S_NODE_295_length_361_cov_10.385542_g280_i0	PRJNA193544	295	361	10.385542	37.49180662	Cylindrotheca	2852	SAR_Eukaryotes	SAR_Eukaryotes	64.7	3.16e-9	NR	CAJ1946497.1	2856	g280	i0	51.7	1.5207756232687	58	28	48.2	0	333	160	4674	4731	CAJ1946497.1 unnamed protein product, partial [Cylindrotheca closterium]	diamond	549	64.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
32160553	32160553	PRJNA193544_S_NODE_2738_length_167_cov_4.775362_g2723_i0	PRJNA193544	2738	167	4.775362	7.97485454	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	108	2.94e-26	NR	KAG7338699.1	303405	g2723	i0	96.4	0.988023952095808	55	2	98.8	0	3	167	304	358	KAG7338699.1 translation elongation factor EF-1 subunit alpha [Nitzschia inconspicua]	diamond	165	108	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
32241768	32241768	PRJNA193544_S_NODE_1898_length_195_cov_23528.210843_g1883_i0	PRJNA193544	1898	195	23528.210843	45880.01114385	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	90.5	1.21e-20	NR	CAJ1954188.1	2856	g1883	i0	67.2	2.86153846153846	61	20	93.8	0	195	13	133	193	CAJ1954188.1 unnamed protein product [Cylindrotheca closterium]	diamond	558	90.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
32255677	32255677	PRJNA193544_S_NODE_3238_length_155_cov_5.007937_g3223_i0	PRJNA193544	3238	155	5.007937	7.76230235	Cylindrotheca closterium	2856	SAR_Eukaryotes	SAR_Eukaryotes	88.6	2.95e-20	NR	CAJ1960414.1	2856	g3223	i0	97.7	3.40645161290323	44	1	85.2	0	1	132	150	193	CAJ1960414.1 unnamed protein product [Cylindrotheca closterium]	diamond	528	88.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium
32666064	32666064	PRJNA193544_S_NODE_60_length_534_cov_12.154455_g50_i0	PRJNA193544	60	534	12.154455	64.9047897	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	143	1.02e-36	NR	KAL3915793.1	3061772	g50	i0	48.8	2.8876404494382	170	76	94.4	4	26	529	209	369	KAL3915793.1 MAG: hypothetical protein SGILL_005479 [Bacillariaceae sp.]	diamond	1542	143	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.

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