metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB6055" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB6055" 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
28991914	28991914	PRJEB6055_S_NODE_5748_length_152_cov_1.914530_g5724_i0	PRJEB6055	5748	152	1.91453	2.9100856	Carpinus fangiana	176857	Plants	Plants	61.6	1.7e-10	NR	KAE8124078.1	176857	g5724	i0	91.9	0.730263157894737	37	3	73	0	16	126	1	37	KAE8124078.1 hypothetical protein FH972_018988 [Carpinus fangiana]	diamond	111	61.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Carpinus	Carpinus fangiana
29363799	29363799	PRJEB6055_S_NODE_649_length_314_cov_2.071685_g625_i0	PRJEB6055	649	314	2.071685	6.5050909	Eukaryota	2759	Plants	Plants	53.1	4.45e-6	NR	XP_055818756.1	45834	g625	i0	66.7	7.80573248407643	81	25	77.4	1	289	47	69	147	XP_055818756.1 60S acidic ribosomal protein P2B-like [Solanum dulcamara]	diamond	2451	53.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum dulcamara
29844076	29844076	PRJEB6055_S_NODE_2911_length_193_cov_2.398734_g2887_i0	PRJEB6055	2911	193	2.398734	4.62955662	Sphenostylis stenocarpa	92480	Plants	Plants	74.7	9.92e-14	NR	CAJ1971540.1	92480	g2887	i0	65.5	4.29015544041451	55	19	85.5	0	193	29	400	454	CAJ1971540.1 unnamed protein product [Sphenostylis stenocarpa]	diamond	828	74.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Sphenostylis	Sphenostylis stenocarpa
29907408	29907408	PRJEB6055_S_NODE_731_length_304_cov_3.758364_g707_i0	PRJEB6055	731	304	3.758364	11.42542656	Rhamnella rubrinervis	2594499	Plants	Plants	49.7	2.64e-4	NR	KAF3449793.1	2594499	g707	i0	41.4	0.690789473684211	70	28	69.1	3	94	303	301	357	KAF3449793.1 hypothetical protein FNV43_RR05871 [Rhamnella rubrinervis]	diamond	210	49.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rhamnaceae	Rhamnella	Rhamnella rubrinervis

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