metadata: contig_metadata: 8 rows where bioproject = "PRJNA454154" and tax

8 rows where bioproject = "PRJNA454154" 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
6819644	6819644	PRJNA454154_S_NODE_246_length_209_cov_3.930233_g243_i0	PRJNA454154	246	209	3.930233	8.21418697	Vicia villosa	3911	Plants	Plants	115	2.3e-21	NTclustered	gi\|2563789913\|ref\|XM_058916908.1\|	3911	g243	i0	84.483	2.11961722488038	116	18	56	0	47	162	263	148	PREDICTED: Vicia villosa small ribosomal subunit protein eS30z/eS30y/eS30x (LOC131646989), mRNA	blastn	443	115	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vicia	Vicia villosa
12572285	12572285	PRJNA454154_S_NODE_490_length_170_cov_3.037594_g487_i0	PRJNA454154	490	170	3.037594	5.1639098	Magnoliopsida	3398	Plants	Plants	141	2.95e-29	NTclustered	gi\|1117477653\|ref\|XM_019570971.1\|	3871	g487	i0	84.932	55.8176470588235	146	14	84	6	26	167	551	410	PREDICTED: Lupinus angustifolius 40S ribosomal protein S23 (LOC109334968), mRNA	blastn	9489	141	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lupinus	Lupinus angustifolius
18944922	18944922	PRJNA454154_S_NODE_55_length_351_cov_22.261146_g52_i0	PRJNA454154	55	351	22.261146	78.13662246	Streptophyta	35493	Plants	Plants	231	3.97e-56	NTclustered	gi\|1878849191\|gb\|MT796534.1\|	3289	g52	i0	91.765	48.4330484330484	170	8	48	4	4	173	2717	2880	Dryopteris filix-mas isolate DM497 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence	blastn	17000	231	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Dryopteridaceae	Dryopteris	Dryopteris filix-mas
20843642	20843642	PRJNA454154_S_NODE_217_length_219_cov_11.934066_g214_i0	PRJNA454154	217	219	11.934066	26.13560454	Andrographis paniculata	175694	Plants	Plants	156	1.44e-33	NTclustered	gi\|2320600742\|ref\|XM_051287597.1\|	175694	g214	i0	86.957	17.4520547945205	138	18	63	0	67	204	550	413	PREDICTED: Andrographis paniculata 60S ribosomal protein L23-like (LOC127259975), mRNA	blastn	3822	156	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Acanthaceae	Andrographis	Andrographis paniculata
22770389	22770389	PRJNA454154_S_NODE_478_length_171_cov_3.529851_g475_i0	PRJNA454154	478	171	3.529851	6.03604521	Eukaryota	2759	Plants	Plants	239	1.02e-58	NTclustered	gi\|388505617\|gb\|BT141081.1\|	34305	g475	i0	91.86	65.4561403508772	172	12	100	2	1	171	153	323	Lotus japonicus clone JCVI-FLLj-20H3 unknown mRNA	blastn	11193	241	0.991701244813278	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
26664322	26664322	PRJNA454154_S_NODE_81_length_299_cov_222.278626_g78_i0	PRJNA454154	81	299	222.278626	664.61309174	Aristolochia fimbriata	158543	Plants	Plants	44.7	0.0155	NR	KAG9438844.1	158543	g78	i0	57.8	0.451505016722408	45	10	45.2	1	24	158	460	495	KAG9438844.1 hypothetical protein H6P81_021249 [Aristolochia fimbriata]	diamond	135	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Piperales	Aristolochiaceae	Aristolochia	Aristolochia fimbriata
27581591	27581591	PRJNA454154_S_NODE_224_length_215_cov_7.876404_g221_i0	PRJNA454154	224	215	7.876404	16.9342686	Ceratodon purpureus	3225	Plants	Plants	44.7	7.81e-4	NR	KAG0504195.1	3225	g221	i0	56.4	0.544186046511628	39	17	54.4	0	90	206	38	76	KAG0504195.1 hypothetical protein KC19_N006800 [Ceratodon purpureus]	diamond	117	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Pseudoditrichales	Ditrichaceae	Ceratodon	Ceratodon purpureus
28166264	28166264	PRJNA454154_S_NODE_285_length_199_cov_2.302469_g282_i0	PRJNA454154	285	199	2.302469	4.58191331	Eukaryota	2759	Plants	Plants	98.2	7.68e-24	NR	KAF2325664.1	3981	g282	i0	75	27.8592964824121	56	14	84.4	0	1	168	129	184	KAF2325664.1 hypothetical protein GH714_032390 [Hevea brasiliensis]	diamond	5544	98.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Hevea	Hevea brasiliensis

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