metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA753151" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA753151" 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
26609487	26609487	PRJNA753151_S_NODE_157001_length_232_cov_1.666667_g154711_i0	PRJNA753151	157001	232	1.666667	3.86666744	Liquidambar formosana	63359	Plants	Plants	57.4	1.14e-8	NR	KAK9282958.1	63359	g154711	i0	73	0.478448275862069	37	10	47.8	0	112	2	4	40	KAK9282958.1 hypothetical protein L1049_011183 [Liquidambar formosana]	diamond	111	57.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Saxifragales	Altingiaceae	Liquidambar	Liquidambar formosana
27125558	27125558	PRJNA753151_S_NODE_132182_length_251_cov_3.677885_g129892_i0	PRJNA753151	132182	251	3.677885	9.23149135	Streptophyta	35493	Plants	Plants	116	3.829999999999999e-31	NR	NP_001365234.1	3218	g129892	i0	68.3	5.79681274900398	82	26	98	0	249	4	61	142	NP_001365234.1 40S ribosomal protein S19-1-like [Physcomitrium patens]	diamond	1455	116	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Funariales	Funariaceae	Physcomitrium	Physcomitrium patens
27716674	27716674	PRJNA753151_S_NODE_195404_length_207_cov_1.646341_g193114_i0	PRJNA753151	195404	207	1.646341	3.40792587	Dipteronia sinensis	43782	Plants	Plants	42	0.0427	NR	KAK3219415.1	43782	g193114	i0	48.6	0.536231884057971	37	19	53.6	0	197	87	90	126	KAK3219415.1 hypothetical protein Dsin_013385 [Dipteronia sinensis]	diamond	111	42	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Dipteronia	Dipteronia sinensis
28252988	28252988	PRJNA753151_S_NODE_232546_length_187_cov_2.090278_g230256_i0	PRJNA753151	232546	187	2.090278	3.90881986	Digitaria exilis	1010633	Plants	Plants	57.4	1.01e-7	NR	KAF8780732.1	1010633	g230256	i0	53.1	4.89304812834225	64	28	99.5	1	187	2	198	261	KAF8780732.1 hypothetical protein HU200_001339 [Digitaria exilis]	diamond	915	57.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Digitaria	Digitaria exilis
29578911	29578911	PRJNA753151_S_NODE_197250_length_206_cov_1.460123_g194960_i0	PRJNA753151	197250	206	1.460123	3.00785338	Vigna angularis	3914	Plants	Plants	41.6	0.043	NR	XP_017407884.1	3914	g194960	i0	36.7	0.713592233009709	49	31	71.4	0	160	14	92	140	XP_017407884.1 putative F-box protein At4g22170 [Vigna angularis]	diamond	147	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna angularis
29989746	29989746	PRJNA753151_S_NODE_179151_length_217_cov_1.551724_g176861_i0	PRJNA753151	179151	217	1.551724	3.36724108	Cryptomeria japonica	3369	Plants	Plants	52	2.78e-6	NR	XP_057859631.1	3369	g176861	i0	59.1	0.608294930875576	44	17	59.4	1	135	7	22	65	XP_057859631.1 uncharacterized protein LOC131068463 [Cryptomeria japonica]	diamond	132	52	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
32117640	32117640	PRJNA753151_S_NODE_236418_length_185_cov_2.535211_g234128_i0	PRJNA753151	236418	185	2.535211	4.69014035	Eukaryota	2759	Plants	Plants	89	1.21e-20	NR	KAH7430900.1	49495	g234128	i0	68.3	7.39459459459459	60	19	97.3	0	183	4	66	125	KAH7430900.1 hypothetical protein KP509_08G019800 [Ceratopteris richardii]	diamond	1368	89.4	0.995525727069351	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Ceratopteris	Ceratopteris richardii
32139357	32139357	PRJNA753151_S_NODE_288698_length_164_cov_1.487603_g286408_i0	PRJNA753151	288698	164	1.487603	2.43966892	Quercus rubra	3512	Plants	Plants	98.2	2.23e-25	NR	KAK4589130.1	3512	g286408	i0	96	0.914634146341463	50	2	91.5	0	1	150	23	72	KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra]	diamond	150	98.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
32424088	32424088	PRJNA753151_S_NODE_158299_length_231_cov_1.787234_g156009_i0	PRJNA753151	158299	231	1.787234	4.12851054	Vigna angularis	3914	Plants	Plants	48.1	3.92e-4	NR	XP_052722724.1	3914	g156009	i0	37.1	1.61038961038961	62	38	79.2	1	5	187	528	589	XP_052722724.1 receptor-like protein 12 isoform X6 [Vigna angularis]	diamond	372	48.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna angularis

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