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

7 rows where analysis = "diamond", bioproject = "PRJNA864829" 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
21638917	21638917	PRJNA864829_S_NODE_8237_length_216_cov_1.982036_g8151_i0	PRJNA864829	8237	216	1.982036	4.28119776	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	122	6.5e-34	NR	CAE7460100.1	2951	g8151	i0	71.8	6.91666666666667	71	20	98.6	0	213	1	48	118	CAE7460100.1 gbsA [Symbiodinium microadriaticum]	diamond	1494	123	0.991869918699187	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
22523960	22523960	PRJNA864829_S_NODE_10018_length_199_cov_2.060000_g9932_i0	PRJNA864829	10018	199	2.06	4.0994	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	105	1.1e-26	NR	ACU45029.1	71001	g9932	i0	80.3	19.7185929648241	66	13	99.5	0	198	1	86	151	ACU45029.1 ribosomal protein S9 [Pfiesteria piscicida]	diamond	3924	106	0.990566037735849	Eukaryota	Sar		Dinophyceae	Peridiniales	Pfiesteriaceae	Pfiesteria	Pfiesteria piscicida
27339747	27339747	PRJNA864829_S_NODE_2543_length_336_cov_2.508711_g2457_i0	PRJNA864829	2543	336	2.508711	8.42926896	Cryptosporidium ryanae	515981	SAR_Eukaryotes	SAR_Eukaryotes	59.3	3.13e-8	NR	XP_067198701.1	515981	g2457	i0	53.8	1.39285714285714	52	24	46.4	0	8	163	101	152	XP_067198701.1 uncharacterized protein FG386_003659 [Cryptosporidium ryanae]	diamond	468	59.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ryanae
27655587	27655587	PRJNA864829_S_NODE_4824_length_268_cov_1.716895_g4738_i0	PRJNA864829	4824	268	1.716895	4.6012786	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	127	1.83e-33	NR	CEP01219.1	37360	g4738	i0	69.4	1.83582089552239	85	20	88.4	1	1	237	233	317	CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae]	diamond	492	127	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29202636	29202636	PRJNA864829_S_NODE_6769_length_235_cov_2.155914_g6683_i0	PRJNA864829	6769	235	2.155914	5.0663979	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	80.5	1.12e-16	NR	MES1914713.1	1215613	g6683	i0	64.2	0.676595744680851	53	19	67.7	0	1	159	96	148	MES1914713.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	159	80.5	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31761841	31761841	PRJNA864829_S_NODE_3917_length_288_cov_2.723849_g3831_i0	PRJNA864829	3917	288	2.723849	7.84468512	Symbiodinium microadriaticum	2951	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0139	NR	OLQ08227.1	2951	g3831	i0	30.8	3.79166666666667	91	54	85.4	2	11	256	2135	2225	OLQ08227.1 LINE-1 reverse transcriptase-like [Symbiodinium microadriaticum]	diamond	1092	44.7	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium microadriaticum
31991376	31991376	PRJNA864829_S_NODE_13498_length_175_cov_1.126984_g13412_i0	PRJNA864829	13498	175	1.126984	1.972222	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	85.1	8.64e-18	NR	OAO15189.1	478820	g13412	i0	78.4	6.99428571428571	51	11	87.4	0	21	173	293	343	OAO15189.1 ribosomal protein L18 [Blastocystis sp. ATCC 50177/Nand II]	diamond	1224	85.1	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis hominis

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