metadata: contig_metadata: 9 rows where bioproject = "PRJNA1245487", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA1245487", tax_clade = "Opisthokonta" 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
350956	350956	PRJNA1245487_P_NODE_18681_length_256_cov_1.699454_g18343_i0	PRJNA1245487	18681	256	1.699454	4.35060224	Pecten maximus	6579	Mollusca	Mollusca	95.3	3.81e-15	NTclustered	gi\|1835451240\|ref\|XR_004531328.1\|	6579	g18343	i0	92.647	34.93359375	68	2	26	3	84	150	1896	1961	PREDICTED: Pecten maximus large subunit ribosomal RNA (LOC117321358), rRNA	blastn	8943	95.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
4178430	4178430	PRJNA1245487_P_NODE_7264_length_457_cov_18.283854_g6928_i0	PRJNA1245487	7264	457	18.283854	83.55721278	Vertigo rugosula	1752689	Mollusca	Mollusca	837	0	NTclustered	gi\|952001315\|gb\|KT008332.1\|	1752689	g6928	i0	100	99.7768052516411	453	0	99	0	5	457	821	369	Vertigo rugosula 28S ribosomal RNA gene, partial sequence	blastn	45598	837	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Vertiginidae	Vertigo	Vertigo rugosula
7429150	7429150	PRJNA1245487_P_NODE_15306_length_289_cov_1.083333_g14968_i0	PRJNA1245487	15306	289	1.083333	3.13083237	Metazoa	33208	Mollusca	Mollusca	62.1	4.44e-5	NTclustered	gi\|2912981848\|dbj\|AP039587.1\|	145626	g14968	i0	100	1.13494809688581	33	0	11	0	1	33	21734579	21734547	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence	blastn	328	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15654067	15654067	PRJNA1245487_P_NODE_15313_length_288_cov_7.558140_g14975_i0	PRJNA1245487	15313	288	7.55814	21.7674432	Inflectarius rugeli	3111596	Mollusca	Mollusca	529	1.01e-145	NTclustered	gi\|2644119683\|gb\|PP069356.1\|	3111596	g14975	i0	100	152.642361111111	286	0	99	0	3	288	1204	919	Inflectarius rugeli isolate infr 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	43961	529	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Polygyridae	Inflectarius	Inflectarius rugeli
15654118	15654118	PRJNA1245487_P_NODE_19793_length_250_cov_1.604520_g19455_i0	PRJNA1245487	19793	250	1.60452	4.0113	Opisthokonta	33154	Mollusca	Mollusca	140	1.84e-39	NR	XP_050413940.1	6465	g19455	i0	74.4	92.496	82	21	98.4	0	3	248	100	181	XP_050413940.1 60S ribosomal protein L8 [Patella vulgata]	diamond	23124	141	0.99290780141844	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
16353671	16353671	PRJNA1245487_P_NODE_13093_length_318_cov_14.232653_g12755_i0	PRJNA1245487	13093	318	14.232653000000001	45.25983654	Metazoa	33208	Mollusca	Mollusca	588	1.84e-163	NTclustered	gi\|2572452079\|ref\|XR_009385380.1\|	109671	g12755	i0	100	53.2578616352201	318	0	100	0	1	318	1840	1523	PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA	blastn	16936	588	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
16353839	16353839	PRJNA1245487_P_NODE_22353_length_237_cov_37.152439_g22015_i0	PRJNA1245487	22353	237	37.152439	88.05128043	Gastropoda	6448	Mollusca	Mollusca	429	8.409999999999998e-116	NTclustered	gi\|973291008\|gb\|KU341311.1\|	6532	g22015	i0	99.574	151.713080168776	235	1	99	0	1	235	3189	3423	Limicolaria kambeul isolate O_lim_c 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	35956	429	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Achatinidae	Limicolaria	Limicolaria kambeul
19477304	19477304	PRJNA1245487_P_NODE_7136_length_462_cov_1.982005_g6800_i0	PRJNA1245487	7136	462	1.982005	9.1568631	Crassostrea virginica	6565	Mollusca	Mollusca	54.7	0.012	NTclustered	gi\|1242736601\|ref\|XM_022440247.1\|	6565	g6800	i0	96.97	0.0714285714285714	33	0	7	1	95	126	2708	2740	PREDICTED: Crassostrea virginica hypermethylated in cancer 2 protein-like (LOC111105807), transcript variant X1, mRNA	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
28431686	28431686	PRJNA1245487_P_NODE_22046_length_242_cov_0.923077_g21708_i0	PRJNA1245487	22046	242	0.923077	2.23384634	Bradybaena similaris	145626	Mollusca	Mollusca	124	2.69e-32	NR	BFZ17342.1	145626	g21708	i0	74.4	1.88429752066116	78	20	96.7	0	8	241	48	125	BFZ17342.1 hypothetical protein BsWGS_20383 [Bradybaena similaris]	diamond	456	124	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris

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