metadata: contig_metadata: 4 rows where bioproject = "PRJNA1093380" and tax

4 rows where bioproject = "PRJNA1093380" 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
4025874	4025874	PRJNA1093380_P_NODE_7784_length_274_cov_1.975124_g7678_i0	PRJNA1093380	7784	274	1.975124	5.41183976	Octopus sinensis	2607531	Mollusca	Mollusca	135	2.43e-27	NTclustered	gi\|1914622278\|ref\|XM_029795136.2\|	2607531	g7678	i0	88.393	8.7992700729927	112	13	41	0	1	112	1494	1605	PREDICTED: Octopus sinensis tubulin alpha-1B chain (LOC115224301), mRNA	blastn	2411	135	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
5302045	5302045	PRJNA1093380_P_NODE_5365_length_289_cov_1.365741_g5259_i0	PRJNA1093380	5365	289	1.365741	3.94699149	root	1	Root_unresolved	Root_unresolved	100	3.69e-22	NR	XP_046339332.1	6454	g5259	i0	88.9	49.3598615916955	54	6	56.1	0	162	1	107	160	XP_046339332.1 succinyl-CoA:3-ketoacid coenzyme A transferase 1, mitochondrial-like [Haliotis rufescens]	diamond	14265	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
28480177	28480177	PRJNA1093380_P_NODE_12246_length_250_cov_2.237288_g12140_i0	PRJNA1093380	12246	250	2.237288	5.59322	Opisthokonta	33154	Mollusca	Mollusca	80.5	6.31e-17	NR	XP_034331477.1	29159	g12140	i0	71.4	15.12	63	18	75.6	0	3	191	52	114	XP_034331477.1 large ribosomal subunit protein eL24 [Magallana gigas]	diamond	3780	80.9	0.995055624227441	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
32817245	32817245	PRJNA1093380_P_NODE_6980_length_279_cov_1.495146_g6874_i0	PRJNA1093380	6980	279	1.495146	4.17145734	Littorina saxatilis	31220	Mollusca	Mollusca	58.9	1.16e-7	NR	XP_070213146.1	31220	g6874	i0	39.8	1.89247311827957	88	50	94.6	2	4	267	225	309	XP_070213146.1 flavin-containing monooxygenase 5-like [Littorina saxatilis]	diamond	528	58.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis

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