metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA764222" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA764222" 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
3295936	3295936	PRJNA764222_S_NODE_21763_length_201_cov_3.298701_g21605_i0	PRJNA764222	21763	201	3.298701	6.63038901	Fraxinus pennsylvanica	56036	Plants	Plants	86.7	7.45e-18	NR	CAI9762374.1	56036	g21605	i0	98	0.73134328358209	49	1	73.1	0	55	201	1	49	CAI9762374.1 unnamed protein product [Fraxinus pennsylvanica]	diamond	147	86.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Fraxinus	Fraxinus pennsylvanica
26673038	26673038	PRJNA764222_S_NODE_10561_length_259_cov_1.943396_g10403_i0	PRJNA764222	10561	259	1.943396	5.03339564	Fraxinus pennsylvanica	56036	Plants	Plants	100	4.6099999999999997e-23	NR	CAI9781399.1	56036	g10403	i0	98	1.7027027027027	49	1	56.8	0	258	112	295	343	CAI9781399.1 unnamed protein product [Fraxinus pennsylvanica]	diamond	441	100	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Fraxinus	Fraxinus pennsylvanica
30938031	30938031	PRJNA764222_S_NODE_15674_length_230_cov_1.333333_g15516_i0	PRJNA764222	15674	230	1.333333	3.0666659	Papaver armeniacum	357465	Plants	Plants	41.6	0.0329	NR	KAI3940971.1	357465	g15516	i0	56.3	0.417391304347826	32	14	41.7	0	19	114	71	102	KAI3940971.1 hypothetical protein MKW92_022783, partial [Papaver armeniacum]	diamond	96	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Papaveraceae	Papaver	Papaver armeniacum
31570425	31570425	PRJNA764222_S_NODE_5236_length_306_cov_3.957529_g5078_i0	PRJNA764222	5236	306	3.957529	12.11003874	Castanea mollissima	60419	Plants	Plants	139	2e-39	NR	KAF3969338.1	60419	g5078	i0	94.6	0.725490196078431	74	4	72.5	0	306	85	116	189	KAF3969338.1 hypothetical protein CMV_006858 [Castanea mollissima]	diamond	222	139	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Castanea	Castanea mollissima
31601986	31601986	PRJNA764222_S_NODE_396_length_1076_cov_39.574344_g309_i0	PRJNA764222	396	1076	39.574344	425.81994144	Solanum pennellii	28526	Plants	Plants	48.1	0.0434	NR	XP_027769269.1	28526	g309	i0	26.3	0.710966542750929	255	155	67.5	9	794	69	57	291	XP_027769269.1 uncharacterized protein LOC114075175 [Solanum pennellii]	diamond	765	48.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum pennellii
32202932	32202932	PRJNA764222_S_NODE_20098_length_209_cov_1.271605_g19940_i0	PRJNA764222	20098	209	1.271605	2.65765445	Buddleja alternifolia	168488	Plants	Plants	94.4	2.5e-23	NR	KAG8389312.1	168488	g19940	i0	62.7	0.961722488038278	67	20	89	1	196	11	27	93	KAG8389312.1 hypothetical protein BUALT_Bualt02G0216300 [Buddleja alternifolia]	diamond	201	94.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Scrophulariaceae	Buddleja	Buddleja alternifolia
32234844	32234844	PRJNA764222_S_NODE_19558_length_211_cov_2.719512_g19400_i0	PRJNA764222	19558	211	2.719512	5.73817032	Melia azedarach	155640	Plants	Plants	42.7	0.024	NR	KAJ4724835.1	155640	g19400	i0	39.7	0.895734597156398	63	34	85.3	2	2	181	16	77	KAJ4724835.1 putative Serine/threonine-protein kinase rio2 [Melia azedarach]	diamond	189	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Meliaceae	Melia	Melia azedarach
32802851	32802851	PRJNA764222_S_NODE_10220_length_261_cov_3.112150_g10062_i0	PRJNA764222	10220	261	3.11215	8.1227115	Pseudostellaria longipedicellata	2038704	Plants	Plants	42.7	0.0312	NR	YP_009517818.1	2038704	g10062	i0	41.7	0.689655172413793	60	30	69	1	234	55	32	86	YP_009517818.1 photosystem I assembly protein ycf4 [Pseudostellaria longipedicellata]	diamond	180	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Caryophyllaceae	Pseudostellaria	Pseudostellaria longipedicellata

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