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

9 rows where analysis = "diamond", bioproject = "PRJNA879221" 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
26770448	26770448	PRJNA879221_P_NODE_25181_length_352_cov_0.874552_g25041_i0	PRJNA879221	25181	352	0.874552	3.07842304	Phaeoceros laevis	37308	Plants	Plants	57.8	6.79e-7	NR	YP_003412110.1	37308	g25041	i0	69.2	0.443181818181818	52	15	43.5	1	158	310	191	242	YP_003412110.1 cytochrome c oxidase subunit 1 [Phaeoceros laevis]	diamond	156	57.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Anthocerotopsida	Notothyladales	Notothyladaceae	Phaeoceros	Phaeoceros laevis
27276662	27276662	PRJNA879221_P_NODE_18203_length_417_cov_0.909884_g18064_i0	PRJNA879221	18203	417	0.909884	3.79421628	Sphenostylis stenocarpa	92480	Plants	Plants	95.5	2.7900000000000003e-22	NR	CAJ1957601.1	92480	g18064	i0	63.3	0.568345323741007	79	29	56.8	0	268	32	23	101	CAJ1957601.1 unnamed protein product [Sphenostylis stenocarpa]	diamond	237	95.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Sphenostylis	Sphenostylis stenocarpa
27371669	27371669	PRJNA879221_P_NODE_51343_length_248_cov_0.880000_g51203_i0	PRJNA879221	51343	248	0.88	2.1824	Aegilops tauschii subsp. strangulata	200361	Plants	Plants	101	9.08e-23	NR	XP_040256139.1	200361	g51203	i0	72	0.991935483870968	82	23	99.2	0	2	247	247	328	XP_040256139.1 microtubule cross-linking factor 1 isoform X2 [Aegilops tauschii subsp. strangulata]	diamond	246	101	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Aegilops	Aegilops tauschii
27813660	27813660	PRJNA879221_P_NODE_18704_length_410_cov_3.198813_g18565_i0	PRJNA879221	18704	410	3.198813	13.1151333	Adiantum capillus-veneris	13818	Plants	Plants	186	1.35e-53	NR	KAI5079957.1	13818	g18565	i0	73	1.84390243902439	126	34	92.2	0	380	3	196	321	KAI5079957.1 hypothetical protein GOP47_0005436 [Adiantum capillus-veneris]	diamond	756	186	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
30600313	30600313	PRJNA879221_P_NODE_58673_length_244_cov_0.900585_g58533_i0	PRJNA879221	58673	244	0.900585	2.1974274	Eukaryota	2759	Plants	Plants	84.3	8.77e-17	NR	WVZ10401.1	3915	g58533	i0	63.6	6.51639344262295	66	23	79.9	1	16	210	918	983	WVZ10401.1 hypothetical protein V8G54_014931 [Vigna mungo]	diamond	1590	84.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna mungo
31192348	31192348	PRJNA879221_P_NODE_52875_length_247_cov_0.885057_g52735_i0	PRJNA879221	52875	247	0.885057	2.18609079	Triticum aestivum	4565	Plants	Plants	90.9	4.53e-19	NR	XBH56170.1	4565	g52735	i0	53.5	0.862348178137652	71	33	86.2	0	219	7	622	692	XBH56170.1 hypothetical protein VPH35_078074 [Triticum aestivum]	diamond	213	90.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
31319177	31319177	PRJNA879221_P_NODE_37975_length_283_cov_1.900000_g37835_i0	PRJNA879221	37975	283	1.9	5.377	Fraxinus pennsylvanica	56036	Plants	Plants	99.8	3.949999999999999e-24	NR	CAI9779362.1	56036	g37835	i0	92.2	0.540636042402827	51	4	54.1	0	253	101	118	168	CAI9779362.1 unnamed protein product [Fraxinus pennsylvanica]	diamond	153	99.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Fraxinus	Fraxinus pennsylvanica
31888470	31888470	PRJNA879221_P_NODE_60637_length_243_cov_0.905882_g60497_i0	PRJNA879221	60637	243	0.905882	2.20129326	Salvia miltiorrhiza	226208	Plants	Plants	42.7	0.0307	NR	XP_057784226.1	226208	g60497	i0	37.8	0.45679012345679	37	23	45.7	0	5	115	145	181	XP_057784226.1 uncharacterized protein LOC131001677 [Salvia miltiorrhiza]	diamond	111	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Lamiaceae	Salvia	Salvia miltiorrhiza
32749981	32749981	PRJNA879221_P_NODE_9500_length_596_cov_4.898662_g9362_i0	PRJNA879221	9500	596	4.898662	29.19602552	root	1	Root_unresolved	Root_unresolved	47.4	0.00144	NR	CAA63384.1	29589	g9362	i0	68.3	0.850671140939597	41	13	20.6	0	155	277	31	71	CAA63384.1 cytochrome oxidase, partial [Claytosmunda claytoniana]	diamond	507	47.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Osmundales	Osmundaceae	Claytosmunda	Claytosmunda claytoniana

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