metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1199330" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1199330" 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
4153284	4153284	PRJNA1199330_P_NODE_96124_length_257_cov_1.695652_g95425_i0	PRJNA1199330	96124	257	1.695652	4.35782564	Patella vulgata	6465	Mollusca	Mollusca	54.7	0.006	NTclustered	gi\|2506336394\|ref\|XM_050557667.2\|	6465	g95425	i0	100	0.11284046692607	29	0	11	0	78	106	179	151	PREDICTED: Patella vulgata uncharacterized LOC126828090 (LOC126828090), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
5429158	5429158	PRJNA1199330_P_NODE_69105_length_282_cov_2.971292_g68406_i0	PRJNA1199330	69105	282	2.971292	8.37904344	Bradybaena similaris	145626	Mollusca	Mollusca	84.2	9.22e-12	NTclustered	gi\|2912991694\|dbj\|AP039596.1\|	145626	g68406	i0	84.706	9.97163120567376	85	12	30	1	4	88	47781393	47781476	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence	blastn	2812	84.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
5429388	5429388	PRJNA1199330_P_NODE_85545_length_267_cov_2.365979_g84846_i0	PRJNA1199330	85545	267	2.365979	6.31716393	Octopus sinensis	2607531	Mollusca	Mollusca	60.2	1.46e-4	NTclustered	gi\|1914611999\|ref\|XM_029800976.2\|	2607531	g84846	i0	97.222	0.134831460674157	36	0	13	1	10	45	1839	1873	PREDICTED: Octopus sinensis growth hormone secretagogue receptor type 1-like (LOC115230855), mRNA	blastn	36	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
11247464	11247464	PRJNA1199330_P_NODE_31069_length_371_cov_2.063758_g30373_i0	PRJNA1199330	31069	371	2.063758	7.65654218	Ostreidae	6563	Mollusca	Mollusca	52.8	0.035	NTclustered	gi\|2628509917\|ref\|XM_061331651.1\|	191078	g30373	i0	100	0.528301886792453	28	0	8	0	205	232	2777	2750	PREDICTED: Saccostrea echinata uncharacterized LOC133195721 (LOC133195721), transcript variant X1, mRNA	blastn	196	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
15072157	15072157	PRJNA1199330_P_NODE_68212_length_283_cov_2.219048_g67513_i0	PRJNA1199330	68212	283	2.219048	6.27990584	Opisthokonta	33154	Mollusca	Mollusca	254	6.67e-63	NTclustered	gi\|2616605728\|ref\|XM_060728348.1\|	129788	g67513	i0	83.094	77.773851590106	278	47	98	0	4	281	106	383	PREDICTED: Ruditapes philippinarum tubulin beta chain-like (LOC132740444), mRNA	blastn	22010	254	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
15627792	15627792	PRJNA1199330_P_NODE_113433_length_244_cov_0.912281_g112734_i0	PRJNA1199330	113433	244	0.912281	2.22596564	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2912990805\|dbj\|AP039595.1\|	145626	g112734	i0	100	0.459016393442623	28	0	11	0	205	232	46453714	46453741	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15628561	15628561	PRJNA1199330_P_NODE_51773_length_301_cov_2.780702_g51074_i0	PRJNA1199330	51773	301	2.780702	8.36991302	Bradybaena similaris	145626	Mollusca	Mollusca	65.8	3.6e-6	NTclustered	gi\|2913001816\|dbj\|AP039609.1\|	145626	g51074	i0	97.368	0.694352159468439	38	1	13	0	24	61	32069438	32069475	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence	blastn	209	65.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
18177844	18177844	PRJNA1199330_P_NODE_85415_length_267_cov_2.855670_g84716_i0	PRJNA1199330	85415	267	2.85567	7.6246389	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	5.25e-4	NTclustered	gi\|2912983111\|dbj\|AP039588.1\|	145626	g84716	i0	97.059	0.47565543071161	34	1	13	0	191	224	87240492	87240459	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence	blastn	127	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
20726329	20726329	PRJNA1199330_P_NODE_109357_length_247_cov_0.896552_g108658_i0	PRJNA1199330	109357	247	0.896552	2.21448344	Bradybaena similaris	145626	Mollusca	Mollusca	63.9	1.03e-5	NTclustered	gi\|2912986657\|dbj\|AP039591.1\|	145626	g108658	i0	93.023	0.59919028340081	43	3	17	0	20	62	66173504	66173546	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence	blastn	148	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
23996557	23996557	PRJNA1199330_P_NODE_66939_length_284_cov_2.829384_g66240_i0	PRJNA1199330	66939	284	2.829384	8.03545056	Metazoa	33208	Mollusca	Mollusca	58.4	5.64e-4	NTclustered	gi\|2427230549\|ref\|XM_052966002.1\|	37653	g66240	i0	94.595	5.63380281690141	37	2	13	0	40	76	1271	1235	PREDICTED: Octopus bimaculoides uncharacterized LOC106875510 (LOC106875510), transcript variant X1, mRNA	blastn	1600	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides

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