metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJDB4941" and tax

15 rows where analysis = "diamond", bioproject = "PRJDB4941" 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
5112818	5112818	PRJDB4941_P_NODE_34585_length_169_cov_0.866667_g33817_i0	PRJDB4941	34585	169	0.866667	1.46466723	Eukaryota	2759	Plants	Plants	80.5	6.55e-16	NR	CAL5399498.1	4442	g33817	i0	85.7	37.189349112426	42	5	72.8	1	45	167	488	529	CAL5399498.1 unnamed protein product [Camellia sinensis]	diamond	6285	80.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
19135870	19135870	PRJDB4941_P_NODE_26716_length_194_cov_1.434483_g25948_i0	PRJDB4941	26716	194	1.434483	2.78289702	Eukaryota	2759	Plants	Plants	102	2.35e-26	NR	GFD53476.1	118510	g25948	i0	85.9	1.97938144329897	64	9	99	0	192	1	9	72	GFD53476.1 hypothetical protein [Tanacetum cinerariifolium]	diamond	384	103	0.990291262135922	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
27506687	27506687	PRJDB4941_P_NODE_38823_length_164_cov_0.904348_g38055_i0	PRJDB4941	38823	164	0.904348	1.48313072	Triticum aestivum	4565	Plants	Plants	98.2	3.74e-22	NR	KAF7040114.1	4565	g38055	i0	100	0.841463414634146	46	0	84.1	0	27	164	1	46	KAF7040114.1 hypothetical protein CFC21_050039 [Triticum aestivum]	diamond	138	98.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
27569582	27569582	PRJDB4941_P_NODE_24544_length_203_cov_2.207792_g23776_i0	PRJDB4941	24544	203	2.207792	4.48181776	Cuscuta epithymum	186058	Plants	Plants	45.8	8.96e-4	NR	CAH9129646.1	186058	g23776	i0	42.4	0.87192118226601	59	33	85.7	1	12	185	63	121	CAH9129646.1 unnamed protein product [Cuscuta epithymum]	diamond	177	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Convolvulaceae	Cuscuta	Cuscuta epithymum
27627011	27627011	PRJDB4941_P_NODE_10824_length_340_cov_2.061856_g10056_i0	PRJDB4941	10824	340	2.061856	7.0103104	Eukaryota	2759	Plants	Plants	53.9	1.28e-5	NR	XP_068646723.1	171875	g10056	i0	65.1	2.24117647058824	43	15	37.9	0	2	130	352	394	XP_068646723.1 fructose-bisphosphate aldolase 1, chloroplastic isoform X1 [Aristolochia californica]	diamond	762	53.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Piperales	Aristolochiaceae	Aristolochia	Aristolochia californica
28573987	28573987	PRJDB4941_P_NODE_18667_length_238_cov_3.370370_g17899_i0	PRJDB4941	18667	238	3.37037	8.0214806	Cannabaceae	3481	Plants	Plants	53.5	1.86e-6	NR	PON69366.1	3476	g17899	i0	39.5	1.72689075630252	81	39	92	4	17	235	36	114	PON69366.1 Rapid ALkalinization Factor [Parasponia andersonii]	diamond	411	53.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Parasponia	Parasponia andersonii
29710344	29710344	PRJDB4941_P_NODE_12350_length_312_cov_2.262357_g11582_i0	PRJDB4941	12350	312	2.262357	7.05855384	Magnoliopsida	3398	Plants	Plants	90.5	1.43e-18	NR	XP_043708969.1	54955	g11582	i0	82	2.93269230769231	61	11	58.7	0	312	130	529	589	XP_043708969.1 phosphatidylinositol/phosphatidylcholine transfer protein SFH12-like isoform X2 [Telopea speciosissima]	diamond	915	91.3	0.991237677984666	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Proteales	Proteaceae	Telopea	Telopea speciosissima
30058006	30058006	PRJDB4941_P_NODE_3371_length_816_cov_1.945241_g2675_i0	PRJDB4941	3371	816	1.945241	15.87316656	Rosales	3744	Plants	Plants	233	4.799999999999999e-73	NR	PON68563.1	3476	g2675	i0	65.6	1.97426470588235	180	59	65.4	3	816	283	59	237	PON68563.1 43kDa postsynaptic protein [Parasponia andersonii]	diamond	1611	233	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Parasponia	Parasponia andersonii
30152703	30152703	PRJDB4941_P_NODE_32572_length_173_cov_1.604839_g31804_i0	PRJDB4941	32572	173	1.604839	2.77637147	Magnoliopsida	3398	Plants	Plants	53.1	3.07e-6	NR	XP_010024159.2	71139	g31804	i0	47.3	9.57225433526012	55	29	95.4	0	167	3	339	393	XP_010024159.2 pentatricopeptide repeat-containing protein At5g66520 [Eucalyptus grandis]	diamond	1656	53.5	0.992523364485981	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Myrtaceae	Eucalyptus	Eucalyptus grandis
30753289	30753289	PRJDB4941_P_NODE_41294_length_161_cov_2.625000_g40526_i0	PRJDB4941	41294	161	2.625	4.22625	Magnoliopsida	3398	Plants	Plants	78.2	3.89e-15	NR	XP_028127646.1	4442	g40526	i0	69.8	13.8260869565217	53	16	98.8	0	160	2	407	459	XP_028127646.1 hsp70-Hsp90 organizing protein 3-like [Camellia sinensis]	diamond	2226	78.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
31043920	31043920	PRJDB4941_P_NODE_7535_length_441_cov_2.298469_g6767_i0	PRJDB4941	7535	441	2.298469	10.13624829	Eucalyptus grandis	71139	Plants	Plants	67.4	8.46e-12	NR	KAK2631673.1	71139	g6767	i0	46.3	0.45578231292517	67	32	42.9	1	399	211	1	67	KAK2631673.1 hypothetical protein EUGRSUZ_L02597 [Eucalyptus grandis]	diamond	201	67.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Myrtaceae	Eucalyptus	Eucalyptus grandis
32624720	32624720	PRJDB4941_P_NODE_15440_length_269_cov_1.990909_g14672_i0	PRJDB4941	15440	269	1.990909	5.35554521	Sphagnum balticum	128184	Plants	Plants	66.6	2.03e-10	NR	CAM6003900.1	128184	g14672	i0	31.2	0.858736059479554	77	53	85.9	0	248	18	638	714	CAM6003900.1 unnamed protein product [Sphagnum balticum]	diamond	231	66.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
32655992	32655992	PRJDB4941_P_NODE_33920_length_169_cov_1.591667_g33152_i0	PRJDB4941	33920	169	1.591667	2.68991723	Ceratopteris richardii	49495	Plants	Plants	43.9	0.00548	NR	KAH7281993.1	49495	g33152	i0	45.5	2.00591715976331	55	26	90.5	1	156	4	64	118	KAH7281993.1 hypothetical protein KP509_35G007000, partial [Ceratopteris richardii]	diamond	339	43.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Ceratopteris	Ceratopteris richardii
32655995	32655995	PRJDB4941_P_NODE_36860_length_166_cov_0.888889_g36092_i0	PRJDB4941	36860	166	0.888889	1.47555574	Sphagnum tenellum	128247	Plants	Plants	85.1	6.09e-18	NR	CAM6053376.1	128247	g36092	i0	80	0.993975903614458	55	11	99.4	0	166	2	189	243	CAM6053376.1 unnamed protein product [Sphagnum tenellum]	diamond	165	85.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum tenellum
32656000	32656000	PRJDB4941_P_NODE_40860_length_162_cov_0.920354_g40092_i0	PRJDB4941	40860	162	0.920354	1.49097348	Acacia pycnantha	880440	Plants	Plants	52.8	2.92e-6	NR	KAI9124500.1	880440	g40092	i0	48.9	4.38888888888889	47	24	87	0	161	21	200	246	KAI9124500.1 hypothetical protein K1719_004422 [Acacia pycnantha]	diamond	711	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Acacia	Acacia pycnantha

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