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

9 rows where analysis = "diamond", bioproject = "PRJNA1253698" 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
26598669	26598669	PRJNA1253698_S_NODE_18061_length_169_cov_0.866667_g17695_i0	PRJNA1253698	18061	169	0.866667	1.46466723	Cephalotus follicularis	3775	Plants	Plants	42.4	0.0145	NR	GAV59861.1	3775	g17695	i0	61.3	0.550295857988166	31	12	55	0	93	1	80	110	GAV59861.1 hypothetical protein CFOL_v3_03392 [Cephalotus follicularis]	diamond	93	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Oxalidales	Cephalotaceae	Cephalotus	Cephalotus follicularis
27042214	27042214	PRJNA1253698_S_NODE_16782_length_173_cov_1.774194_g16416_i0	PRJNA1253698	16782	173	1.774194	3.06935562	Populus alba	43335	Plants	Plants	47.4	3.26e-4	NR	XP_034920814.1	43335	g16416	i0	64.9	2.94797687861272	37	10	64.2	1	2	112	208	241	XP_034920814.1 uncharacterized protein LOC118053609 [Populus alba]	diamond	510	47.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus alba
27231810	27231810	PRJNA1253698_S_NODE_7943_length_243_cov_5.572165_g7577_i0	PRJNA1253698	7943	243	5.572165	13.54036095	Cannabis sativa	3483	Plants	Plants	45.8	0.00302	NR	KAF4368741.1	3483	g7577	i0	39	2.18518518518519	59	31	66.7	1	36	197	485	543	KAF4368741.1 hypothetical protein G4B88_003614 [Cannabis sativa]	diamond	531	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa
27800509	27800509	PRJNA1253698_S_NODE_17464_length_170_cov_1.710744_g17098_i0	PRJNA1253698	17464	170	1.710744	2.9082648	Carpinus fangiana	176857	Plants	Plants	95.5	6.17e-24	NR	KAE8009925.1	176857	g17098	i0	79.2	0.935294117647059	53	11	93.5	0	170	12	48	100	KAE8009925.1 hypothetical protein FH972_006330 [Carpinus fangiana]	diamond	159	95.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Carpinus	Carpinus fangiana
29189755	29189755	PRJNA1253698_S_NODE_16689_length_174_cov_0.824000_g16323_i0	PRJNA1253698	16689	174	0.824	1.43376	Carpinus fangiana	176857	Plants	Plants	58.9	7.36e-10	NR	KAE8037843.1	176857	g16323	i0	72.2	0.620689655172414	36	10	62.1	0	174	67	27	62	KAE8037843.1 hypothetical protein FH972_010398 [Carpinus fangiana]	diamond	108	58.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Carpinus	Carpinus fangiana
29441931	29441931	PRJNA1253698_S_NODE_16890_length_173_cov_1.185484_g16524_i0	PRJNA1253698	16890	173	1.185484	2.05088732	Populus deltoides	3696	Plants	Plants	86.3	3.81e-20	NR	KAH8496377.1	3696	g16524	i0	79.6	0.936416184971098	54	10	93.6	1	165	4	3	55	KAH8496377.1 hypothetical protein H0E87_019217 [Populus deltoides]	diamond	162	86.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus deltoides
30168417	30168417	PRJNA1253698_S_NODE_21832_length_164_cov_0.904348_g21466_i0	PRJNA1253698	21832	164	0.904348	1.48313072	Hordeum vulgare	4513	Plants	Plants	96.3	1.47e-23	NR	KAE8786750.1	4513	g21466	i0	78.8	0.951219512195122	52	11	95.1	0	158	3	98	149	KAE8786750.1 hypothetical protein D1007_39331 [Hordeum vulgare]	diamond	156	96.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
31401220	31401220	PRJNA1253698_S_NODE_24096_length_158_cov_2.357798_g23730_i0	PRJNA1253698	24096	158	2.357798	3.72532084	Carpinus fangiana	176857	Plants	Plants	42.4	0.00269	NR	KAE8076566.1	176857	g23730	i0	58.1	0.588607594936709	31	13	58.9	0	157	65	43	73	KAE8076566.1 hypothetical protein FH972_015206 [Carpinus fangiana]	diamond	93	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Carpinus	Carpinus fangiana
32508533	32508533	PRJNA1253698_S_NODE_18499_length_168_cov_0.873950_g18133_i0	PRJNA1253698	18499	168	0.87395	1.468236	Cucumis sativus	3659	Plants	Plants	65.9	9.29e-11	NR	XP_031744758.1	3659	g18133	i0	76.2	3	42	10	75	0	42	167	437	478	XP_031744758.1 uncharacterized protein LOC101212255 isoform X5 [Cucumis sativus]	diamond	504	65.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Cucumis	Cucumis sativus

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