metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA560029" 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
20946001	20946001	PRJNA560029_S_NODE_1897_length_607_cov_2.483146_g1680_i0	PRJNA560029	1897	607	2.483146	15.07269622	Striga hermonthica	68872	Plants	Plants	85.5	1.93e-15	NR	CAA0824278.1	68872	g1680	i0	65.7	2.80724876441516	67	23	33.1	0	24	224	508	574	CAA0824278.1 Protein SUPPRESSOR OF K(+) TRANSPORT GROWTH DEFECT 1 [Striga hermonthica]	diamond	1704	85.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Orobanchaceae	Striga	Striga hermonthica
27047389	27047389	PRJNA560029_S_NODE_5442_length_426_cov_2.790368_g5218_i0	PRJNA560029	5442	426	2.790368	11.88696768	Selaginella moellendorffii	88036	Plants	Plants	53.9	3.06e-5	NR	XP_002982367.2	88036	g5218	i0	32.6	0.605633802816901	86	50	60.6	1	7	264	332	409	XP_002982367.2 lecithin-cholesterol acyltransferase-like 1 [Selaginella moellendorffii]	diamond	258	53.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Lycopodiopsida	Selaginellales	Selaginellaceae	Selaginella	Selaginella moellendorffii
27061327	27061327	PRJNA560029_S_NODE_26662_length_272_cov_2.381910_g26438_i0	PRJNA560029	26662	272	2.38191	6.4787952	Magnoliopsida	3398	Plants	Plants	44.7	0.00187	NR	XP_052298902.1	2711	g26438	i0	90.5	3.52941176470588	21	2	23.2	0	2	64	71	91	XP_052298902.1 enhancer of rudimentary homolog isoform X2 [Citrus sinensis]	diamond	960	45.1	0.991130820399113	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus sinensis
28626638	28626638	PRJNA560029_S_NODE_27587_length_268_cov_3.117949_g27363_i0	PRJNA560029	27587	268	3.117949	8.35610332	Tanacetum cinerariifolium	118510	Plants	Plants	43.9	0.0191	NR	GEY25438.1	118510	g27363	i0	26	0.861940298507463	77	55	84	2	34	258	286	362	GEY25438.1 hypothetical protein [Tanacetum cinerariifolium]	diamond	231	43.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
28735178	28735178	PRJNA560029_S_NODE_23367_length_287_cov_1.116822_g23143_i0	PRJNA560029	23367	287	1.116822	3.20527914	Magnoliopsida	3398	Plants	Plants	96.3	1.02e-20	NR	XP_026402992.1	3469	g23143	i0	50	131.738675958188	86	42	88.9	1	259	5	3415	3500	XP_026402992.1 auxin transport protein BIG-like [Papaver somniferum]	diamond	37809	96.7	0.995863495346432	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Papaveraceae	Papaver	Papaver somniferum
28798103	28798103	PRJNA560029_S_NODE_18327_length_311_cov_2.894958_g18103_i0	PRJNA560029	18327	311	2.894958	9.00331938	Eukaryota	2759	Plants	Plants	118	1.99e-28	NR	XP_024376533.1	3218	g18103	i0	59	20.2861736334405	105	36	99.4	3	311	3	229	328	XP_024376533.1 RNA cytidine acetyltransferase 1-like isoform X2 [Physcomitrium patens]	diamond	6309	118	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Funariales	Funariaceae	Physcomitrium	Physcomitrium patens
28847273	28847273	PRJNA560029_S_NODE_15028_length_330_cov_3.964981_g14804_i0	PRJNA560029	15028	330	3.964981	13.0844373	Chenopodium quinoa	63459	Plants	Plants	159	6.339999999999999e-46	NR	XP_021719869.1	63459	g14804	i0	76.1	0.990909090909091	109	26	99.1	0	1	327	33	141	XP_021719869.1 uncharacterized protein LOC110687515 [Chenopodium quinoa]	diamond	327	159	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Chenopodiaceae	Chenopodium	Chenopodium quinoa
29587340	29587340	PRJNA560029_S_NODE_4410_length_452_cov_5.799472_g4186_i0	PRJNA560029	4410	452	5.799472	26.21361344	Viridiplantae	33090	Plants	Plants	121	1.33e-28	NR	KAJ0544859.1	4232	g4186	i0	45.2	20.4955752212389	135	70	88.9	2	449	48	404	535	KAJ0544859.1 putative SDA1 domain-containing protein [Helianthus annuus]	diamond	9264	122	0.991803278688525	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Helianthus	Helianthus annuus
29699522	29699522	PRJNA560029_S_NODE_15990_length_324_cov_3.450199_g15766_i0	PRJNA560029	15990	324	3.450199	11.17864476	Hibiscus trionum	183268	Plants	Plants	44.3	0.022	NR	GMI99641.1	183268	g15766	i0	37.9	1.07407407407407	58	36	53.7	0	206	33	182	239	GMI99641.1 reticulon 2, VIRB2-interacting protein 2, Reticulan like protein B2 [Hibiscus trionum]	diamond	348	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Hibiscus	Hibiscus trionum
30251201	30251201	PRJNA560029_S_NODE_2392_length_555_cov_7.504149_g2171_i0	PRJNA560029	2392	555	7.504149	41.64802695	Eukaryota	2759	Plants	Plants	112	4.24e-28	NR	KAI7729300.1	4212	g2171	i0	57.4	10.1945945945946	94	40	50.8	0	2	283	26	119	KAI7729300.1 hypothetical protein M8C21_018520, partial [Ambrosia artemisiifolia]	diamond	5658	112	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Ambrosia	Ambrosia artemisiifolia
30584313	30584313	PRJNA560029_S_NODE_33513_length_246_cov_2.895954_g33289_i0	PRJNA560029	33513	246	2.895954	7.12404684	Lolium multiflorum	4521	Plants	Plants	47	2.81e-4	NR	KAK1653778.1	4521	g33289	i0	63.6	0.402439024390244	33	7	40.2	1	1	99	87	114	KAK1653778.1 hypothetical protein QYE76_071583 [Lolium multiflorum]	diamond	99	47	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Lolium	Lolium multiflorum
30647435	30647435	PRJNA560029_S_NODE_26013_length_275_cov_1.554455_g25789_i0	PRJNA560029	26013	275	1.554455	4.27475125	Urochloa decumbens	240449	Plants	Plants	73.6	7.49e-13	NR	CAL5071761.1	240449	g25789	i0	65.9	0.48	44	15	48	0	1	132	418	461	CAL5071761.1 unnamed protein product [Urochloa decumbens]	diamond	132	73.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Urochloa	Urochloa decumbens
31198385	31198385	PRJNA560029_S_NODE_25675_length_276_cov_4.113300_g25451_i0	PRJNA560029	25675	276	4.1133	11.352708	Eukaryota	2759	Plants	Plants	93.6	1e-21	NR	CAL5333938.1	4442	g25451	i0	60.8	29.6739130434783	79	26	80.4	1	3	224	83	161	CAL5333938.1 unnamed protein product [Camellia sinensis]	diamond	8190	94.4	0.991525423728813	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
31690798	31690798	PRJNA560029_S_NODE_7797_length_390_cov_3.514196_g7573_i0	PRJNA560029	7797	390	3.514196	13.7053644	Arachis ipaensis	130454	Plants	Plants	137	1.77e-38	NR	XP_016183953.1	130454	g7573	i0	66.3	4.7	101	34	77.7	0	88	390	1	101	XP_016183953.1 60S ribosomal protein L27a-3 [Arachis ipaensis]	diamond	1833	137	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Arachis	Arachis ipaensis
32197104	32197104	PRJNA560029_S_NODE_12778_length_345_cov_2.827206_g12554_i0	PRJNA560029	12778	345	2.827206	9.7538607	Lolium perenne	4522	Plants	Plants	111	6.85e-29	NR	XP_051208179.1	4522	g12554	i0	55.5	0.956521739130435	110	48	94.8	1	343	17	13	122	XP_051208179.1 uncharacterized protein LOC127324225 [Lolium perenne]	diamond	330	111	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Lolium	Lolium perenne
32228874	32228874	PRJNA560029_S_NODE_16518_length_321_cov_3.358871_g16294_i0	PRJNA560029	16518	321	3.358871	10.78197591	Arabidopsis lyrata subsp. lyrata	81972	Plants	Plants	67.4	1.24e-10	NR	XP_002865780.1	81972	g16294	i0	51.9	8.8785046728972	77	35	70.1	2	321	97	214	290	XP_002865780.1 RNA-binding protein CP31B, chloroplastic [Arabidopsis lyrata subsp. lyrata]	diamond	2850	67.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Arabidopsis	Arabidopsis lyrata
32243014	32243014	PRJNA560029_S_NODE_32978_length_248_cov_1.320000_g32754_i0	PRJNA560029	32978	248	1.32	3.2736	Magnoliopsida	3398	Plants	Plants	102	2e-23	NR	PON95832.1	63057	g32754	i0	67.1	7.94758064516129	73	23	88.3	1	246	28	361	432	PON95832.1 SecY/SEC61-alpha family [Trema orientale]	diamond	1971	102	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Trema	Trema orientale
32765526	32765526	PRJNA560029_S_NODE_9860_length_368_cov_3.667797_g9636_i0	PRJNA560029	9860	368	3.667797	13.49749296	Zea mays	4577	Plants	Plants	44.7	0.0325	NR	PWZ44109.1	4577	g9636	i0	35.8	0.546195652173913	67	42	54.6	1	300	100	1112	1177	PWZ44109.1 Disease resistance RPP13-like protein 4 [Zea mays]	diamond	201	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
32796848	32796848	PRJNA560029_S_NODE_34600_length_243_cov_2.952941_g34376_i0	PRJNA560029	34600	243	2.952941	7.17564663	Bienertia sinuspersici	338654	Plants	Plants	47.4	8e-4	NR	KAL2931251.1	338654	g34376	i0	50	3.20987654320988	52	22	64.2	1	2	157	259	306	KAL2931251.1 Plant UBX domain-containing protein 4 [Bienertia sinuspersici]	diamond	780	47.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Chenopodiaceae	Bienertia	Bienertia sinuspersici

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