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

9 rows where analysis = "diamond", bioproject = "PRJNA358049" 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
27250017	27250017	PRJNA358049_S_NODE_12963_length_184_cov_1.911111_g12915_i0	PRJNA358049	12963	184	1.911111	3.51644424	Eukaryota	2759	Plants	Plants	48.5	1.38e-5	NR	GFD59344.1	118510	g12915	i0	92	0.815217391304348	25	2	40.8	0	1	75	49	73	GFD59344.1 hypothetical protein [Tanacetum cinerariifolium]	diamond	150	48.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
27408279	27408279	PRJNA358049_S_NODE_17663_length_164_cov_1.286957_g17615_i0	PRJNA358049	17663	164	1.286957	2.11060948	Eukaryota	2759	Plants	Plants	53.9	2.69e-7	NR	GFD02542.1	118510	g17615	i0	57.8	1.64634146341463	45	19	82.3	0	161	27	36	80	GFD02542.1 hypothetical protein [Tanacetum cinerariifolium]	diamond	270	53.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
27454290	27454290	PRJNA358049_S_NODE_9423_length_208_cov_1.547170_g9375_i0	PRJNA358049	9423	208	1.54717	3.2181136	Eruca vesicaria	180536	Plants	Plants	102	1.24e-24	NR	CAH8382005.1	29727	g9375	i0	81.2	4.97596153846154	69	13	99.5	0	1	207	6	74	CAH8382005.1 unnamed protein product [Eruca vesicaria subsp. sativa]	diamond	1035	102	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Eruca	Eruca vesicaria
29222403	29222403	PRJNA358049_S_NODE_13249_length_183_cov_1.156716_g13201_i0	PRJNA358049	13249	183	1.156716	2.11679028	Dipteronia dyeriana	168575	Plants	Plants	62	4.27e-10	NR	KAK2641243.1	168575	g13201	i0	90.2	0.672131147540984	41	4	67.2	0	2	124	118	158	KAK2641243.1 hypothetical protein Ddye_023006 [Dipteronia dyeriana]	diamond	123	62	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Dipteronia	Dipteronia dyeriana
29397207	29397207	PRJNA358049_S_NODE_5889_length_253_cov_2.083333_g5841_i0	PRJNA358049	5889	253	2.083333	5.27083249	Oleaceae	4144	Plants	Plants	47.8	3.17e-4	NR	CAI9785147.1	56036	g5841	i0	84.6	0.948616600790514	26	4	30.8	0	2	79	135	160	CAI9785147.1 unnamed protein product [Fraxinus pennsylvanica]	diamond	240	48.1	0.993762993762994	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Fraxinus	Fraxinus pennsylvanica
29934200	29934200	PRJNA358049_S_NODE_18471_length_162_cov_1.362832_g18423_i0	PRJNA358049	18471	162	1.362832	2.20778784	Rosales	3744	Plants	Plants	47.4	2.93e-4	NR	XP_010104440.1	981085	g18423	i0	65.3	1.81481481481481	49	11	85.2	2	22	159	281	326	XP_010104440.1 HVA22-like protein i [Morus notabilis]	diamond	294	47.8	0.99163179916318	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Morus	Morus notabilis
31324252	31324252	PRJNA358049_S_NODE_14895_length_174_cov_1.248000_g14847_i0	PRJNA358049	14895	174	1.248	2.17152	Magnoliopsida	3398	Plants	Plants	45.4	2.6e-4	NR	CAD5321858.1	3702	g14847	i0	81.5	2.43103448275862	27	5	46.6	0	169	89	57	83	CAD5321858.1 unnamed protein product [Arabidopsis thaliana]	diamond	423	45.8	0.991266375545852	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Arabidopsis	Arabidopsis thaliana
31465575	31465575	PRJNA358049_S_NODE_14016_length_179_cov_1.169231_g13968_i0	PRJNA358049	14016	179	1.169231	2.09292349	Panicum virgatum	38727	Plants	Plants	41.6	0.0398	NR	KAG2547166.1	38727	g13968	i0	44	0.837988826815642	50	22	73.7	1	141	10	55	104	KAG2547166.1 hypothetical protein PVAP13_9KG069860 [Panicum virgatum]	diamond	150	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Panicum	Panicum virgatum
31908154	31908154	PRJNA358049_S_NODE_8877_length_213_cov_1.445122_g8829_i0	PRJNA358049	8877	213	1.445122	3.07810986	Capsicum baccatum	33114	Plants	Plants	40.4	0.0473	NR	PHT37769.1	33114	g8829	i0	37.5	0.788732394366197	56	35	78.9	0	169	2	12	67	PHT37769.1 hypothetical protein CQW23_21342 [Capsicum baccatum]	diamond	168	40.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Capsicum	Capsicum baccatum

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