metadata: contig_metadata: 9 rows where bioproject = "PRJNA788929", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA788929", 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
8422721	8422721	PRJNA788929_P_NODE_42787_length_240_cov_10.095808_g42126_i0	PRJNA788929	42787	240	10.095808	24.2299392	Navicula incertata	2014769	SAR_Eukaryotes	SAR_Eukaryotes	279	9.1e-71	NTclustered	gi\|2866543349\|gb\|PQ722532.1\|	2014769	g42126	i0	89.862	96.6333333333333	217	22	90	0	24	240	48954	48738	Navicula incertata mitochondrion, complete genome	blastn	23192	279	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Navicula	Navicula incertata
10973548	10973548	PRJNA788929_P_NODE_40849_length_244_cov_10.736842_g40188_i0	PRJNA788929	40849	244	10.736842	26.19789448	Halamphora americana	2305497	SAR_Eukaryotes	SAR_Eukaryotes	366	6.92e-97	NTclustered	gi\|1549146931\|gb\|MH810166.1\|	2305497	g40188	i0	96.396	73.7622950819672	222	8	91	0	1	222	10134	9913	Halamphora americana voucher JPK7977-AMPH100 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	17998	366	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Amphipleuraceae	Halamphora	Halamphora americana
21172149	21172149	PRJNA788929_P_NODE_47077_length_217_cov_4.555556_g46416_i0	PRJNA788929	47077	217	4.555556	9.88555652	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	182	2.34e-41	NTclustered	gi\|657012566\|gb\|KF302620.1\|	2850	g46416	i0	88.742	71.7926267281106	151	13	69	4	67	216	764	617	Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds	blastn	15579	182	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
23722439	23722439	PRJNA788929_P_NODE_47499_length_214_cov_5.943262_g46838_i0	PRJNA788929	47499	214	5.943262	12.71858068	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	124	3.94e-24	NTclustered	gi\|219129759\|ref\|XM_002185013.1\|	556484	g46838	i0	91.209	6.58878504672897	91	8	43	0	43	133	391	481	Phaeodactylum tricornutum CCAP 1055/1 calmoduline (CaM1), mRNA	blastn	1410	124	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
26778238	26778238	PRJNA788929_P_NODE_43221_length_238_cov_7.278788_g42560_i0	PRJNA788929	43221	238	7.278788	17.32351544	Naviculales	38748	SAR_Eukaryotes	SAR_Eukaryotes	49.7	3.23e-5	NR	YP_010516658.1	197756	g42560	i0	46	3.7563025210084	50	27	63	0	27	176	42	91	YP_010516658.1 ribosomal protein L16 [Haslea pseudostrearia]	diamond	894	50.1	0.992015968063872	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Haslea	Haslea pseudostrearia
27370070	27370070	PRJNA788929_P_NODE_23643_length_331_cov_11.015504_g22982_i0	PRJNA788929	23643	331	11.015504	36.46131824	Halamphora calidilacuna	2133758	SAR_Eukaryotes	SAR_Eukaryotes	52.4	7.52e-6	NR	AVR57670.1	2133758	g22982	i0	44.8	0.607250755287009	67	36	60.7	1	5	205	56	121	AVR57670.1 ribosomal protein S8 [Halamphora calidilacuna]	diamond	201	52.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Amphipleuraceae	Halamphora	Halamphora calidilacuna
28262929	28262929	PRJNA788929_P_NODE_7926_length_661_cov_3.326531_g7283_i0	PRJNA788929	7926	661	3.326531	21.98836991	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	47	0.0151	NR	GFH46672.1	426638	g7283	i0	77.3	0.304084720121029	22	5	10	0	579	514	114	135	GFH46672.1 hypothetical protein CTEN210_03146 [Chaetoceros tenuissimus]	diamond	201	47	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
29873427	29873427	PRJNA788929_P_NODE_17831_length_391_cov_46.578616_g17171_i0	PRJNA788929	17831	391	46.578616	182.12238856	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	134	3.77e-37	NR	EJK48333.1	159749	g17171	i0	58.6	5.24040920716113	116	47	89	1	350	3	22	136	EJK48333.1 hypothetical protein THAOC_32880, partial [Thalassiosira oceanica]	diamond	2049	134	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
32551731	32551731	PRJNA788929_P_NODE_30899_length_283_cov_6.085714_g30238_i0	PRJNA788929	30899	283	6.085714	17.22257062	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	75.9	3.21e-15	NR	GAX24570.1	1519565	g30238	i0	49.4	1.70671378091873	79	29	83.7	2	266	30	5	72	GAX24570.1 hypothetical protein FisN_4Hh089 [Fistulifera solaris]	diamond	483	75.9	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris

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