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

10 rows where analysis = "diamond", bioproject = "PRJNA898105" 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
21275813	21275813	PRJNA898105_P_NODE_7057_length_247_cov_0.885057_g6857_i0	PRJNA898105	7057	247	0.885057	2.18609079	Tripterygium wilfordii	458696	Plants	Plants	132	4.51e-34	NR	XP_038722228.1	458696	g6857	i0	85.4	5.97570850202429	82	12	99.6	0	247	2	282	363	XP_038722228.1 sugar transport protein 8-like [Tripterygium wilfordii]	diamond	1476	132	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Celastrales	Celastraceae	Tripterygium	Tripterygium wilfordii
26802469	26802469	PRJNA898105_P_NODE_7821_length_243_cov_0.905882_g7621_i0	PRJNA898105	7821	243	0.905882	2.20129326	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	55.5	1.26e-6	NR	BAK03555.1	112509	g7621	i0	45.1	1.01234567901235	82	43	100	2	1	243	68	148	BAK03555.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	246	55.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
27087428	27087428	PRJNA898105_P_NODE_8102_length_242_cov_0.911243_g7902_i0	PRJNA898105	8102	242	0.911243	2.20520806	Oryza sativa Japonica Group	39947	Plants	Plants	43.1	0.0185	NR	AAL82525.1	39947	g7902	i0	58.1	0.384297520661157	31	13	38.4	0	145	237	146	176	AAL82525.1 hypothetical protein [Oryza sativa Japonica Group]	diamond	93	43.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
27908290	27908290	PRJNA898105_P_NODE_7485_length_245_cov_0.895349_g7285_i0	PRJNA898105	7485	245	0.895349	2.19360505	Chloropicon primus	1764295	Plants	Plants	54.7	9.65e-7	NR	QDZ20203.1	1764295	g7285	i0	37	3.96734693877551	81	17	99.2	1	244	2	126	172	QDZ20203.1 Arf/Sar-like GTPase [Chloropicon primus]	diamond	972	54.7	1	Eukaryota		Viridiplantae	Chlorophyta	Chloropicophyceae	Chloropicales	Chloropicaceae	Chloropicon	Chloropicon primus
28255777	28255777	PRJNA898105_P_NODE_6086_length_251_cov_0.865169_g5886_i0	PRJNA898105	6086	251	0.865169	2.17157419	Mikania micrantha	192012	Plants	Plants	48.1	5.25e-4	NR	KAD4585389.1	192012	g5886	i0	41.5	0.776892430278884	65	37	77.7	1	47	241	218	281	KAD4585389.1 hypothetical protein E3N88_22990 [Mikania micrantha]	diamond	195	48.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Mikania	Mikania micrantha
28705726	28705726	PRJNA898105_P_NODE_3947_length_290_cov_1.188940_g3747_i0	PRJNA898105	3947	290	1.18894	3.447926	Chlorophyta	3041	Plants	Plants	149	2.54e-40	NR	GBF95994.1	307507	g3747	i0	77.8	19.6655172413793	90	20	93.1	0	21	290	218	307	GBF95994.1 glycylpeptide N-tetradecanoyltransferase-like [Raphidocelis subcapitata]	diamond	5703	149	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
29613233	29613233	PRJNA898105_P_NODE_6950_length_247_cov_1.385057_g6750_i0	PRJNA898105	6950	247	1.385057	3.42109079	Chlorella ohadii	2649997	Plants	Plants	49.3	1.96e-4	NR	KAI7846321.1	2649997	g6750	i0	51.6	0.753036437246964	31	15	37.7	0	1	93	671	701	KAI7846321.1 hypothetical protein COHA_000158 [Chlorella ohadii]	diamond	186	49.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
29992611	29992611	PRJNA898105_P_NODE_7651_length_244_cov_0.900585_g7451_i0	PRJNA898105	7651	244	0.900585	2.1974274	Citrullus colocynthis	252529	Plants	Plants	144	8.51e-39	NR	CAK9321159.1	252529	g7451	i0	95	0.983606557377049	80	4	98.4	0	241	2	47	126	CAK9321159.1 unnamed protein product [Citrullus colocynthis]	diamond	240	144	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Citrullus	Citrullus colocynthis
31137368	31137368	PRJNA898105_P_NODE_6655_length_249_cov_0.875000_g6455_i0	PRJNA898105	6655	249	0.875	2.17875	Eukaryota	2759	Plants	Plants	105	1.06e-24	NR	XP_059454421.1	13451	g6455	i0	67.5	12.566265060241	83	25	98.8	2	247	2	248	329	XP_059454421.1 malate dehydrogenase, cytoplasmic-like isoform X1 [Corylus avellana]	diamond	3129	106	0.990566037735849	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Corylus	Corylus avellana
31359118	31359118	PRJNA898105_P_NODE_8356_length_241_cov_0.916667_g8156_i0	PRJNA898105	8356	241	0.916667	2.20916747	Eukaryota	2759	Plants	Plants	67.8	5.57e-11	NR	KAJ7531587.1	34168	g8156	i0	58.5	5.27800829875519	53	22	66	0	241	83	671	723	KAJ7531587.1 hypothetical protein O6H91_14G050000 [Diphasiastrum complanatum]	diamond	1272	67.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Lycopodiopsida	Lycopodiales	Lycopodiaceae	Diphasiastrum	Diphasiastrum complanatum

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