metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1146366" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1146366" 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
27027811	27027811	PRJNA1146366_S_NODE_1642_length_278_cov_1.507317_g1639_i0	PRJNA1146366	1642	278	1.507317	4.19034126	Magnoliopsida	3398	Plants	Plants	153	6.11e-41	NR	OWM81817.1	22663	g1639	i0	77.2	31.7697841726619	92	21	99.3	0	1	276	144	235	OWM81817.1 hypothetical protein CDL15_Pgr007855 [Punica granatum]	diamond	8832	154	0.993506493506494	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Lythraceae	Punica	Punica granatum
27702729	27702729	PRJNA1146366_S_NODE_2184_length_252_cov_1.569832_g2181_i0	PRJNA1146366	2184	252	1.569832	3.95597664	Taxus chinensis	29808	Plants	Plants	62	7.1e-9	NR	KAH9316782.1	29808	g2181	i0	49.2	1.4047619047619	59	30	70.2	0	252	76	365	423	KAH9316782.1 hypothetical protein KI387_044020 [Taxus chinensis]	diamond	354	62	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
27923409	27923409	PRJNA1146366_S_NODE_465_length_393_cov_2.759375_g462_i0	PRJNA1146366	465	393	2.759375	10.84434375	Picea sitchensis	3332	Plants	Plants	70.5	2.96e-12	NR	ABK25709.1	3332	g462	i0	65.5	0.419847328244275	55	17	42	1	392	228	105	157	ABK25709.1 unknown [Picea sitchensis]	diamond	165	70.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea sitchensis
30892239	30892239	PRJNA1146366_S_NODE_1054_length_319_cov_2.906504_g1051_i0	PRJNA1146366	1054	319	2.906504	9.27174776	Quercus rubra	3512	Plants	Plants	90.5	4.7400000000000006e-21	NR	KAK4591631.1	3512	g1051	i0	81.8	0.827586206896552	44	8	41.4	0	3	134	62	105	KAK4591631.1 hypothetical protein RGQ29_016171 [Quercus rubra]	diamond	264	90.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
30892240	30892240	PRJNA1146366_S_NODE_2434_length_243_cov_2.288235_g2431_i0	PRJNA1146366	2434	243	2.288235	5.56041105	Picea sitchensis	3332	Plants	Plants	46.2	0.00212	NR	ADE77274.1	3332	g2431	i0	61.1	1.41975308641975	36	3	30.9	1	75	1	26	61	ADE77274.1 unknown [Picea sitchensis]	diamond	345	46.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea sitchensis
32883045	32883045	PRJNA1146366_S_NODE_1440_length_290_cov_3.405530_g1437_i0	PRJNA1146366	1440	290	3.40553	9.876037	Lithocarpus litseifolius	425828	Plants	Plants	65.9	3.58e-11	NR	KAL0004350.1	425828	g1437	i0	96.3	0.279310344827586	27	1	27.9	0	290	210	112	138	KAL0004350.1 hypothetical protein SO802_011911 [Lithocarpus litseifolius]	diamond	81	65.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Lithocarpus	Lithocarpus litseifolius

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