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

9 rows where analysis = "blastn", bioproject = "PRJNA745553" 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
724000	724000	PRJNA745553_S_NODE_11581_length_359_cov_33.755245_g11386_i0	PRJNA745553	11581	359	33.755245	121.18132955	Haliotis rubra	36100	Mollusca	Mollusca	58.4	7.31e-4	NTclustered	gi\|2194079676\|ref\|XM_046725280.1\|	36100	g11386	i0	94.737	0.105849582172702	38	1	11	1	97	134	316	352	PREDICTED: Haliotis rubra ecdysone-induced protein 75B-like (LOC124288704), mRNA	blastn	38	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
724306	724306	PRJNA745553_S_NODE_29521_length_217_cov_7.465278_g29326_i0	PRJNA745553	29521	217	7.465278	16.19965326	Crassostrea virginica	6565	Mollusca	Mollusca	52.8	0.019	NTclustered	gi\|1242809517\|ref\|XM_022489879.1\|	6565	g29326	i0	100	0.129032258064516	28	0	13	0	5	32	403	376	PREDICTED: Crassostrea virginica probable ATP-dependent RNA helicase DDX27 (LOC111138077), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
724405	724405	PRJNA745553_S_NODE_6901_length_449_cov_5.795213_g6707_i0	PRJNA745553	6901	449	5.795213	26.02050637	Mytilus californianus	6549	Mollusca	Mollusca	58.4	0.001	NTclustered	gi\|2334630686\|ref\|XR_007989291.1\|	6549	g6707	i0	97.059	0.0757238307349666	34	1	8	0	359	392	160	127	PREDICTED: Mytilus californianus uncharacterized LOC127717681 (LOC127717681), ncRNA	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
9652490	9652490	PRJNA745553_S_NODE_12528_length_347_cov_1.992701_g12333_i0	PRJNA745553	12528	347	1.992701	6.91467247	Haliotis rubra	36100	Mollusca	Mollusca	52.8	0.033	NTclustered	gi\|2194124140\|ref\|XM_046718080.1\|	36100	g12333	i0	100	0.0806916426512968	28	0	8	0	114	141	402	429	PREDICTED: Haliotis rubra uncharacterized LOC124282110 (LOC124282110), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
10928045	10928045	PRJNA745553_S_NODE_13669_length_333_cov_1.130769_g13474_i0	PRJNA745553	13669	333	1.130769	3.76546077	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	52.8	0.031	NTclustered	gi\|1207949258\|ref\|XM_021508902.1\|	6573	g13474	i0	100	0.168168168168168	28	0	8	0	227	254	2031	2058	PREDICTED: Mizuhopecten yessoensis major vault protein-like (LOC110457569), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
10928378	10928378	PRJNA745553_S_NODE_5709_length_481_cov_7.156863_g5515_i0	PRJNA745553	5709	481	7.156863	34.42451103	Lottia digitalis	225159	Mollusca	Mollusca	150	1.6199999999999998e-31	NTclustered	gi\|82697844\|gb\|DQ248942.1\|	225159	g5515	i0	91.667	22.7713097713098	108	9	22	0	351	458	4809	4702	Lottia digitalis external transcribed spacer 1, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and external transcribed spacer 2, complete sequence	blastn	10953	150	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia digitalis
17302326	17302326	PRJNA745553_S_NODE_24394_length_250_cov_11.796610_g24199_i0	PRJNA745553	24394	250	11.79661	29.491525	Anadara broughtonii	148819	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2170965484\|dbj\|LC593126.1\|	148819	g24199	i0	100	0.46	30	0	12	0	221	250	58	29	Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds	blastn	115	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Anadara	Anadara broughtonii
20325142	20325142	PRJNA745553_S_NODE_27416_length_237_cov_2.054878_g27221_i0	PRJNA745553	27416	237	2.054878	4.87006086	Stylommatophora	6527	Mollusca	Mollusca	292	1.15e-74	NTclustered	gi\|1700712081\|gb\|MN022672.1\|	145599	g27221	i0	94.681	75.8143459915612	188	10	79	0	23	210	1122	1309	Vitrina pellucida 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	17968	292	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Vitrinidae	Vitrina	Vitrina pellucida
24950824	24950824	PRJNA745553_S_NODE_28460_length_229_cov_5.256410_g28265_i0	PRJNA745553	28460	229	5.25641	12.0371789	Physella acuta	109671	Mollusca	Mollusca	106	1.55e-18	NTclustered	gi\|2572320127\|ref\|XM_059297186.1\|	109671	g28265	i0	86.458	13.1310043668122	96	13	42	0	1	96	1365	1460	PREDICTED: Physella acuta tubulin alpha-1A chain (LOC131938941), mRNA	blastn	3007	106	1	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);;