metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_clade = "Sar"

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
21382728	21382728	PRJNA999747_S_NODE_17_length_1140_cov_10.411181_g14_i0	PRJNA999747	17	1140	10.411181	118.6874634	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	546	1.72e-191	NR	KAG5191638.1	303371	g14	i0	75	8.26578947368421	352	87	92.6	1	4	1059	91	441	KAG5191638.1 putative translation elongation factor 1-alpha [Tribonema minus]	diamond	9423	546	1	Eukaryota	Sar		Xanthophyceae	Tribonematales	Tribonemataceae	Tribonema	Tribonema minus
27342828	27342828	PRJNA999747_S_NODE_2643_length_191_cov_1.793750_g2611_i0	PRJNA999747	2643	191	1.79375	3.4260625	Cladocopium goreaui	2562237	SAR_Eukaryotes	SAR_Eukaryotes	70.1	4.22e-12	NR	CAL1138082.1	2562237	g2611	i0	40.3	2.3717277486911	77	32	99	2	3	191	529	605	CAL1138082.1 unnamed protein product [Cladocopium goreaui]	diamond	453	70.1	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Cladocopium	Cladocopium goreaui
28384545	28384545	PRJNA999747_S_NODE_3606_length_166_cov_1.296296_g3574_i0	PRJNA999747	3606	166	1.296296	2.15185136	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	62.8	5.99e-10	NR	ETO07260.1	46433	g3574	i0	58.5	0.957831325301205	53	16	84.9	1	26	166	2	54	ETO07260.1 GTP-binding nuclear protein RAN/TC4 [Reticulomyxa filosa]	diamond	159	62.8	1	Eukaryota	Sar	Foraminifera			Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30474827	30474827	PRJNA999747_S_NODE_4033_length_158_cov_1.543307_g4001_i0	PRJNA999747	4033	158	1.543307	2.43842506	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	69.3	4.89e-12	NR	KAG9409221.1	112091	g4001	i0	79.1	4.1772151898734204	43	9	81.6	0	7	135	298	340	KAG9409221.1 hypothetical protein AC1031_019479 [Aphanomyces cochlioides]	diamond	660	69.3	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides
30569223	30569223	PRJNA999747_S_NODE_1673_length_233_cov_3.143564_g1641_i0	PRJNA999747	1673	233	3.143564	7.32450412	Suessiales	89954	SAR_Eukaryotes	SAR_Eukaryotes	114	2.0500000000000003e-27	NR	CEL98422.1	1169540	g1641	i0	68	46.3390557939914	75	24	96.6	0	7	231	608	682	CEL98422.1 unnamed protein product [Vitrella brassicaformis CCMP3155]	diamond	10797	114	1	Eukaryota	Sar				Vitrellaceae	Vitrella	Vitrella brassicaformis
31796315	31796315	PRJNA999747_S_NODE_4037_length_158_cov_1.503937_g4005_i0	PRJNA999747	4037	158	1.503937	2.37622046	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	46.6	5.11e-4	NR	KAL3907318.1	3061772	g4005	i0	52.3	0.835443037974684	44	20	81.6	1	141	13	70	113	KAL3907318.1 MAG: hypothetical protein SGILL_008924, partial [Bacillariaceae sp.]	diamond	132	46.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
32655869	32655869	PRJNA999747_S_NODE_1600_length_238_cov_4.966184_g1568_i0	PRJNA999747	1600	238	4.966184	11.81951792	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	76.3	5.64e-14	NR	KAL0585142.1	65357	g1568	i0	61	5.15546218487395	59	23	74.4	0	177	1	234	292	KAL0585142.1 hypothetical protein ABG067_005038 [Albugo candida]	diamond	1227	76.3	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida

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