metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1057075" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1057075" and tax_clade = "Opisthokonta"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26869200	26869200	PRJNA1057075_S_NODE_7841_length_171_cov_1.122951_g7742_i0	PRJNA1057075	7841	171	1.122951	1.92024621	Teratosphaeriaceae	668547	Fungi	Fungi	47	1.43e-4	NR	WPH01937.1	150365	g7742	i0	88.5	3.19298245614035	26	3	45.6	0	3	80	106	131	WPH01937.1 60S ribosomal protein L32 [Acrodontium crateriforme]	diamond	546	47.4	0.991561181434599	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Acrodontium	Acrodontium crateriforme
27667358	27667358	PRJNA1057075_S_NODE_9584_length_160_cov_4.090090_g9485_i0	PRJNA1057075	9584	160	4.09009	6.544144	Trichonephila clavipes	2585209	Arthropoda	Arthropoda	44.7	0.00113	NR	GFU75740.1	2585209	g9485	i0	70.4	0.50625	27	8	50.6	0	81	1	110	136	GFU75740.1 hypothetical protein TNCV_1652001 [Trichonephila clavipes]	diamond	81	44.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavipes
28077528	28077528	PRJNA1057075_S_NODE_8965_length_164_cov_1.313043_g8866_i0	PRJNA1057075	8965	164	1.313043	2.15339052	Rhizoclosmatium sp. JEL	2012244	Fungi	Fungi	44.3	0.00264	NR	KAJ3287761.1	2784343	g8866	i0	60	0.548780487804878	30	12	54.9	0	162	73	156	185	KAJ3287761.1 hypothetical protein HDU79_005437 [Rhizoclosmatium sp. JEL0117]	diamond	90	44.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Rhizoclosmatium	Rhizoclosmatium sp. JEL0117
28709276	28709276	PRJNA1057075_S_NODE_3767_length_229_cov_6.566667_g3668_i0	PRJNA1057075	3767	229	6.566667	15.03766743	Macrosiphum euphorbiae	13131	Arthropoda	Arthropoda	43.1	0.0173	NR	CAI6376859.1	13131	g3668	i0	41.5	1.66375545851528	53	25	61.6	1	229	89	135	187	CAI6376859.1 unnamed protein product [Macrosiphum euphorbiae]	diamond	381	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Macrosiphum	Macrosiphum euphorbiae
32784973	32784973	PRJNA1057075_S_NODE_3440_length_237_cov_1.095745_g3341_i0	PRJNA1057075	3440	237	1.095745	2.59691565	Penaeus vannamei	6689	Arthropoda	Arthropoda	43.5	0.0187	NR	ROT68233.1	6689	g3341	i0	47.6	0.531645569620253	42	22	53.2	0	7	132	386	427	ROT68233.1 hypothetical protein C7M84_013644 [Penaeus vannamei]	diamond	126	43.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei

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