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

12 rows where analysis = "diamond", bioproject = "PRJNA1050291" 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
2726642	2726642	PRJNA1050291_P_NODE_4483_length_775_cov_3.556980_g3598_i0	PRJNA1050291	4483	775	3.55698	27.566595	Chara braunii	69332	Plants	Plants	248	6.71e-78	NR	GBG64837.1	69332	g3598	i0	60.9	15.7625806451613	215	81	82.5	2	696	58	114	327	GBG64837.1 hypothetical protein CBR_g48305 [Chara braunii]	diamond	12216	248	1	Eukaryota		Viridiplantae	Streptophyta	Charophyceae	Charales	Characeae	Chara	Chara braunii
9103578	9103578	PRJNA1050291_P_NODE_18248_length_252_cov_2.692737_g17357_i0	PRJNA1050291	18248	252	2.692737	6.78569724	Quercus rubra	3512	Plants	Plants	140	7.739999999999998e-42	NR	KAK4605734.1	3512	g17357	i0	97.1	0.80952380952381	68	2	81	0	227	24	1	68	KAK4605734.1 hypothetical protein RGQ29_000149 [Quercus rubra]	diamond	204	140	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
20577251	20577251	PRJNA1050291_P_NODE_6097_length_586_cov_5.467836_g5206_i0	PRJNA1050291	6097	586	5.467836	32.04151896	Cryptomeria japonica	3369	Plants	Plants	105	1.1099999999999999e-23	NR	XP_057855894.1	3369	g5206	i0	43.4	1.98122866894198	122	60	60.4	2	12	365	150	266	XP_057855894.1 phosphoenolpyruvate carboxylase kinase 1 [Cryptomeria japonica]	diamond	1161	105	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
22687906	22687906	PRJNA1050291_P_NODE_22138_length_228_cov_2.348387_g21247_i0	PRJNA1050291	22138	228	2.348387	5.35432236	Selaginella moellendorffii	88036	Plants	Plants	81.3	1.3e-17	NR	XP_002975118.1	88036	g21247	i0	56.1	4.06578947368421	66	29	86.8	0	200	3	24	89	XP_002975118.1 glutaredoxin-C8 [Selaginella moellendorffii]	diamond	927	81.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Lycopodiopsida	Selaginellales	Selaginellaceae	Selaginella	Selaginella moellendorffii
26750004	26750004	PRJNA1050291_P_NODE_13621_length_305_cov_1.224138_g12730_i0	PRJNA1050291	13621	305	1.224138	3.7336209	Ipomoea nil	35883	Plants	Plants	54.7	4.67e-6	NR	XP_019152546.1	35883	g12730	i0	37.5	6.59016393442623	112	51	95.4	6	300	10	133	240	XP_019152546.1 PREDICTED: aspartic proteinase-like protein 2 isoform X4 [Ipomoea nil]	diamond	2010	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Convolvulaceae	Ipomoea	Ipomoea nil
29151507	29151507	PRJNA1050291_P_NODE_18869_length_250_cov_0.881356_g17978_i0	PRJNA1050291	18869	250	0.881356	2.20339	Arctium lappa	4217	Plants	Plants	137	1.6499999999999998e-35	NR	KAI3692796.1	4217	g17978	i0	77.1	2.988	83	19	99.6	0	249	1	409	491	KAI3692796.1 hypothetical protein L6452_32619 [Arctium lappa]	diamond	747	137	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Arctium	Arctium lappa
29308934	29308934	PRJNA1050291_P_NODE_5269_length_665_cov_7.859797_g4380_i0	PRJNA1050291	5269	665	7.859797	52.26765005	Sinapis alba	3728	Plants	Plants	119	1.7499999999999998e-30	NR	KAF8052311.1	3728	g4380	i0	53.4	0.532330827067669	118	53	52.8	2	663	313	17	133	KAF8052311.1 hypothetical protein N665_1573s0012 [Sinapis alba]	diamond	354	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Sinapis	Sinapis alba
32185089	32185089	PRJNA1050291_P_NODE_17298_length_260_cov_3.406417_g16407_i0	PRJNA1050291	17298	260	3.406417	8.8566842	Liquidambar formosana	63359	Plants	Plants	105	1.0799999999999999e-24	NR	KAK9290685.1	63359	g16407	i0	82.8	0.669230769230769	58	10	66.9	0	8	181	305	362	KAK9290685.1 hypothetical protein L1049_008859 [Liquidambar formosana]	diamond	174	105	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Saxifragales	Altingiaceae	Liquidambar	Liquidambar formosana
32398477	32398477	PRJNA1050291_P_NODE_3739_length_933_cov_5.970930_g2869_i0	PRJNA1050291	3739	933	5.97093	55.7087769	Eukaryota	2759	Plants	Plants	335	1.8799999999999994e-110	NR	KAB8088023.1	4530	g2869	i0	55.9	35.9935691318328	311	135	99.7	2	3	932	47	356	KAB8088023.1 hypothetical protein EE612_012493, partial [Oryza sativa]	diamond	33582	338	0.99112426035503	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
32406550	32406550	PRJNA1050291_P_NODE_20559_length_244_cov_0.912281_g19668_i0	PRJNA1050291	20559	244	0.912281	2.22596564	Solanum tuberosum	4113	Plants	Plants	115	1.34e-27	NR	KAH0757858.1	4113	g19668	i0	76.5	2.50819672131148	68	16	83.6	0	205	2	401	468	KAH0757858.1 hypothetical protein KY290_021351 [Solanum tuberosum]	diamond	612	115	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum tuberosum
32658857	32658857	PRJNA1050291_P_NODE_11480_length_346_cov_4.073260_g10589_i0	PRJNA1050291	11480	346	4.07326	14.0934796	Euphorbia peplus	38846	Plants	Plants	87	1.79e-17	NR	WCJ36939.1	38846	g10589	i0	86.4	0.38150289017341	44	6	38.2	0	51	182	321	364	WCJ36939.1 Leucine-rich repeat (LRR) family protein [Euphorbia peplus]	diamond	132	87	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Euphorbia	Euphorbia peplus
32690481	32690481	PRJNA1050291_P_NODE_21460_length_238_cov_2.030303_g20569_i0	PRJNA1050291	21460	238	2.030303	4.83212114	Cinnamomum micranthum f. kanehirae	337451	Plants	Plants	91.3	5.62e-20	NR	RWR90609.1	337451	g20569	i0	95.1	0.516806722689076	41	2	51.7	0	237	115	256	296	RWR90609.1 class I chitinase [Cinnamomum micranthum f. kanehirae]	diamond	123	91.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Laurales	Lauraceae	Cinnamomum	Cinnamomum micranthum

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