metadata: contig_metadata: 4 rows where bioproject = "PRJNA799842", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA799842", 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
4623690	4623690	PRJNA799842_P_NODE_59064_length_370_cov_1.259259_g57491_i0	PRJNA799842	59064	370	1.259259	4.6592583	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	145	2.57e-41	NR	KAL3922769.1	3061772	g57491	i0	73.1	1.72702702702703	108	24	86.8	2	323	3	75	178	KAL3922769.1 MAG: hypothetical protein SGILL_002026 [Bacillariaceae sp.]	diamond	639	145	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
24170232	24170232	PRJNA799842_P_NODE_119039_length_268_cov_1.805128_g117466_i0	PRJNA799842	119039	268	1.805128	4.83774304	Navicula	50949	SAR_Eukaryotes	SAR_Eukaryotes	490	4.39e-134	NTclustered	gi\|2301268953\|ref\|NC_066075.1\|	355634	g117466	i0	99.627	197.626865671642	268	1	100	0	1	268	9681	9414	Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome	blastn	52964	490	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Navicula	Navicula arenaria
26610698	26610698	PRJNA799842_P_NODE_98221_length_293_cov_1.400000_g96648_i0	PRJNA799842	98221	293	1.4	4.102	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	75.9	1.5700000000000001e-13	NR	GFH49360.1	426638	g96648	i0	38.5	0.931740614334471	91	56	93.2	0	278	6	8	98	GFH49360.1 hypothetical protein CTEN210_05836 [Chaetoceros tenuissimus]	diamond	273	75.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
28885568	28885568	PRJNA799842_P_NODE_183648_length_242_cov_0.911243_g182075_i0	PRJNA799842	183648	242	0.911243	2.20520806	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0463	NR	CAB9529273.1	568900	g182075	i0	37.5	0.694214876033058	56	33	69.4	1	179	12	121	174	CAB9529273.1 adenosylmethionine carrier 1, chloroplastic/mitochondrial [Seminavis robusta]	diamond	168	42.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta

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