metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA931595" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA931595" 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
27158114	27158114	PRJNA931595_P_NODE_14082_length_245_cov_1.790698_g13973_i0	PRJNA931595	14082	245	1.790698	4.3872101	Glycine	3846	Plants	Plants	64.7	2.38e-10	NR	KAG4931197.1	3847	g13973	i0	51.9	1.32244897959184	54	26	66.1	0	15	176	161	214	KAG4931197.1 hypothetical protein JHK86_048158 [Glycine max]	diamond	324	64.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Glycine	Glycine max
27404357	27404357	PRJNA931595_P_NODE_15863_length_232_cov_2.861635_g15754_i0	PRJNA931595	15863	232	2.861635	6.6389932	Populus alba x Populus x berolinensis	444605	Plants	Plants	42.7	0.01	NR	KAJ6934225.1	444605	g15754	i0	36.2	0.75	58	30	75	1	13	186	6	56	KAJ6934225.1 hypothetical protein NC651_009310 [Populus alba x Populus x berolinensis]	diamond	174	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus alba x Populus x berolinensis
28130557	28130557	PRJNA931595_P_NODE_13905_length_246_cov_0.890173_g13796_i0	PRJNA931595	13905	246	0.890173	2.18982558	Escallonia herrerae	1293975	Plants	Plants	46.2	0.00242	NR	KAK3038704.1	1293975	g13796	i0	41.8	0.817073170731707	67	19	81.7	2	43	243	141	187	KAK3038704.1 hypothetical protein RJ639_028311 [Escallonia herrerae]	diamond	201	46.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Escalloniales	Escalloniaceae	Escallonia	Escallonia herrerae
28193364	28193364	PRJNA931595_P_NODE_11686_length_256_cov_2.426230_g11577_i0	PRJNA931595	11686	256	2.42623	6.2111488	Cryptomeria japonica	3369	Plants	Plants	77.8	2.75e-16	NR	GLJ22190.1	3369	g11577	i0	50.8	0.76171875	65	30	75	2	248	57	3	66	GLJ22190.1 hypothetical protein SUGI_0416970 [Cryptomeria japonica]	diamond	195	77.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
29014803	29014803	PRJNA931595_P_NODE_8808_length_283_cov_1.161905_g8699_i0	PRJNA931595	8808	283	1.161905	3.28819115	Tanacetum cinerariifolium	118510	Plants	Plants	43.5	0.0329	NR	GEU42292.1	118510	g8699	i0	41.6	0.816254416961131	77	32	68.9	3	224	30	2259	2334	GEU42292.1 putative reverse transcriptase domain-containing protein [Tanacetum cinerariifolium]	diamond	231	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
29930368	29930368	PRJNA931595_P_NODE_11331_length_260_cov_1.604278_g11222_i0	PRJNA931595	11331	260	1.604278	4.1711228	Zea mays	4577	Plants	Plants	50.1	1.17e-4	NR	XP_020407480.1	4577	g11222	i0	60	0.403846153846154	35	14	40.4	0	143	39	2	36	XP_020407480.1 uncharacterized protein [Zea mays]	diamond	105	50.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
31130508	31130508	PRJNA931595_P_NODE_6435_length_316_cov_1.160494_g6326_i0	PRJNA931595	6435	316	1.160494	3.66716104	Triticum dicoccoides	85692	Plants	Plants	44.7	0.0179	NR	XP_037474086.1	85692	g6326	i0	40.9	0.626582278481013	66	36	62.7	1	260	63	129	191	XP_037474086.1 serine/arginine repetitive matrix protein 1-like [Triticum dicoccoides]	diamond	198	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum dicoccoides
31731549	31731549	PRJNA931595_P_NODE_15177_length_242_cov_0.911243_g15068_i0	PRJNA931595	15177	242	0.911243	2.20520806	Rubus argutus	59490	Plants	Plants	99.4	4.46e-22	NR	KAK9944552.1	59490	g15068	i0	70.5	1.93388429752066	78	23	96.7	0	9	242	697	774	KAK9944552.1 hypothetical protein M0R45_010113 [Rubus argutus]	diamond	468	99.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Rubus	Rubus argutus
31921471	31921471	PRJNA931595_P_NODE_13317_length_248_cov_0.880000_g13208_i0	PRJNA931595	13317	248	0.88	2.1824	Rubus argutus	59490	Plants	Plants	84.3	9.16e-17	NR	KAK9933304.1	59490	g13208	i0	71.4	0.67741935483871	56	15	66.5	1	246	82	1326	1381	KAK9933304.1 hypothetical protein M0R45_020505 [Rubus argutus]	diamond	168	84.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Rubus	Rubus argutus
32781614	32781614	PRJNA931595_P_NODE_13300_length_248_cov_0.880000_g13191_i0	PRJNA931595	13300	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	42.4	0.0235	NR	KAK2367545.1	3899	g13191	i0	44.7	1.30645161290323	47	26	56.9	0	151	11	28	74	KAK2367545.1 hypothetical protein QL285_080817 [Trifolium repens]	diamond	324	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Trifolium	Trifolium repens

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