metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA575566" 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
6240392	6240392	PRJNA575566_P_NODE_5685_length_440_cov_2.226913_g5488_i0	PRJNA575566	5685	440	2.226913	9.7984172	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	204	1.39e-57	NR	KAG7341642.1	303405	g5488	i0	69.4	2.78181818181818	134	39	90	1	2	397	255	388	KAG7341642.1 carbamoyl-phosphate synthase large subunit [Nitzschia inconspicua]	diamond	1224	206	0.990291262135922	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
18412080	18412080	PRJNA575566_P_NODE_27035_length_205_cov_0.888889_g26838_i0	PRJNA575566	27035	205	0.888889	1.82222245	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	6.830000000000001e-33	NR	KAL3780735.1	29204	g26838	i0	84.8	23.209756097561	66	10	96.6	0	3	200	114	179	KAL3780735.1 hypothetical protein HJC23_001017 [Cyclotella cryptica]	diamond	4758	124	0.991935483870968	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
20962261	20962261	PRJNA575566_P_NODE_22677_length_217_cov_1.807692_g22480_i0	PRJNA575566	22677	217	1.807692	3.92269164	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	1.0599999999999998e-31	NR	YP_005090330.1	2850	g22480	i0	75	17.9170506912442	72	18	99.5	0	217	2	315	386	YP_005090330.1 NADH dehydrogenase subunit 7 [Phaeodactylum tricornutum]	diamond	3888	124	0.991935483870968	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
27047961	27047961	PRJNA575566_P_NODE_27662_length_204_cov_0.895105_g27465_i0	PRJNA575566	27662	204	0.895105	1.8260142	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	53.1	9.69e-7	NR	KAK1745333.1	267567	g27465	i0	48.4	0.911764705882353	62	32	91.2	0	203	18	64	125	KAK1745333.1 60S ribosomal protein L14 [Skeletonema marinoi]	diamond	186	53.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
32007800	32007800	PRJNA575566_P_NODE_26738_length_205_cov_1.354167_g26541_i0	PRJNA575566	26738	205	1.354167	2.77604235	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	72	6.29e-14	NR	EJK66048.1	159749	g26541	i0	58.1	1.81463414634146	62	26	90.7	0	7	192	58	119	EJK66048.1 hypothetical protein THAOC_13056 [Thalassiosira oceanica]	diamond	372	72	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica

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