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

10 rows where analysis = "diamond", bioproject = "PRJEB55250" 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
9049036	9049036	PRJEB55250_P_NODE_3068_length_380_cov_1.657980_g2944_i0	PRJEB55250	3068	380	1.65798	6.300324	Eukaryota	2759	Plants	Plants	165	5.89e-50	NR	NP_001365255.1	3218	g2944	i0	67.8	8.36842105263158	115	37	90.8	0	347	3	7	121	NP_001365255.1 40S ribosomal protein S24-1 [Physcomitrium patens]	diamond	3180	165	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Funariales	Funariaceae	Physcomitrium	Physcomitrium patens
27127972	27127972	PRJEB55250_P_NODE_8762_length_270_cov_2.020305_g8638_i0	PRJEB55250	8762	270	2.020305	5.4548235	Dillenia turbinata	194707	Plants	Plants	118	3.8e-30	NR	KAK6916979.1	194707	g8638	i0	77.5	13.8333333333333	71	16	78.9	0	215	3	11	81	KAK6916979.1 Cytidyltransferase-like domain [Dillenia turbinata]	diamond	3735	118	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Dilleniales	Dilleniaceae	Dillenia	Dillenia turbinata
28732242	28732242	PRJEB55250_P_NODE_8647_length_271_cov_1.555556_g8523_i0	PRJEB55250	8647	271	1.555556	4.21555676	root	1	Root_unresolved	Root_unresolved	80.1	4.42e-16	NR	XP_017216104.1	79200	g8523	i0	50	21.4981549815498	74	37	81.9	0	265	44	145	218	XP_017216104.1 peroxiredoxin Q, chloroplastic [Daucus carota subsp. sativus]	diamond	5826	80.5	0.995031055900621	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Apiales	Apiaceae	Daucus	Daucus carota
29023475	29023475	PRJEB55250_P_NODE_11768_length_251_cov_0.865169_g11644_i0	PRJEB55250	11768	251	0.865169	2.17157419	Scenedesmus sp. PABB	2909984	Plants	Plants	62.4	4.91e-9	NR	KAF8058474.1	2742167	g11644	i0	46.5	0.848605577689243	71	34	82.5	2	247	41	116	184	KAF8058474.1 hypothetical protein HT031_005598 [Scenedesmus sp. PABB004]	diamond	213	62.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
29111205	29111205	PRJEB55250_P_NODE_17328_length_206_cov_4.631579_g17204_i0	PRJEB55250	17328	206	4.631579	9.54105274	Eukaryota	2759	Plants	Plants	97.8	1.2399999999999999e-23	NR	XP_022839661.1	70448	g17204	i0	75.4	4.00485436893204	69	16	99	1	205	2	116	184	XP_022839661.1 Ribosomal protein L18e, conserved site [Ostreococcus tauri]	diamond	825	98.2	0.995926680244399	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus tauri
29433262	29433262	PRJEB55250_P_NODE_15410_length_243_cov_0.905882_g15286_i0	PRJEB55250	15410	243	0.905882	2.20129326	Micromonas pusilla CCMP1545	564608	Plants	Plants	42.4	0.0499	NR	XP_003063187.1	564608	g15286	i0	59.3	0.333333333333333	27	11	33.3	0	33	113	132	158	XP_003063187.1 uncharacterized protein MICPUCDRAFT_22366 [Micromonas pusilla CCMP1545]	diamond	81	42.4	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
31448962	31448962	PRJEB55250_P_NODE_6136_length_291_cov_2.128440_g6012_i0	PRJEB55250	6136	291	2.12844	6.1937604	Chlorellales	35460	Plants	Plants	135	9.19e-39	NR	KAI3426859.1	3077	g6012	i0	78.4	7.21649484536082	88	16	89.7	2	290	30	38	123	KAI3426859.1 hypothetical protein D9Q98_006805 [Chlorella vulgaris]	diamond	2100	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
31803417	31803417	PRJEB55250_P_NODE_13677_length_247_cov_0.885057_g13553_i0	PRJEB55250	13677	247	0.885057	2.18609079	Sphagnum fallax	53036	Plants	Plants	88.6	4.23e-19	NR	KAH8974410.1	53036	g13553	i0	61.4	1.78542510121457	70	27	85	0	222	13	12	81	KAH8974410.1 hypothetical protein BDL97_01G101300 [Sphagnum fallax]	diamond	441	88.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum fallax
32594557	32594557	PRJEB55250_P_NODE_10440_length_258_cov_1.594595_g10316_i0	PRJEB55250	10440	258	1.594595	4.1140551	Taraxacum kok-saghyz	333970	Plants	Plants	57	3e-7	NR	KAL4579928.1	333970	g10316	i0	68.4	0.441860465116279	38	12	44.2	0	41	154	157	194	KAL4579928.1 hypothetical protein LXL04_016099 [Taraxacum kok-saghyz]	diamond	114	57	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Taraxacum	Taraxacum kok-saghyz
32681894	32681894	PRJEB55250_P_NODE_16380_length_241_cov_1.375000_g16256_i0	PRJEB55250	16380	241	1.375	3.31375	Viridiplantae	33090	Plants	Plants	91.7	1.59e-19	NR	CAK0785623.1	1274662	g16256	i0	63.5	8.39004149377593	74	25	92.1	2	223	2	4	75	CAK0785623.1 hypothetical protein CVIRNUC_008834 [Coccomyxa viridis]	diamond	2022	91.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis

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