metadata: contig_metadata: 6 rows where bioproject = "PRJEB49404" and tax

6 rows where bioproject = "PRJEB49404" 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
4818978	4818978	PRJEB49404_P_NODE_467124_length_191_cov_1.552632_g453323_i0	PRJEB49404	467124	191	1.552632	2.96552712	Magallana	147004	Mollusca	Mollusca	353	4.02e-93	NTclustered	gi\|28375710\|dbj\|AB102757.1\|	29159	g453323	i0	100	37.0471204188482	191	0	100	0	1	191	3554	3744	Crassostrea gigas genes for ITS2, 28S rRNA, partial sequence, country: Japan: Okinawa (Haneji inland sea)	blastn	7076	353	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
10303009	10303009	PRJEB49404_P_NODE_278429_length_278_cov_2.171548_g264628_i0	PRJEB49404	278429	278	2.171548	6.03690344	Bradybaena similaris	145626	Mollusca	Mollusca	420	6.09e-113	NTclustered	gi\|2913001816\|dbj\|AP039609.1\|	145626	g264628	i0	93.907	183.535971223022	279	15	100	2	1	278	1220	1497	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence	blastn	51023	420	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
14125519	14125519	PRJEB49404_P_NODE_215812_length_333_cov_5.204082_g202013_i0	PRJEB49404	215812	333	5.204082	17.32959306	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.031	NTclustered	gi\|2912999747\|dbj\|AP039606.1\|	145626	g202013	i0	100	0.0840840840840841	28	0	8	0	251	278	2800684	2800657	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
18842534	18842534	PRJEB49404_P_NODE_218315_length_331_cov_1.595890_g204516_i0	PRJEB49404	218315	331	1.59589	5.2823959	Arion	6542	Mollusca	Mollusca	612	1.14e-170	NTclustered	gi\|13794164\|gb\|AY014144.1\|	145126	g204516	i0	100	97.2507552870091	331	0	100	0	1	331	1320	990	Arion ater 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	32190	612	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Arionidae	Arion	Arion ater
30318428	30318428	PRJEB49404_P_NODE_363112_length_229_cov_4.689474_g349311_i0	PRJEB49404	363112	229	4.689474	10.73889546	Elysia marginata	1093978	Mollusca	Mollusca	49.3	5.83e-5	NR	GFR88427.1	1093978	g349311	i0	40	2.09606986899563	80	42	98.3	3	225	1	54	132	GFR88427.1 ribonuclease HI [Elysia marginata]	diamond	480	49.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
32563131	32563131	PRJEB49404_P_NODE_371759_length_226_cov_1.005348_g357958_i0	PRJEB49404	371759	226	1.005348	2.27208648	Mytilus edulis	6550	Mollusca	Mollusca	53.5	4.63e-6	NR	XP_071138770.1	6550	g357958	i0	45.1	0.942477876106195	71	39	94.2	0	214	2	145	215	XP_071138770.1 uncharacterized protein [Mytilus edulis]	diamond	213	53.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis

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