metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_phylum = "Streptophyta"

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
15008488	15008488	PRJNA999747_S_NODE_3992_length_158_cov_4.409449_g3960_i0	PRJNA999747	3992	158	4.409449	6.96692942	Magnoliopsida	3398	Plants	Plants	83.6	3.49e-17	NR	XP_022157387.1	3673	g3960	i0	69.2	24.6075949367089	52	16	98.7	0	3	158	240	291	XP_022157387.1 exopolygalacturonase-like [Momordica charantia]	diamond	3888	84	0.995238095238095	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Momordica	Momordica charantia
26900057	26900057	PRJNA999747_S_NODE_2221_length_205_cov_2.563218_g2189_i0	PRJNA999747	2221	205	2.563218	5.2545969	Ficus carica	3494	Plants	Plants	54.7	1.74e-7	NR	GMN44308.1	3494	g2189	i0	47.6	0.921951219512195	63	31	89.3	1	8	190	35	97	GMN44308.1 hypothetical protein TIFTF001_013514 [Ficus carica]	diamond	189	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Ficus	Ficus carica
27215965	27215965	PRJNA999747_S_NODE_1162_length_277_cov_3.207317_g1130_i0	PRJNA999747	1162	277	3.207317	8.88426809	Herrania umbratica	108875	Plants	Plants	90.1	7.08e-19	NR	XP_021274589.1	108875	g1130	i0	74.1	1.75451263537906	54	14	58.5	0	6	167	345	398	XP_021274589.1 polygalacturonase-like [Herrania umbratica]	diamond	486	90.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Herrania	Herrania umbratica
27626981	27626981	PRJNA999747_S_NODE_2944_length_181_cov_5.733333_g2912_i0	PRJNA999747	2944	181	5.733333	10.37733273	Prunus avium	42229	Plants	Plants	68.9	3.85e-13	NR	XP_021807022.1	42229	g2912	i0	62.7	2.93370165745856	59	22	97.8	0	179	3	50	108	XP_021807022.1 late embryogenesis abundant protein 1 [Prunus avium]	diamond	531	68.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Prunus	Prunus avium
28106140	28106140	PRJNA999747_S_NODE_2505_length_195_cov_2.902439_g2473_i0	PRJNA999747	2505	195	2.902439	5.65975605	Magnoliopsida	3398	Plants	Plants	66.2	2.4e-11	NR	XP_007035688.2	3641	g2473	i0	82.9	2.16923076923077	35	6	53.8	0	105	1	38	72	XP_007035688.2 PREDICTED: major allergen Pru ar 1 [Theobroma cacao]	diamond	423	66.6	0.993993993993994	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Theobroma	Theobroma cacao
28200764	28200764	PRJNA999747_S_NODE_2426_length_198_cov_2.155689_g2394_i0	PRJNA999747	2426	198	2.155689	4.26826422	Fagales	3502	Plants	Plants	117	7.47e-32	NR	XP_062149895.1	3517	g2394	i0	78.5	1.96969696969697	65	14	98.5	0	1	195	61	125	XP_062149895.1 uncharacterized protein LOC133858441 [Alnus glutinosa]	diamond	390	118	0.991525423728814	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Alnus	Alnus glutinosa
28422192	28422192	PRJNA999747_S_NODE_4086_length_157_cov_2.087302_g4054_i0	PRJNA999747	4086	157	2.087302	3.27706414	Eukaryota	2759	Plants	Plants	73.2	2.13e-13	NR	WCJ29881.1	38846	g4054	i0	75.7	100.222929936306	37	9	70.7	0	151	41	349	385	WCJ29881.1 WRKY DNA-binding protein 32 [Euphorbia peplus]	diamond	15735	73.9	0.990527740189445	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Euphorbia	Euphorbia peplus
28510901	28510901	PRJNA999747_S_NODE_3327_length_172_cov_3.255319_g3295_i0	PRJNA999747	3327	172	3.255319	5.59914868	Forsythia ovata	205694	Plants	Plants	78.2	4.58e-15	NR	KAL2554865.1	205694	g3295	i0	74.5	24.9593023255814	55	14	95.9	0	166	2	367	421	KAL2554865.1 Heat shock 70 kDa protein 5 [Forsythia ovata]	diamond	4293	78.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Forsythia	Forsythia ovata
28763376	28763376	PRJNA999747_S_NODE_3647_length_165_cov_2.052239_g3615_i0	PRJNA999747	3647	165	2.052239	3.38619435	Quercus rubra	3512	Plants	Plants	65.5	1.21e-10	NR	KAK4573229.1	3512	g3615	i0	70	0.909090909090909	50	15	90.9	0	14	163	178	227	KAK4573229.1 hypothetical protein RGQ29_031264 [Quercus rubra]	diamond	150	65.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
29085195	29085195	PRJNA999747_S_NODE_368_length_426_cov_2.822785_g336_i0	PRJNA999747	368	426	2.822785	12.0250641	root	1	Root_unresolved	Root_unresolved	53.9	1.61e-5	NR	GER39335.1	4170	g336	i0	38.9	2.92253521126761	90	53	63.4	2	384	115	113	200	GER39335.1 26.5 kDa heat shock protein [Striga asiatica]	diamond	1245	53.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Orobanchaceae	Striga	Striga asiatica
29331789	29331789	PRJNA999747_S_NODE_2769_length_187_cov_1.512821_g2737_i0	PRJNA999747	2769	187	1.512821	2.82897527	Amaranthus tricolor	29722	Plants	Plants	77	3.04e-16	NR	XP_057549678.1	29722	g2737	i0	62.7	6.62566844919786	51	19	81.8	0	184	32	54	104	XP_057549678.1 40S ribosomal protein S26-like [Amaranthus tricolor]	diamond	1239	77	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Amaranthaceae	Amaranthus	Amaranthus tricolor
29874490	29874490	PRJNA999747_S_NODE_251_length_481_cov_3.293333_g224_i0	PRJNA999747	251	481	3.293333	15.84093173	Magnoliopsida	3398	Plants	Plants	87	1.72e-16	NR	XP_002448017.2	4558	g224	i0	44.8	3.64241164241164	87	46	53	1	8	262	478	564	XP_002448017.2 probable WRKY transcription factor 2 [Sorghum bicolor]	diamond	1752	87	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Sorghum	Sorghum bicolor
32839195	32839195	PRJNA999747_S_NODE_2040_length_213_cov_3.082418_g2008_i0	PRJNA999747	2040	213	3.082418	6.56555034	Carya illinoinensis	32201	Plants	Plants	70.5	1.32e-12	NR	KAG6684833.1	32201	g2008	i0	60	0.985915492957746	70	20	90.1	4	209	18	152	219	KAG6684833.1 hypothetical protein I3842_12G082900 [Carya illinoinensis]	diamond	210	70.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Juglandaceae	Carya	Carya illinoinensis

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