metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA380416" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA380416" 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
10605779	10605779	PRJNA380416_P_NODE_4809_length_267_cov_1.183486_g4662_i0	PRJNA380416	4809	267	1.183486	3.15990762	root	1	Root_unresolved	Root_unresolved	93.2	7.95e-20	NR	CAK9251395.1	128206	g4662	i0	74.2	1.48314606741573	66	14	74.2	1	68	265	449	511	CAK9251395.1 unnamed protein product, partial [Sphagnum jensenii]	diamond	396	93.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum jensenii
21475824	21475824	PRJNA380416_P_NODE_1657_length_476_cov_2.313817_g1511_i0	PRJNA380416	1657	476	2.313817	11.01376892	Sphagnum balticum	128184	Plants	Plants	228	1.86e-74	NR	CAM6001409.1	128184	g1511	i0	83.8	0.819327731092437	130	21	81.9	0	462	73	1	130	CAM6001409.1 unnamed protein product [Sphagnum balticum]	diamond	390	228	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
26711927	26711927	PRJNA380416_P_NODE_13041_length_163_cov_0.894737_g12894_i0	PRJNA380416	13041	163	0.894737	1.45842131	Eukaryota	2759	Plants	Plants	92.4	9.5e-21	NR	XP_009790687.1	4096	g12894	i0	71.7	31.2147239263804	53	15	97.5	0	5	163	151	203	XP_009790687.1 serine/threonine-protein phosphatase PP1 isozyme 9-like [Nicotiana sylvestris]	diamond	5088	92.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Nicotiana	Nicotiana sylvestris
27864578	27864578	PRJNA380416_P_NODE_10465_length_175_cov_0.976190_g10318_i0	PRJNA380416	10465	175	0.97619	1.7083325	Sphagnum fallax	53036	Plants	Plants	92	3.47e-21	NR	KAH8942775.1	53036	g10318	i0	67.2	1.98857142857143	58	19	99.4	0	174	1	99	156	KAH8942775.1 hypothetical protein BDL97_13G012400 [Sphagnum fallax]	diamond	348	92	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum fallax
28117182	28117182	PRJNA380416_P_NODE_5605_length_245_cov_0.867347_g5458_i0	PRJNA380416	5605	245	0.867347	2.12500015	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	59.3	5.4e-8	NR	BAK03058.1	112509	g5458	i0	36.5	1.04081632653061	85	50	99.2	1	244	2	93	177	BAK03058.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	255	59.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
29554943	29554943	PRJNA380416_P_NODE_6310_length_229_cov_1.127778_g6163_i0	PRJNA380416	6310	229	1.127778	2.58261162	root	1	Root_unresolved	Root_unresolved	100	7.61e-25	NR	VVW86319.1	210225	g6163	i0	61.3	4.91266375545852	75	29	98.3	0	2	226	5	79	VVW86319.1 unnamed protein product, partial [Nymphaea colorata]	diamond	1125	100	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
30106494	30106494	PRJNA380416_P_NODE_8812_length_192_cov_1.314685_g8665_i0	PRJNA380416	8812	192	1.314685	2.5241952	Sphagnum balticum	128184	Plants	Plants	94	8.88e-22	NR	CAM6002349.1	128184	g8665	i0	77.8	0.984375	63	14	98.4	0	3	191	134	196	CAM6002349.1 unnamed protein product, partial [Sphagnum balticum]	diamond	189	94	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
30313725	30313725	PRJNA380416_P_NODE_5852_length_239_cov_1.031579_g5705_i0	PRJNA380416	5852	239	1.031579	2.46547381	Magnoliopsida	3398	Plants	Plants	42.7	0.0356	NR	XP_028951387.2	3750	g5705	i0	36.5	6.82845188284519	63	33	79.1	2	197	9	29	84	XP_028951387.2 zinc finger CCCH domain-containing protein 17-like [Malus domestica]	diamond	1632	43.1	0.990719257540603	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Malus	Malus domestica
30328300	30328300	PRJNA380416_P_NODE_872_length_666_cov_1.507293_g744_i0	PRJNA380416	872	666	1.507293	10.03857138	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	150	1.04e-38	NR	BAK03058.1	112509	g744	i0	38.9	0.891891891891892	198	117	88.7	2	649	59	14	208	BAK03058.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	594	150	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
31402417	31402417	PRJNA380416_P_NODE_12616_length_164_cov_0.886957_g12469_i0	PRJNA380416	12616	164	0.886957	1.45460948	Cryptomeria japonica	3369	Plants	Plants	60.8	2.99e-9	NR	GLJ29509.1	3369	g12469	i0	47.2	0.969512195121951	53	28	97	0	159	1	171	223	GLJ29509.1 hypothetical protein SUGI_0581720 [Cryptomeria japonica]	diamond	159	60.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
31956889	31956889	PRJNA380416_P_NODE_6737_length_221_cov_1.186047_g6590_i0	PRJNA380416	6737	221	1.186047	2.62116387	Asteraceae	4210	Plants	Plants	53.5	4.31e-6	NR	KAI7754724.1	4212	g6590	i0	74.3	8.02262443438914	35	9	47.5	0	107	3	142	176	KAI7754724.1 hypothetical protein M8C21_013849 [Ambrosia artemisiifolia]	diamond	1773	53.9	0.992578849721707	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Ambrosia	Ambrosia artemisiifolia
32792913	32792913	PRJNA380416_P_NODE_2800_length_360_cov_1.453376_g2653_i0	PRJNA380416	2800	360	1.453376	5.2321536	Gossypium hirsutum	3635	Plants	Plants	47.8	0.00215	NR	XP_016700173.1	3635	g2653	i0	70	0.25	30	9	25	0	358	269	92	121	XP_016700173.1 probable leucine-rich repeat receptor-like protein kinase At1g35710 [Gossypium hirsutum]	diamond	90	47.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Gossypium	Gossypium hirsutum

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