metadata: contig_metadata: 5 rows where bioproject = "PRJNA699078", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA699078", 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
4509979	4509979	PRJNA699078_S_NODE_22664_length_356_cov_2.517915_g21715_i0	PRJNA699078	22664	356	2.517915	8.9637774	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	64.3	1.65e-10	NR	KAI2495375.1	210448	g21715	i0	42.5	4.98033707865169	80	45	67.4	1	58	297	26	104	KAI2495375.1 S25 ribosomal protein [Fragilaria crotonensis]	diamond	1773	64.3	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
15212654	15212654	PRJNA699078_S_NODE_100892_length_167_cov_0.881356_g99943_i0	PRJNA699078	100892	167	0.881356	1.47186452	root	1	Root_unresolved	Root_unresolved	100	4.93e-17	NTclustered	gi\|1419234739\|dbj\|AP018511.1\|	303400	g99943	i0	84.848	27.9041916167665	99	15	59	0	1	99	98858	98760	Nitzschia palea NIES-2729 chloroplast DNA complet genome	blastn	4660	100	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia palea
27114128	27114128	PRJNA699078_S_NODE_10642_length_468_cov_13.245823_g9730_i0	PRJNA699078	10642	468	13.245823	61.99045164	Cyclotella atomus	382360	SAR_Eukaryotes	SAR_Eukaryotes	100	1.38e-24	NR	KAL3795564.1	382360	g9730	i0	52.4	0.538461538461538	84	40	53.8	0	467	216	5	88	KAL3795564.1 hypothetical protein ACHAWO_009860 [Cyclotella atomus]	diamond	252	100	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella atomus
27462100	27462100	PRJNA699078_S_NODE_38283_length_279_cov_3.547826_g37334_i0	PRJNA699078	38283	279	3.547826	9.89843454	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	58.2	4.53e-8	NR	XP_002182352.1	556484	g37334	i0	44	1.87096774193548	84	43	89.2	3	260	12	76	156	XP_002182352.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	522	58.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31737304	31737304	PRJNA699078_S_NODE_7637_length_527_cov_28.083682_g6761_i0	PRJNA699078	7637	527	28.083682	148.00100414	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	159	8.529999999999999e-45	NR	EJK48596.1	159749	g6761	i0	55.2	3.31309297912713	145	64	82	1	1	432	93	237	EJK48596.1 hypothetical protein THAOC_32592 [Thalassiosira oceanica]	diamond	1746	160	0.99375	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);;