metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB75017" 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
3546133	3546133	PRJEB75017_P_NODE_18783_length_231_cov_2.443038_g18654_i0	PRJEB75017	18783	231	2.443038	5.64341778	Ctena	102298	Mollusca	Mollusca	130	9.27e-26	NTclustered	gi\|2125838800\|gb\|OL183269.1\|	881210	g18654	i0	91.489	8.91341991341991	94	8	41	0	138	231	4042	4135	Ctena bella voucher UF437018 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	2059	130	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Lucinida	Lucinidae	Ctena	Ctena bella
3961513	3961513	PRJEB75017_P_NODE_4464_length_414_cov_3.143695_g4335_i0	PRJEB75017	4464	414	3.143695	13.0148973	Physella acuta	109671	Mollusca	Mollusca	645	1.4399999999999993e-180	NTclustered	gi\|2572452079\|ref\|XR_009385380.1\|	109671	g4335	i0	94.737	4.7536231884058	418	16	100	6	1	414	3333	3748	PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA	blastn	1968	645	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
5237903	5237903	PRJEB75017_P_NODE_17405_length_244_cov_1.350877_g17276_i0	PRJEB75017	17405	244	1.350877	3.29613988	Patella vulgata	6465	Mollusca	Mollusca	174	4.5e-39	NTclustered	gi\|2506343379\|ref\|XM_050562084.2\|	6465	g17276	i0	79.675	1.00819672131148	246	46	100	4	1	244	377	620	PREDICTED: Patella vulgata sperm-associated antigen 6 (LOC126831543), mRNA	blastn	246	174	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
6513522	6513522	PRJEB75017_P_NODE_5926_length_362_cov_2.553633_g5797_i0	PRJEB75017	5926	362	2.553633	9.24415146	Perna viridis	73031	Mollusca	Mollusca	209	1.92e-49	NTclustered	gi\|56967588\|gb\|AY850128.1\|	73031	g5797	i0	93.662	0.392265193370166	142	6	39	2	181	320	169	29	Perna viridis clone GM8 microsatellite sequence	blastn	142	209	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Perna	Perna viridis
12474531	12474531	PRJEB75017_P_NODE_3050_length_502_cov_1.198135_g2921_i0	PRJEB75017	3050	502	1.198135	6.0146377	Metazoa	33208	Mollusca	Mollusca	315	5.67e-81	NTclustered	gi\|2506328437\|ref\|XM_050550622.2\|	6465	g2921	i0	78.2	19.9780876494024	500	103	99	6	1	497	336	832	PREDICTED: Patella vulgata eukaryotic initiation factor 4A-III (LOC126821950), mRNA	blastn	10029	315	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
12888951	12888951	PRJEB75017_P_NODE_4551_length_410_cov_1.623145_g4422_i0	PRJEB75017	4551	410	1.623145	6.6548945	Biomphalaria glabrata	6526	Mollusca	Mollusca	54.7	0.011	NTclustered	gi\|2502101643\|ref\|XM_013226731.2\|	6526	g4422	i0	92.105	0.641463414634146	38	3	9	0	72	109	2402	2365	PREDICTED: Biomphalaria glabrata protein mono-ADP-ribosyltransferase PARP6-like (LOC106067544), transcript variant X3, mRNA	blastn	263	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
15437912	15437912	PRJEB75017_P_NODE_9593_length_293_cov_1.418182_g9464_i0	PRJEB75017	9593	293	1.418182	4.15527326	Bradybaena similaris	145626	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2912981848\|dbj\|AP039587.1\|	145626	g9464	i0	100	0.102389078498294	30	0	10	0	263	292	37105207	37105236	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
20122099	20122099	PRJEB75017_P_NODE_9416_length_295_cov_4.130631_g9287_i0	PRJEB75017	9416	295	4.130631	12.18536145	Metazoa	33208	Mollusca	Mollusca	496	1.05e-135	NTclustered	gi\|2572452079\|ref\|XR_009385380.1\|	109671	g9287	i0	96.959	92.3016949152542	296	8	100	1	1	295	868	1163	PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA	blastn	27229	497	0.997987927565392	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta

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