metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA763243" 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
5846932	5846932	PRJNA763243_P_NODE_43645_length_268_cov_1.543590_g43299_i0	PRJNA763243	43645	268	1.54359	4.1368212	Argopecten irradians	31199	Mollusca	Mollusca	91.6	5.2e-14	NTclustered	gi\|2835350600\|ref\|XM_069247595.1\|	31199	g43299	i0	98.077	23.5410447761194	52	1	35	0	4	55	1391	1442	PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA	blastn	6309	91.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
7583129	7583129	PRJNA763243_P_NODE_13586_length_415_cov_1.514620_g13241_i0	PRJNA763243	13586	415	1.51462	6.285673	Metazoa	33208	Mollusca	Mollusca	756	0	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g13241	i0	99.518	99.978313253012	415	2	100	0	1	415	1182	1596	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	41491	756	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
8858364	8858364	PRJNA763243_P_NODE_4507_length_657_cov_1.736301_g4199_i0	PRJNA763243	4507	657	1.736301	11.40749757	Metazoa	33208	Mollusca	Mollusca	1203	0	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g4199	i0	99.847	99.738203957382	654	1	99	0	1	654	678	25	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	65528	1208	0.995860927152318	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
22420908	22420908	PRJNA763243_P_NODE_54798_length_248_cov_1.760000_g54452_i0	PRJNA763243	54798	248	1.76	4.3648	Bradybaena similaris	145626	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2912983111\|dbj\|AP039588.1\|	145626	g54452	i0	96.97	0.483870967741935	33	1	13	0	9	41	23183629	23183661	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence	blastn	120	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
23696782	23696782	PRJNA763243_P_NODE_63639_length_241_cov_0.916667_g63293_i0	PRJNA763243	63639	241	0.916667	2.20916747	Mercenaria mercenaria	6596	Mollusca	Mollusca	69.4	2.15e-7	NTclustered	gi\|2442051071\|ref\|XM_053540373.1\|	6596	g63293	i0	87.5	3.04149377593361	64	3	27	4	141	204	9539	9597	PREDICTED: Mercenaria mercenaria E3 ubiquitin-protein ligase rnf213-alpha-like (LOC123550949), transcript variant X6, mRNA	blastn	733	69.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria

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