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

4 rows where analysis = "diamond", bioproject = "PRJNA1120586" 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
276427	276427	PRJNA1120586_P_NODE_53021_length_226_cov_0.917197_g52830_i0	PRJNA1120586	53021	226	0.917197	2.07286522	Vicia villosa	3911	Plants	Plants	127	3.6499999999999997e-32	NR	XP_058729307.1	3911	g52830	i0	77.3	15.4911504424779	75	17	99.6	0	1	225	708	782	XP_058729307.1 uncharacterized protein LOC131601492 [Vicia villosa]	diamond	3501	127	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vicia	Vicia villosa
27291409	27291409	PRJNA1120586_P_NODE_49803_length_228_cov_0.905660_g49612_i0	PRJNA1120586	49803	228	0.90566	2.0649048	Vicia villosa	3911	Plants	Plants	100	1.13e-22	NR	XP_058747276.1	3911	g49612	i0	66.2	1.94736842105263	74	25	97.4	0	2	223	18	91	XP_058747276.1 uncharacterized protein LOC131620285 [Vicia villosa]	diamond	444	100	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vicia	Vicia villosa
27702222	27702222	PRJNA1120586_P_NODE_49784_length_228_cov_0.905660_g49593_i0	PRJNA1120586	49784	228	0.90566	2.0649048	Sphagnum balticum	128184	Plants	Plants	90.1	6.47e-19	NR	CAM6003542.1	128184	g49593	i0	58.7	0.986842105263158	75	31	98.7	0	227	3	736	810	CAM6003542.1 unnamed protein product, partial [Sphagnum balticum]	diamond	225	90.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
31196398	31196398	PRJNA1120586_P_NODE_50795_length_227_cov_0.911392_g50604_i0	PRJNA1120586	50795	227	0.911392	2.06885984	root	1	Root_unresolved	Root_unresolved	43.5	0.0128	NR	KAL3687320.1	122646	g50604	i0	42.6	1.62555066079295	54	29	68.7	1	227	72	90	143	KAL3687320.1 hypothetical protein R1sor_013629 [Riccia sorocarpa]	diamond	369	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Marchantiopsida	Marchantiales	Ricciaceae	Riccia	Riccia sorocarpa

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