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

8 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax_kingdom = "Viridiplantae"

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
19286257	19286257	PRJNA1020641_P_NODE_5736_length_250_cov_0.870056_g5693_i0	PRJNA1020641	5736	250	0.870056	2.17514	Trifolium subterraneum	3900	Plants	Plants	95.5	1.13e-20	NR	GAU52014.1	3900	g5693	i0	65.1	1.992	83	25	99.6	2	249	1	139	217	GAU52014.1 hypothetical protein TSUD_418260, partial [Trifolium subterraneum]	diamond	498	95.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Trifolium	Trifolium subterraneum
27382654	27382654	PRJNA1020641_P_NODE_6563_length_246_cov_0.890173_g6520_i0	PRJNA1020641	6563	246	0.890173	2.18982558	Vigna mungo	3915	Plants	Plants	62	7.97e-10	NR	WVZ16020.1	3915	g6520	i0	45.1	2.69512195121951	71	34	82.9	3	204	1	5	73	WVZ16020.1 hypothetical protein V8G54_013586 [Vigna mungo]	diamond	663	62	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna mungo
28582522	28582522	PRJNA1020641_P_NODE_6187_length_248_cov_0.880000_g6144_i0	PRJNA1020641	6187	248	0.88	2.1824	Mangifera indica	29780	Plants	Plants	67	1.97e-11	NR	XP_044466254.1	29780	g6144	i0	60	6.06048387096774	50	20	60.5	0	154	5	8	57	XP_044466254.1 ras-related protein Rab11D-like isoform X3 [Mangifera indica]	diamond	1503	67	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Anacardiaceae	Mangifera	Mangifera indica
31646547	31646547	PRJNA1020641_P_NODE_5577_length_251_cov_0.865169_g5534_i0	PRJNA1020641	5577	251	0.865169	2.17157419	Astrephomene gubernaculifera	47775	Plants	Plants	61.6	9.31e-9	NR	GFR44406.1	47775	g5534	i0	63.2	1.33864541832669	38	14	45.4	0	106	219	6	43	GFR44406.1 hypothetical protein Agub_g5638, partial [Astrephomene gubernaculifera]	diamond	336	61.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Astrephomenaceae	Astrephomene	Astrephomene gubernaculifera
31836325	31836325	PRJNA1020641_P_NODE_7357_length_241_cov_0.916667_g7314_i0	PRJNA1020641	7357	241	0.916667	2.20916747	Salvia divinorum	28513	Plants	Plants	42.4	0.046	NR	KAL1568354.1	28513	g7314	i0	44.7	0.473029045643154	38	20	46.1	1	215	105	104	141	KAL1568354.1 putative carboxylesterase 18 [Salvia divinorum]	diamond	114	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Lamiaceae	Salvia	Salvia divinorum
31955169	31955169	PRJNA1020641_P_NODE_3377_length_333_cov_0.888462_g3334_i0	PRJNA1020641	3377	333	0.888462	2.95857846	Eukaryota	2759	Plants	Plants	88.6	2.44e-18	NR	KAJ6801984.1	29817	g3334	i0	60	14	65	26	58.6	0	197	3	238	302	KAJ6801984.1 geranylgeranyl transferase type-2 subunit beta 1-like isoform X2 [Iris pallida]	diamond	4662	89	0.995505617977528	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asparagales	Iridaceae	Iris	Iris pallida
32121470	32121470	PRJNA1020641_P_NODE_4098_length_300_cov_1.356828_g4055_i0	PRJNA1020641	4098	300	1.356828	4.070484	Chlorella ohadii	2649997	Plants	Plants	88.2	8.25e-18	NR	KAI7840758.1	2649997	g4055	i0	47.5	4.95	99	42	99	1	3	299	2798	2886	KAI7840758.1 hypothetical protein COHA_005572 [Chlorella ohadii]	diamond	1485	88.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
32847574	32847574	PRJNA1020641_P_NODE_4980_length_267_cov_1.824742_g4937_i0	PRJNA1020641	4980	267	1.824742	4.87206114	Dorcoceras hygrometricum	472368	Plants	Plants	43.5	0.0236	NR	KZV31801.1	472368	g4937	i0	34.2	0.853932584269663	76	41	75.3	2	267	67	6	81	KZV31801.1 dystroglycan-like [Dorcoceras hygrometricum]	diamond	228	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Gesneriaceae	Dorcoceras	Dorcoceras hygrometricum

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