metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJDB12134" and tax

8 rows where analysis = "diamond", bioproject = "PRJDB12134" 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
26715422	26715422	PRJDB12134_P_NODE_11501_length_266_cov_1.259067_g11366_i0	PRJDB12134	11501	266	1.259067	3.34911822	Aegilops tauschii subsp. strangulata	200361	Plants	Plants	68.6	1.48e-11	NR	XP_045087549.1	200361	g11366	i0	72.7	0.496240601503759	44	12	49.6	0	83	214	93	136	XP_045087549.1 branchpoint-bridging protein-like [Aegilops tauschii subsp. strangulata]	diamond	132	68.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Aegilops	Aegilops tauschii
27158485	27158485	PRJDB12134_P_NODE_11702_length_263_cov_1.300000_g11567_i0	PRJDB12134	11702	263	1.3	3.419	Aegilops tauschii subsp. strangulata	200361	Plants	Plants	103	6.6900000000000006e-26	NR	XP_020167899.1	200361	g11567	i0	64.2	0.923954372623574	81	29	92.4	0	243	1	1	81	XP_020167899.1 B3 domain-containing protein Os03g0212300-like [Aegilops tauschii subsp. strangulata]	diamond	243	103	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Aegilops	Aegilops tauschii
27317033	27317033	PRJDB12134_P_NODE_13823_length_245_cov_0.901163_g13688_i0	PRJDB12134	13823	245	0.901163	2.20784935	Nicotiana tomentosiformis	4098	Plants	Plants	45.4	0.00416	NR	XP_009598380.1	4098	g13688	i0	32.8	3.39183673469388	58	36	67.3	1	19	183	206	263	XP_009598380.1 hyphally regulated cell wall protein 3-like isoform X1 [Nicotiana tomentosiformis]	diamond	831	45.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Nicotiana	Nicotiana tomentosiformis
28863962	28863962	PRJDB12134_P_NODE_10468_length_282_cov_1.311005_g10333_i0	PRJDB12134	10468	282	1.311005	3.6970341	Triticum aestivum	4565	Plants	Plants	45.1	0.00641	NR	XP_044437725.1	4565	g10333	i0	44.9	0.521276595744681	49	22	52.1	1	279	133	158	201	XP_044437725.1 uncharacterized protein LOC123164358 [Triticum aestivum]	diamond	147	45.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
28990644	28990644	PRJDB12134_P_NODE_13268_length_248_cov_0.885714_g13133_i0	PRJDB12134	13268	248	0.885714	2.19657072	Diospyros lotus	55363	Plants	Plants	110	7.98e-26	NR	XP_052171565.1	55363	g13133	i0	61.7	4.8991935483871	81	31	98	0	5	247	594	674	XP_052171565.1 uncharacterized protein LOC127787547 [Diospyros lotus]	diamond	1215	110	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Ebenaceae	Diospyros	Diospyros lotus
29811132	29811132	PRJDB12134_P_NODE_10731_length_278_cov_1.507317_g10596_i0	PRJDB12134	10731	278	1.507317	4.19034126	Triticum aestivum	4565	Plants	Plants	129	1.17e-32	NR	XBI43231.1	4565	g10596	i0	73.5	0.89568345323741	83	22	89.6	0	252	4	107	189	XBI43231.1 hypothetical protein VPH35_108026 [Triticum aestivum]	diamond	249	129	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
31264681	31264681	PRJDB12134_P_NODE_11415_length_267_cov_1.567010_g11280_i0	PRJDB12134	11415	267	1.56701	4.1839167	Triticum urartu	4572	Plants	Plants	58.5	1.42e-7	NR	EMS67383.1	4572	g11280	i0	67.8	0.662921348314607	59	19	66.3	0	267	91	997	1055	EMS67383.1 putative UDP-N-acetylglucosamine--peptide N-acetylglucosaminyltransferase SPINDLY [Triticum urartu]	diamond	177	58.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum urartu
32593386	32593386	PRJDB12134_P_NODE_13460_length_247_cov_0.890805_g13325_i0	PRJDB12134	13460	247	0.890805	2.20028835	Psophocarpus tetragonolobus	3891	Plants	Plants	43.5	0.0198	NR	KAK7400432.1	3891	g13325	i0	34.8	0.838056680161943	69	44	82.6	1	9	212	9	77	KAK7400432.1 hypothetical protein VNO78_11639 [Psophocarpus tetragonolobus]	diamond	207	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Psophocarpus	Psophocarpus tetragonolobus

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