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

12 rows where analysis = "diamond", bioproject = "PRJNA407368" 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
414946	414946	PRJNA407368_S_NODE_10541_length_151_cov_2.590164_g10439_i0	PRJNA407368	10541	151	2.590164	3.91114764	Nymphaea colorata	210225	Plants	Plants	85.5	1.14e-18	NR	XP_031472812.1	210225	g10439	i0	81.6	1.94701986754967	49	9	97.4	0	1	147	105	153	XP_031472812.1 14-3-3-like protein GF14 epsilon [Nymphaea colorata]	diamond	294	85.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
4242190	4242190	PRJNA407368_S_NODE_4724_length_259_cov_4.252174_g4622_i0	PRJNA407368	4724	259	4.252174	11.01313066	Triticum aestivum	4565	Plants	Plants	63.5	1.13e-9	NR	XBJ03889.1	4565	g4622	i0	60.4	0.613899613899614	53	21	61.4	0	238	80	114	166	XBJ03889.1 hypothetical protein VPH35_022935 [Triticum aestivum]	diamond	159	63.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
28228889	28228889	PRJNA407368_S_NODE_8746_length_171_cov_7.169014_g8644_i0	PRJNA407368	8746	171	7.169014	12.259013940000001	Eukaryota	2759	Plants	Plants	41.6	0.0377	NR	KAG5568978.1	4109	g8644	i0	60	1.12280701754386	30	12	52.6	0	4	93	23	52	KAG5568978.1 hypothetical protein H5410_064022 [Solanum commersonii]	diamond	192	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum commersonii
28623060	28623060	PRJNA407368_S_NODE_2667_length_369_cov_3.805882_g2565_i0	PRJNA407368	2667	369	3.805882	14.04370458	Cryptomeria japonica	3369	Plants	Plants	45.8	0.012	NR	XP_057830609.2	3369	g2565	i0	54.8	1.00813008130081	31	14	25.2	0	270	178	244	274	XP_057830609.2 uncharacterized protein LOC131041510 [Cryptomeria japonica]	diamond	372	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
29822497	29822497	PRJNA407368_S_NODE_10051_length_156_cov_1.653543_g9949_i0	PRJNA407368	10051	156	1.653543	2.57952708	Solanum pinnatisectum	50273	Plants	Plants	41.6	0.0289	NR	KAK4709630.1	50273	g9949	i0	54	1.76923076923077	50	20	96.2	2	2	151	76	122	KAK4709630.1 hypothetical protein R3W88_004143 [Solanum pinnatisectum]	diamond	276	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum pinnatisectum
30391884	30391884	PRJNA407368_S_NODE_8213_length_178_cov_2.879195_g8111_i0	PRJNA407368	8213	178	2.879195	5.1249671	Cichorium endivia	114280	Plants	Plants	42	0.0299	NR	KAI3485563.1	114280	g8111	i0	52.8	0.606741573033708	36	17	60.7	0	168	61	278	313	KAI3485563.1 hypothetical protein L1887_51096 [Cichorium endivia]	diamond	108	42	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Cichorium	Cichorium endivia
31229386	31229386	PRJNA407368_S_NODE_10235_length_154_cov_2.016000_g10133_i0	PRJNA407368	10235	154	2.016	3.10464	Magnoliopsida	3398	Plants	Plants	85.1	5.96e-18	NR	WOL18607.1	4628	g10133	i0	74.5	50.6688311688312	51	13	99.4	0	1	153	148	198	WOL18607.1 40S ribosomal protein S3a [Canna indica]	diamond	7803	85.5	0.9953216374269	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Cannaceae	Canna	Canna indica
31244474	31244474	PRJNA407368_S_NODE_10555_length_151_cov_2.278689_g10453_i0	PRJNA407368	10555	151	2.278689	3.44082039	Sphagnum jensenii	128206	Plants	Plants	81.3	2.66e-17	NR	CAK9867287.1	128206	g10453	i0	66	1.05298013245033	53	15	99.3	1	2	151	20	72	CAK9867287.1 unnamed protein product [Sphagnum jensenii]	diamond	159	81.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum jensenii
31356245	31356245	PRJNA407368_S_NODE_6076_length_218_cov_2.735450_g5974_i0	PRJNA407368	6076	218	2.73545	5.963281	Magnoliopsida	3398	Plants	Plants	50.8	3.55e-5	NR	RXI09566.1	3750	g5974	i0	48.6	1.98165137614679	72	33	99.1	1	2	217	92	159	RXI09566.1 hypothetical protein DVH24_033634 [Malus domestica]	diamond	432	51.2	0.9921875	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Malus	Malus domestica
31655530	31655530	PRJNA407368_S_NODE_5997_length_220_cov_1.979058_g5895_i0	PRJNA407368	5997	220	1.979058	4.3539276	Acacia pycnantha	880440	Plants	Plants	42.4	0.0395	NR	KAI9092533.1	880440	g5895	i0	40.6	0.940909090909091	69	33	84.5	2	198	13	678	745	KAI9092533.1 hypothetical protein K1719_027661 [Acacia pycnantha]	diamond	207	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Acacia	Acacia pycnantha
32400228	32400228	PRJNA407368_S_NODE_9239_length_165_cov_2.463235_g9137_i0	PRJNA407368	9239	165	2.463235	4.06433775	Pteridaceae	13819	Plants	Plants	78.2	3.51e-16	NR	KAI5072179.1	13818	g9137	i0	75	6.65454545454545	52	13	94.5	0	157	2	113	164	KAI5072179.1 hypothetical protein GOP47_0012285 [Adiantum capillus-veneris]	diamond	1098	78.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
32621238	32621238	PRJNA407368_S_NODE_8780_length_171_cov_2.485915_g8678_i0	PRJNA407368	8780	171	2.485915	4.25091465	root	1	Root_unresolved	Root_unresolved	92	4.88e-20	NR	GFB69657.1	118510	g8678	i0	84.6	3.64912280701754	52	8	91.2	0	169	14	224	275	GFB69657.1 hypothetical protein [Tanacetum cinerariifolium]	diamond	624	92	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium

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