metadata: contig_metadata: 11 rows where bioproject = "PRJNA1034994", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJNA1034994", tax_kingdom = "Metazoa" 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
1007557	1007557	PRJNA1034994_P_NODE_3061_length_295_cov_2.135135_g2977_i0	PRJNA1034994	3061	295	2.135135	6.29864825	Stylommatophora	6527	Mollusca	Mollusca	540	4.79e-149	NTclustered	gi\|45360329\|gb\|AY546382.1\|	42349	g2977	i0	99.661	153.067796610169	295	1	100	0	1	295	70	364	Albinaria caerulea 18S ribosomal RNA gene, partial sequence	blastn	45155	545	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Clausiliidae	Albinaria	Albinaria caerulea
1442977	1442977	PRJNA1034994_P_NODE_3822_length_283_cov_1.361905_g3738_i0	PRJNA1034994	3822	283	1.361905	3.85419115	Magallana gigas	29159	Mollusca	Mollusca	167	8.94e-37	NTclustered	gi\|345105475\|gb\|HQ225835.1\|	29159	g3738	i0	91.129	2.09187279151943	124	10	44	1	37	160	726	848	Crassostrea gigas Ecsit gene, complete cds	blastn	592	167	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
2718685	2718685	PRJNA1034994_P_NODE_4383_length_276_cov_1.487685_g4299_i0	PRJNA1034994	4383	276	1.487685	4.1060106	Littorina saxatilis	31220	Mollusca	Mollusca	337	6.259999999999998e-88	NTclustered	gi\|2868610424\|ref\|XM_070346807.1\|	31220	g4299	i0	88.971	97.5326086956522	272	30	99	0	5	276	694	965	PREDICTED: Littorina saxatilis tubulin beta chain (LOC138974109), mRNA	blastn	26919	337	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
3994792	3994792	PRJNA1034994_P_NODE_5784_length_260_cov_1.459893_g5700_i0	PRJNA1034994	5784	260	1.459893	3.7957218	Magallana gigas	29159	Mollusca	Mollusca	340	4.52e-89	NTclustered	gi\|2751238414\|ref\|XM_034445695.2\|	29159	g5700	i0	90.805	78.9384615384615	261	15	99	8	2	260	1124	1377	PREDICTED: Magallana gigas vacuolar protein sorting-associated protein 26C (LOC105338206), mRNA	blastn	20524	340	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
6546317	6546317	PRJNA1034994_P_NODE_8706_length_245_cov_0.895349_g8622_i0	PRJNA1034994	8706	245	0.895349	2.19360505	Magallana gigas	29159	Mollusca	Mollusca	174	4.52e-39	NTclustered	gi\|270063416\|gb\|GU207409.1\|	29159	g8622	i0	96.226	17.730612244898	106	4	44	0	1	106	109512	109407	Crassostrea gigas clone CG_Ba133H22, complete sequence	blastn	4344	174	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
12921974	12921974	PRJNA1034994_P_NODE_6511_length_252_cov_1.424581_g6427_i0	PRJNA1034994	6511	252	1.424581	3.58994412	Crassostrea ariakensis	3244846	Mollusca	Mollusca	255	1.62e-63	NTclustered	gi\|2707226357\|gb\|OQ989496.1\|	94323	g6427	i0	94.545	33.2619047619048	165	9	65	0	36	200	165	1	Crassostrea ariakensis clone CarSat27 satellite sequence	blastn	8382	255	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea ariakensis
18020093	18020093	PRJNA1034994_P_NODE_4515_length_274_cov_1.875622_g4431_i0	PRJNA1034994	4515	274	1.875622	5.13920428	Magallana gigas	29159	Mollusca	Mollusca	119	2.45e-22	NTclustered	gi\|2751270021\|ref\|XM_066083700.1\|	29159	g4431	i0	97.143	2.04379562043796	70	2	26	0	1	70	1514	1583	PREDICTED: Magallana gigas rho GTPase-activating protein 18 (LOC105325008), transcript variant X2, mRNA	blastn	560	119	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
21845141	21845141	PRJNA1034994_P_NODE_5258_length_265_cov_4.406250_g5174_i0	PRJNA1034994	5258	265	4.40625	11.6765625	Vallonia costata	145157	Mollusca	Mollusca	483	7.249999999999998e-132	NTclustered	gi\|37703589\|gb\|AY189456.1\|	145157	g5174	i0	99.621	99.6528301886792	264	1	99	0	2	265	452	189	Vallonia costata 28S ribosomal RNA gene, partial sequence	blastn	26408	483	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Valloniidae	Vallonia	Vallonia costata
24394370	24394370	PRJNA1034994_P_NODE_9500_length_243_cov_0.905882_g9416_i0	PRJNA1034994	9500	243	0.905882	2.20129326	Magallana angulata	2784310	Mollusca	Mollusca	147	9.77e-31	NTclustered	gi\|2416929300\|ref\|XM_052852571.1\|	2784310	g9416	i0	91.743	6.2962962962963	109	4	43	2	1	104	4053	3945	PREDICTED: Crassostrea angulata uncharacterized LOC128183530 (LOC128183530), mRNA	blastn	1530	147	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana angulata
25233810	25233810	PRJNA1034994_P_NODE_5900_length_259_cov_1.241935_g5816_i0	PRJNA1034994	5900	259	1.241935	3.21661165	Magallana	147004	Mollusca	Mollusca	435	2e-117	NTclustered	gi\|2751299250\|ref\|XM_011449907.4\|	29159	g5816	i0	96.911	2	259	8	100	0	1	259	266	8	PREDICTED: Magallana gigas noggin-2 (LOC105342853), mRNA	blastn	518	435	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
31322633	31322633	PRJNA1034994_P_NODE_3935_length_281_cov_2.163462_g3851_i0	PRJNA1034994	3935	281	2.163462	6.07932822	Mollusca	6447	Mollusca	Mollusca	59.3	4.16e-8	NR	XP_046379194.1	6454	g3851	i0	69.8	5.50889679715302	43	13	45.9	0	267	139	34	76	XP_046379194.1 X-box-binding protein 1-like [Haliotis rufescens]	diamond	1548	59.7	0.993299832495812	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens

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