metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA938397" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA938397" 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
26676463	26676463	PRJNA938397_S_NODE_6261_length_395_cov_22.787709_g6025_i0	PRJNA938397	6261	395	22.787709	90.01145055	Vicia faba	3906	Plants	Plants	54.7	1.86e-6	NR	KAL5061354.1	3906	g6025	i0	58.8	1.54936708860759	102	37	75.2	2	32	328	31	130	KAL5061354.1 hypothetical protein RYX36_032958, partial [Vicia faba]	diamond	612	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vicia	Vicia faba
26739658	26739658	PRJNA938397_S_NODE_48041_length_158_cov_3.206612_g47800_i0	PRJNA938397	48041	158	3.206612	5.06644696	Perilla frutescens var. hirtella	608512	Plants	Plants	65.5	3.8e-11	NR	KAH6829129.1	608512	g47800	i0	63.8	2.6012658227848098	47	17	89.2	0	156	16	166	212	KAH6829129.1 deacylase family protein [Perilla frutescens var. hirtella]	diamond	411	65.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Lamiaceae	Perilla	Perilla frutescens
27474426	27474426	PRJNA938397_S_NODE_12523_length_306_cov_18.717472_g12282_i0	PRJNA938397	12523	306	18.717472	57.27546432	Eukaryota	2759	Plants	Plants	102	1.5199999999999995e-23	NR	ABK26437.1	3332	g12282	i0	60.8	14.1862745098039	74	29	72.5	0	8	229	264	337	ABK26437.1 unknown [Picea sitchensis]	diamond	4341	103	0.990291262135922	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea sitchensis
27600920	27600920	PRJNA938397_S_NODE_48544_length_157_cov_4.091667_g48303_i0	PRJNA938397	48544	157	4.091667	6.42391719	Viridiplantae	33090	Plants	Plants	45.1	0.0017	NR	KAG5019451.1	3848	g48303	i0	50	2.36942675159236	30	15	57.3	0	9	98	312	341	KAG5019451.1 hypothetical protein JHK87_015306 [Glycine soja]	diamond	372	45.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Glycine	Glycine soja
28295256	28295256	PRJNA938397_S_NODE_27906_length_209_cov_2.784884_g27665_i0	PRJNA938397	27906	209	2.784884	5.82040756	Eukaryota	2759	Plants	Plants	53.5	3.64e-6	NR	KAG9448538.1	158543	g27665	i0	60	3.80382775119617	40	16	57.4	0	208	89	391	430	KAG9448538.1 hypothetical protein H6P81_008503 [Aristolochia fimbriata]	diamond	795	53.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Piperales	Aristolochiaceae	Aristolochia	Aristolochia fimbriata
28895138	28895138	PRJNA938397_S_NODE_37248_length_180_cov_7.062937_g37007_i0	PRJNA938397	37248	180	7.062937	12.7132866	Magnoliopsida	3398	Plants	Plants	59.7	1.62e-8	NR	KAK1271782.1	55184	g37007	i0	44.9	6.58333333333333	49	27	81.7	0	5	151	414	462	KAK1271782.1 E3 ubiquitin-protein ligase RGLG2 [Acorus gramineus]	diamond	1185	60.1	0.993344425956739	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Acorales	Acoraceae	Acorus	Acorus gramineus
29803789	29803789	PRJNA938397_S_NODE_30411_length_200_cov_4.380368_g30170_i0	PRJNA938397	30411	200	4.380368	8.760736	Iris pallida	29817	Plants	Plants	55.1	9.28e-7	NR	KAJ6830814.1	29817	g30170	i0	43.6	8.385	55	29	79.5	1	5	163	416	470	KAJ6830814.1 ultraviolet-B receptor UVR8-like [Iris pallida]	diamond	1677	55.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asparagales	Iridaceae	Iris	Iris pallida
30151119	30151119	PRJNA938397_S_NODE_37312_length_180_cov_4.867133_g37071_i0	PRJNA938397	37312	180	4.867133	8.7608394	Prosopis alba	207710	Plants	Plants	51.6	1.17e-5	NR	XP_028799659.1	207710	g37071	i0	51.2	1.43333333333333	43	21	71.7	0	2	130	532	574	XP_028799659.1 uncharacterized protein LOC114754967 isoform X2 [Prosopis alba]	diamond	258	51.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Neltuma	Neltuma alba
30467664	30467664	PRJNA938397_S_NODE_33393_length_191_cov_1.519481_g33152_i0	PRJNA938397	33393	191	1.519481	2.90220871	Genlisea aurea	192259	Plants	Plants	64.7	6.42e-11	NR	EPS59092.1	192259	g33152	i0	56.7	1.8848167539267	60	25	92.7	1	189	13	9	68	EPS59092.1 hypothetical protein M569_15720, partial [Genlisea aurea]	diamond	360	64.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Lentibulariaceae	Genlisea	Genlisea aurea
32774698	32774698	PRJNA938397_S_NODE_47660_length_159_cov_1.221311_g47419_i0	PRJNA938397	47660	159	1.221311	1.94188449	Lithospermum erythrorhizon	34254	Plants	Plants	61.2	2.14e-10	NR	GAA0142781.1	34254	g47419	i0	56	2.83018867924528	50	22	94.3	0	2	151	32	81	GAA0142781.1 ribosomal protein [Lithospermum erythrorhizon]	diamond	450	61.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Boraginales	Boraginaceae	Lithospermum	Lithospermum erythrorhizon

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