metadata: contig_metadata: 5 rows where bioproject = "PRJNA879314" and tax

5 rows where bioproject = "PRJNA879314" 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
2133274	2133274	PRJNA879314_P_NODE_9282_length_245_cov_0.906977_g9232_i0	PRJNA879314	9282	245	0.906977	2.22209365	Magallana gigas	29159	Mollusca	Mollusca	444	3.12e-120	NTclustered	gi\|2751243569\|ref\|XM_011431282.3\|	29159	g9232	i0	99.588	16.9469387755102	243	1	99	0	1	243	1149	1391	PREDICTED: Magallana gigas beclin-1 (LOC105329824), mRNA	blastn	4152	444	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
26833865	26833865	PRJNA879314_P_NODE_10041_length_244_cov_0.912281_g9991_i0	PRJNA879314	10041	244	0.912281	2.22596564	Gigantopelta aegis	1735272	Mollusca	Mollusca	152	1.51e-42	NR	XP_041355216.1	1735272	g9991	i0	80	24.7377049180328	80	16	98.4	0	240	1	94	173	XP_041355216.1 LIM and senescent cell antigen-like-containing domain protein 1 isoform X7 [Gigantopelta aegis]	diamond	6036	152	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
28421539	28421539	PRJNA879314_P_NODE_3886_length_264_cov_1.361257_g3836_i0	PRJNA879314	3886	264	1.361257	3.59371848	Metazoa	33208	Mollusca	Mollusca	119	4e-29	NR	XP_050411292.1	6465	g3836	i0	64	7.86363636363636	86	31	97.7	0	2	259	576	661	XP_050411292.1 ras and EF-hand domain-containing protein homolog isoform X5 [Patella vulgata]	diamond	2076	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
28610799	28610799	PRJNA879314_P_NODE_2707_length_296_cov_1.399103_g2657_i0	PRJNA879314	2707	296	1.399103	4.14134488	Metazoa	33208	Mollusca	Mollusca	61.6	1.46e-8	NR	XP_045209457.2	6596	g2657	i0	37.9	1.75337837837838	87	45	80.1	4	48	284	82	167	XP_045209457.2 thyroglobulin-like [Mercenaria mercenaria]	diamond	519	61.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
29139781	29139781	PRJNA879314_P_NODE_5069_length_252_cov_0.871508_g5019_i0	PRJNA879314	5069	252	0.871508	2.19620016	Mytilus edulis	6550	Mollusca	Mollusca	53.9	5.09e-6	NR	CAG2243592.1	6550	g5019	i0	35.2	5	71	45	84.5	1	237	25	1078	1147	CAG2243592.1 PARP2_3_4 [Mytilus edulis]	diamond	1260	53.9	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);;