metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA312899" 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
1655286	1655286	PRJNA312899_P_NODE_98542_length_162_cov_1.752212_g98100_i0	PRJNA312899	98542	162	1.752212	2.83858344	Haliotis asinina	109174	Mollusca	Mollusca	62.1	2.24e-5	NTclustered	gi\|2793385654\|ref\|XM_067804507.1\|	109174	g98100	i0	97.222	0.401234567901235	36	1	22	0	42	77	535	500	PREDICTED: Haliotis asinina integumentary mucin C.1-like (LOC137272154), mRNA	blastn	65	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
2929768	2929768	PRJNA312899_P_NODE_18023_length_444_cov_30.255696_g17582_i0	PRJNA312899	18023	444	30.255696	134.33529024	Mytilus californianus	6549	Mollusca	Mollusca	52.8	0.043	NTclustered	gi\|2334633076\|ref\|XM_052224487.1\|	6549	g17582	i0	100	1.32432432432432	28	0	6	0	79	106	5525	5498	PREDICTED: Mytilus californianus uncharacterized protein KIAA2012 homolog (LOC127718464), transcript variant X1, mRNA	blastn	588	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
2930220	2930220	PRJNA312899_P_NODE_43503_length_268_cov_8.242009_g43061_i0	PRJNA312899	43503	268	8.242009	22.08858412	Dreissena polymorpha	45954	Mollusca	Mollusca	52.8	0.025	NTclustered	gi\|2364543138\|ref\|XM_052375653.1\|	45954	g43061	i0	100	0.104477611940299	28	0	10	0	71	98	3636	3663	PREDICTED: Dreissena polymorpha A disintegrin and metalloproteinase with thrombospondin motifs 16-like (LOC127845031), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
2930799	2930799	PRJNA312899_P_NODE_76723_length_184_cov_1.133333_g76281_i0	PRJNA312899	76723	184	1.133333	2.08533272	Haliotis asinina	109174	Mollusca	Mollusca	52.8	0.016	NTclustered	gi\|2793384063\|ref\|XM_067803260.1\|	109174	g76281	i0	100	0.304347826086957	28	0	15	0	72	99	1283	1256	PREDICTED: Haliotis asinina uncharacterized protein (LOC137268671), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
4892707	4892707	PRJNA312899_P_NODE_68324_length_197_cov_2.756757_g67882_i0	PRJNA312899	68324	197	2.756757	5.43081129	Metazoa	33208	Mollusca	Mollusca	56.5	0.001	NTclustered	gi\|2334722168\|ref\|XM_052247935.1\|	6549	g67882	i0	96.97	4.83248730964467	33	1	17	0	29	61	4525	4493	PREDICTED: Mytilus californianus nidogen-2-like (LOC127737333), mRNA	blastn	952	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
8032728	8032728	PRJNA312899_P_NODE_38467_length_289_cov_7.616667_g38025_i0	PRJNA312899	38467	289	7.616667	22.01216763	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.027	NTclustered	gi\|2912995509\|dbj\|AP039600.1\|	145626	g38025	i0	100	0.0968858131487889	28	0	10	0	145	172	1816937	1816964	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
9307794	9307794	PRJNA312899_P_NODE_55068_length_231_cov_3.642857_g54626_i0	PRJNA312899	55068	231	3.642857	8.41499967	Haliotis asinina	109174	Mollusca	Mollusca	52.8	0.021	NTclustered	gi\|2793419543\|ref\|XM_067822791.1\|	109174	g54626	i0	100	0.121212121212121	28	0	12	0	163	190	2005	2032	PREDICTED: Haliotis asinina guanine nucleotide-exchange factor SEC12-like (LOC137291442), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
20781062	20781062	PRJNA312899_P_NODE_41577_length_276_cov_1.797357_g41135_i0	PRJNA312899	41577	276	1.797357	4.96070532	Bradybaena similaris	145626	Mollusca	Mollusca	167	8.689999999999999e-37	NTclustered	gi\|2913002622\|dbj\|AP039641.1\|	145626	g41135	i0	83.152	0.666666666666667	184	30	67	1	91	274	22512	22330	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored32, sequence	blastn	184	167	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
22056315	22056315	PRJNA312899_P_NODE_58298_length_222_cov_2.947977_g57856_i0	PRJNA312899	58298	222	2.947977	6.54450894	Dreissena polymorpha	45954	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2364524360\|ref\|XM_052370887.1\|	45954	g57856	i0	97.059	1.66666666666667	34	0	15	1	179	211	1257	1290	PREDICTED: Dreissena polymorpha uncharacterized LOC127841802 (LOC127841802), mRNA	blastn	370	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha

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