metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax_clade = "Embryophyta"

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
16214090	16214090	PRJNA934472_P_NODE_31273_length_266_cov_1.383420_g30895_i0	PRJNA934472	31273	266	1.38342	3.6798972	Eukaryota	2759	Plants	Plants	141	9.21e-41	NR	XP_022985893.1	3661	g30895	i0	85.2	1761.64285714286	88	12	98.1	1	4	264	31	118	XP_022985893.1 histone H3.2-like [Cucurbita maxima]	diamond	468597	141	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Cucurbita	Cucurbita maxima
26683667	26683667	PRJNA934472_P_NODE_23261_length_304_cov_1.194805_g22883_i0	PRJNA934472	23261	304	1.194805	3.6322072	Triticum	4564	Plants	Plants	71.6	5.31e-12	NR	NP_001392005.1	4565	g22883	i0	54.2	2.84210526315789	72	31	69.1	1	297	88	431	502	NP_001392005.1 protein disulfide-isomerase precursor [Triticum aestivum]	diamond	864	71.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
27182810	27182810	PRJNA934472_P_NODE_39062_length_239_cov_25.572289_g38684_i0	PRJNA934472	39062	239	25.572289	61.11777071	Lilium longiflorum	4690	Plants	Plants	47	2.58e-4	NR	ABO20848.1	4690	g38684	i0	59	1.88284518828452	39	14	46.4	1	127	237	60	98	ABO20848.1 cytochrome P450-like TBP protein, partial [Lilium longiflorum]	diamond	450	47	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Liliales	Liliaceae	Lilium	Lilium longiflorum
27372955	27372955	PRJNA934472_P_NODE_36563_length_247_cov_1.396552_g36185_i0	PRJNA934472	36563	247	1.396552	3.44948344	Smallanthus sonchifolius	185202	Plants	Plants	50.1	9.23e-5	NR	KAI3797058.1	185202	g36185	i0	45.7	2.13765182186235	46	25	55.9	0	108	245	100	145	KAI3797058.1 hypothetical protein L1987_39748 [Smallanthus sonchifolius]	diamond	528	50.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Smallanthus	Smallanthus sonchifolius
30719987	30719987	PRJNA934472_P_NODE_38514_length_242_cov_0.911243_g38136_i0	PRJNA934472	38514	242	0.911243	2.20520806	Sphagnum balticum	128184	Plants	Plants	151	2.43e-44	NR	CAM6005584.1	128184	g38136	i0	92.1	0.942148760330578	76	6	94.2	0	1	228	132	207	CAM6005584.1 unnamed protein product [Sphagnum balticum]	diamond	228	151	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
31004477	31004477	PRJNA934472_P_NODE_38174_length_243_cov_0.905882_g37796_i0	PRJNA934472	38174	243	0.905882	2.20129326	Cinnamomum micranthum f. kanehirae	337451	Plants	Plants	154	4.29e-42	NR	RWR76367.1	337451	g37796	i0	98.8	2	81	1	100	0	1	243	64	144	RWR76367.1 Pectinesterase domain-containing protein/PMEI domain-containing protein [Cinnamomum micranthum f. kanehirae]	diamond	486	154	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Laurales	Lauraceae	Cinnamomum	Cinnamomum micranthum
31106136	31106136	PRJNA934472_P_NODE_27015_length_284_cov_1.402844_g26637_i0	PRJNA934472	27015	284	1.402844	3.98407696	Solanaceae	4070	Plants	Plants	79.7	3.46e-15	NR	XP_055804236.1	45834	g26637	i0	40.8	5.34507042253521	103	52	99.3	1	282	1	90	192	XP_055804236.1 zingipain-2-like [Solanum dulcamara]	diamond	1518	80.5	0.990062111801242	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum dulcamara
32522979	32522979	PRJNA934472_P_NODE_33299_length_258_cov_1.259459_g32921_i0	PRJNA934472	33299	258	1.259459	3.24940422	Sphagnum balticum	128184	Plants	Plants	75.5	6.55e-14	NR	CAM6000927.1	128184	g32921	i0	66.7	0.558139534883721	48	16	55.8	0	251	108	258	305	CAM6000927.1 unnamed protein product [Sphagnum balticum]	diamond	144	75.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum

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