metadata: contig_metadata: 5 rows where bioproject = "PRJNA771359", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA771359", tax_clade = "Opisthokonta" and tax_phylum = "Mollusca"

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
16049646	16049646	PRJNA771359_S_NODE_3173_length_188_cov_5.013245_g3090_i0	PRJNA771359	3173	188	5.013245	9.4249006	Physella acuta	109671	Mollusca	Mollusca	276	8.780000000000001e-70	NTclustered	gi\|2572452079\|ref\|XR_009385380.1\|	109671	g3090	i0	93.122	2.81914893617021	189	11	100	2	1	188	3574	3761	PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA	blastn	530	276	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
24973673	24973673	PRJNA771359_S_NODE_4020_length_168_cov_2.129771_g3937_i0	PRJNA771359	4020	168	2.129771	3.57801528	Tegillarca granosa	220873	Mollusca	Mollusca	101	3.23e-23	NR	KAJ8304321.1	220873	g3937	i0	78.2	1.96428571428571	55	12	98.2	0	3	167	543	597	KAJ8304321.1 hypothetical protein KUTeg_017904 [Tegillarca granosa]	diamond	330	101	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Tegillarca	Tegillarca granosa
26745948	26745948	PRJNA771359_S_NODE_3261_length_186_cov_1.187919_g3178_i0	PRJNA771359	3261	186	1.187919	2.20952934	Metazoa	33208	Mollusca	Mollusca	60.5	9.48e-9	NR	XP_033726568.1	6579	g3178	i0	78.8	2.43548387096774	33	7	53.2	0	185	87	475	507	XP_033726568.1 inositol-3-phosphate synthase 1-A-like [Pecten maximus]	diamond	453	60.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
27347512	27347512	PRJNA771359_S_NODE_3023_length_193_cov_1.993590_g2940_i0	PRJNA771359	3023	193	1.99359	3.8476287	Opisthokonta	33154	Mollusca	Mollusca	55.1	1.93e-7	NR	KAJ8315837.1	220873	g2940	i0	58.5	4.46113989637306	41	17	63.7	0	193	71	100	140	KAJ8315837.1 hypothetical protein KUTeg_007987 [Tegillarca granosa]	diamond	861	55.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Tegillarca	Tegillarca granosa
29263626	29263626	PRJNA771359_S_NODE_2869_length_198_cov_1.279503_g2786_i0	PRJNA771359	2869	198	1.279503	2.53341594	Solemya velum	13268	Mollusca	Mollusca	53.1	4.43e-6	NR	KAL5005052.1	13268	g2786	i0	43.2	3.92424242424242	81	30	98.5	3	198	4	122	202	KAL5005052.1 hypothetical protein ScPMuIL_018508 [Solemya velum]	diamond	777	53.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum

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