metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA929940" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA929940" 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
26644854	26644854	PRJNA929940_S_NODE_26481_length_205_cov_2.720238_g26246_i0	PRJNA929940	26481	205	2.720238	5.5764879	Salix udensis	889485	Plants	Plants	43.1	0.00685	NR	KAJ6419131.1	889485	g26246	i0	48.9	0.68780487804878	47	23	67.3	1	56	193	56	102	KAJ6419131.1 hypothetical protein OIU84_029274 [Salix udensis]	diamond	141	43.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Salix	Salix udensis
27024923	27024923	PRJNA929940_S_NODE_14402_length_260_cov_2.156951_g14167_i0	PRJNA929940	14402	260	2.156951	5.6080726	Vitis vinifera	29760	Plants	Plants	44.7	0.00212	NR	WJZ88575.1	29760	g14167	i0	40.9	0.507692307692308	44	25	49.6	1	164	36	36	79	WJZ88575.1 hypothetical protein VitviT2T_007857 [Vitis vinifera]	diamond	132	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
29266867	29266867	PRJNA929940_S_NODE_18309_length_237_cov_2.415000_g18074_i0	PRJNA929940	18309	237	2.415	5.72355	Corchorus olitorius	93759	Plants	Plants	42.4	0.0457	NR	OMO94617.1	93759	g18074	i0	40.8	0.620253164556962	49	29	62	0	227	81	6	54	OMO94617.1 Endonuclease/exonuclease/phosphatase [Corchorus olitorius]	diamond	147	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Corchorus	Corchorus olitorius
30783228	30783228	PRJNA929940_S_NODE_43694_length_169_cov_1.651515_g43459_i0	PRJNA929940	43694	169	1.651515	2.79106035	Ceratodon purpureus	3225	Plants	Plants	93.2	1.71e-20	NR	KAG0612232.1	3225	g43459	i0	71.4	1.89940828402367	56	16	99.4	0	168	1	370	425	KAG0612232.1 hypothetical protein M758_6G011600 [Ceratodon purpureus]	diamond	321	93.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Pseudoditrichales	Ditrichaceae	Ceratodon	Ceratodon purpureus
32427784	32427784	PRJNA929940_S_NODE_13739_length_264_cov_6.572687_g13504_i0	PRJNA929940	13739	264	6.572687	17.35189368	Acorus gramineus	55184	Plants	Plants	43.5	0.00484	NR	KAK1264048.1	55184	g13504	i0	33.3	0.75	66	44	75	0	204	7	4	69	KAK1264048.1 hypothetical protein QJS04_geneDACA008442 [Acorus gramineus]	diamond	198	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Acorales	Acoraceae	Acorus	Acorus gramineus

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