metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA839281" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA839281" 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
27591994	27591994	PRJNA839281_S_NODE_5304_length_377_cov_0.865854_g5035_i0	PRJNA839281	5304	377	0.865854	3.26426958	Mytilus coruscus	42192	Mollusca	Mollusca	45.1	0.0252	NR	CAC5393896.1	42192	g5035	i0	27.2	2.72148541114058	114	72	89.1	2	42	377	587	691	CAC5393896.1 RASA3 [Mytilus coruscus]	diamond	1026	45.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
27939210	27939210	PRJNA839281_S_NODE_29945_length_165_cov_0.879310_g29676_i0	PRJNA839281	29945	165	0.87931	1.4508615	Littorina saxatilis	31220	Mollusca	Mollusca	43.5	0.00364	NR	XP_070187882.1	31220	g29676	i0	34	1.92727272727273	53	35	96.4	0	160	2	50	102	XP_070187882.1 troponin C-like isoform X1 [Littorina saxatilis]	diamond	318	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
28705458	28705458	PRJNA839281_S_NODE_31767_length_164_cov_0.886957_g31498_i0	PRJNA839281	31767	164	0.886957	1.45460948	Unionidae	47526	Mollusca	Mollusca	61.2	3.68e-9	NR	KAL3852768.1	1069815	g31498	i0	53.7	4.0609756097561	54	22	93.3	1	11	163	15	68	KAL3852768.1 hypothetical protein ACJMK2_016384 [Sinanodonta woodiana]	diamond	666	61.6	0.993506493506494	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Sinanodonta	Sinanodonta woodiana
30054504	30054504	PRJNA839281_S_NODE_7491_length_295_cov_1.154472_g7222_i0	PRJNA839281	7491	295	1.154472	3.4056924	Acanthosepion pharaonis	158019	Mollusca	Mollusca	139	1.33e-38	NR	CAE1138328.1	158019	g7222	i0	68.8	0.945762711864407	93	29	94.6	0	293	15	165	257	CAE1138328.1 EEF1D [Acanthosepion pharaonis]	diamond	279	139	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
30244378	30244378	PRJNA839281_S_NODE_25072_length_170_cov_1.685950_g24803_i0	PRJNA839281	25072	170	1.68595	2.866115	Pecten maximus	6579	Mollusca	Mollusca	60.5	3.34e-9	NR	XP_033737715.1	6579	g24803	i0	58.2	8.7529411764705891	55	23	97.1	0	169	5	26	80	XP_033737715.1 BTB/POZ domain-containing protein KCTD5-like [Pecten maximus]	diamond	1488	60.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
30686455	30686455	PRJNA839281_S_NODE_8893_length_267_cov_1.238532_g8624_i0	PRJNA839281	8893	267	1.238532	3.30688044	Lymnaea stagnalis	6523	Mollusca	Mollusca	55.5	1.6e-6	NR	CAL1528756.1	6523	g8624	i0	53.3	0.50561797752809	45	21	50.6	0	266	132	357	401	CAL1528756.1 unnamed protein product [Lymnaea stagnalis]	diamond	135	55.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis

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