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

12 rows where analysis = "diamond", bioproject = "PRJNA1069776" 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
27415282	27415282	PRJNA1069776_S_NODE_25423_length_212_cov_1.704142_g25109_i0	PRJNA1069776	25423	212	1.704142	3.6127810400000002	Mikania micrantha	192012	Plants	Plants	42	0.0474	NR	KAD5317950.1	192012	g25109	i0	46.3	0.580188679245283	41	21	58	1	30	152	168	207	KAD5317950.1 hypothetical protein E3N88_17896 [Mikania micrantha]	diamond	123	42	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Mikania	Mikania micrantha
27794038	27794038	PRJNA1069776_S_NODE_17664_length_248_cov_3.190244_g17350_i0	PRJNA1069776	17664	248	3.190244	7.91180512	Trifolium repens	3899	Plants	Plants	43.9	0.011	NR	KAK2350524.1	3899	g17350	i0	36.6	0.858870967741935	71	36	82.3	2	32	235	103	167	KAK2350524.1 hypothetical protein QL285_098124 [Trifolium repens]	diamond	213	43.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Trifolium	Trifolium repens
28046442	28046442	PRJNA1069776_S_NODE_4305_length_389_cov_4.991329_g3991_i0	PRJNA1069776	4305	389	4.991329	19.41626981	Quercus rubra	3512	Plants	Plants	186	1.52e-58	NR	KAK4591631.1	3512	g3991	i0	100	1.18766066838046	77	0	59.4	0	2	232	29	105	KAK4591631.1 hypothetical protein RGQ29_016171 [Quercus rubra]	diamond	462	186	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
29498833	29498833	PRJNA1069776_S_NODE_25190_length_212_cov_11.662722_g24876_i0	PRJNA1069776	25190	212	11.662722	24.72497064	Dipteronia sinensis	43782	Plants	Plants	42	0.0473	NR	KAK3206963.1	43782	g24876	i0	44.2	0.735849056603774	52	25	73.6	2	9	164	255	302	KAK3206963.1 hypothetical protein Dsin_021009 [Dipteronia sinensis]	diamond	156	42	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Dipteronia	Dipteronia sinensis
29783029	29783029	PRJNA1069776_S_NODE_28591_length_201_cov_3.341772_g28277_i0	PRJNA1069776	28591	201	3.341772	6.71696172	Juncus effusus	13579	Plants	Plants	42.7	0.007	NR	KAJ3694946.1	13579	g28277	i0	52.2	0.686567164179104	46	22	68.7	0	45	182	24	69	KAJ3694946.1 hypothetical protein LUZ60_000323 [Juncus effusus]	diamond	138	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Juncaceae	Juncus	Juncus effusus
30067286	30067286	PRJNA1069776_S_NODE_28632_length_201_cov_2.841772_g28318_i0	PRJNA1069776	28632	201	2.841772	5.71196172	Quercus rubra	3512	Plants	Plants	100	7.13e-25	NR	KAK4594628.1	3512	g28318	i0	100	0.701492537313433	47	0	70.1	0	199	59	113	159	KAK4594628.1 hypothetical protein RGQ29_018349 [Quercus rubra]	diamond	141	100	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
30415259	30415259	PRJNA1069776_S_NODE_18713_length_242_cov_2.763819_g18399_i0	PRJNA1069776	18713	242	2.763819	6.68844198	Paspalum notatum var. saurae	547442	Plants	Plants	43.1	0.0271	NR	WVZ62945.1	547442	g18399	i0	35.1	0.954545454545455	77	31	86.8	5	28	237	13	77	WVZ62945.1 hypothetical protein U9M48_012633, partial [Paspalum notatum var. saurae]	diamond	231	43.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Paspalum	Paspalum notatum
30446664	30446664	PRJNA1069776_S_NODE_21113_length_230_cov_1.759358_g20799_i0	PRJNA1069776	21113	230	1.759358	4.0465234	Cucumis melo var. makuwa	1194695	Plants	Plants	42.7	0.0309	NR	KAA0057903.1	1194695	g20799	i0	35.5	1.98260869565217	76	33	83.5	2	202	11	242	313	KAA0057903.1 suppressor protein SRP40 isoform X2 [Cucumis melo var. makuwa]	diamond	456	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Cucumis	Cucumis melo
30635873	30635873	PRJNA1069776_S_NODE_17473_length_249_cov_4.436893_g17159_i0	PRJNA1069776	17473	249	4.436893	11.04786357	Quercus rubra	3512	Plants	Plants	115	1.3899999999999999e-31	NR	KAK4589130.1	3512	g17159	i0	98.3	0.698795180722892	58	1	69.9	0	2	175	15	72	KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra]	diamond	174	115	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
30888845	30888845	PRJNA1069776_S_NODE_15654_length_260_cov_4.566820_g15340_i0	PRJNA1069776	15654	260	4.56682	11.873732	Quercus rubra	3512	Plants	Plants	68.9	1.81e-13	NR	KAK4581221.1	3512	g15340	i0	81.4	0.496153846153846	43	7	49.6	1	37	165	3	44	KAK4581221.1 hypothetical protein RGQ29_024765 [Quercus rubra]	diamond	129	68.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
30888850	30888850	PRJNA1069776_S_NODE_55354_length_150_cov_2.242991_g55040_i0	PRJNA1069776	55354	150	2.242991	3.3644865	Cichorium intybus	13427	Plants	Plants	43.5	0.00549	NR	KAI3739418.1	13427	g55040	i0	45.9	0.74	37	20	74	0	36	146	67	103	KAI3739418.1 hypothetical protein L2E82_29822 [Cichorium intybus]	diamond	111	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Cichorium	Cichorium intybus
31236301	31236301	PRJNA1069776_S_NODE_35515_length_183_cov_1.171429_g35201_i0	PRJNA1069776	35515	183	1.171429	2.14371507	Quercus rubra	3512	Plants	Plants	52.4	1.08e-6	NR	KAK4594619.1	3512	g35201	i0	71.9	0.524590163934426	32	9	52.5	0	181	86	87	118	KAK4594619.1 hypothetical protein RGQ29_018340 [Quercus rubra]	diamond	96	52.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra

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