metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1242190" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1242190" 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
350812	350812	PRJNA1242190_S_NODE_7581_length_308_cov_4.391489_g7574_i0	PRJNA1242190	7581	308	4.391489	13.52578612	Oryza sativa	4530	Plants	Plants	193	1.62e-44	NTclustered	gi\|116640607\|emb\|CT836548.1\|	39946	g7574	i0	91.429	75.5194805194805	140	12	45	0	81	220	458	319	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA126A09, full insert sequence	blastn	23260	193	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
1625606	1625606	PRJNA1242190_S_NODE_4262_length_391_cov_1.647799_g4255_i0	PRJNA1242190	4262	391	1.647799	6.44289409	Asparagus officinalis	4686	Plants	Plants	165	4.6e-36	NTclustered	gi\|1150745047\|ref\|XM_020391108.1\|	4686	g4255	i0	85.897	20.8823529411765	156	20	40	2	15	169	538	692	PREDICTED: Asparagus officinalis 40S ribosomal protein S5-like (LOC109824499), mRNA	blastn	8165	165	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asparagales	Asparagaceae	Asparagus	Asparagus officinalis
4178175	4178175	PRJNA1242190_S_NODE_7524_length_309_cov_8.046610_g7517_i0	PRJNA1242190	7524	309	8.04661	24.8640249	Oryza sativa	4530	Plants	Plants	237	7.42e-58	NTclustered	gi\|116641420\|emb\|CT836962.1\|	39946	g7517	i0	91.813	0.553398058252427	171	12	55	2	1	170	183	14	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA211B12, full insert sequence	blastn	171	237	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
11829500	11829500	PRJNA1242190_S_NODE_3050_length_444_cov_2.673854_g3043_i0	PRJNA1242190	3050	444	2.673854	11.87191176	Hordeum vulgare	4513	Plants	Plants	544	5.81e-150	NTclustered	gi\|326507517\|dbj\|AK371954.1\|	112509	g3043	i0	89.116	8.73198198198198	441	43	99	2	3	442	721	1157	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2143N22	blastn	3877	544	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
14380126	14380126	PRJNA1242190_S_NODE_9652_length_277_cov_2.754902_g9645_i0	PRJNA1242190	9652	277	2.754902	7.63107854	Homolepis glutinosa	158104	Plants	Plants	73.1	1.96e-8	NTclustered	gi\|2879580981\|emb\|OZ217211.1\|	158104	g9645	i0	97.619	15.0902527075812	42	1	15	0	4	45	16789	16830	Homolepis glutinosa genome assembly, organelle: plastid:chloroplast	blastn	4180	73.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Homolepis	Homolepis glutinosa
15078710	15078710	PRJNA1242190_S_NODE_8912_length_287_cov_2.757009_g8905_i0	PRJNA1242190	8912	287	2.757009	7.91261583	root	1	Root_unresolved	Root_unresolved	58.4	5.7e-4	NTclustered	gi\|2489643074\|ref\|NC_073577.1\|	1423681	g8905	i0	100	11.9477351916376	31	0	11	0	4	34	7234	7204	Cuscuta volcanica voucher Garcia Ruiz 5108 chloroplast, complete genome	blastn	3429	58.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Convolvulaceae	Cuscuta	Cuscuta volcanica
15653896	15653896	PRJNA1242190_S_NODE_3413_length_427_cov_2.064972_g3406_i0	PRJNA1242190	3413	427	2.064972	8.81743044	Hordeum vulgare	4513	Plants	Plants	322	2.84e-83	NTclustered	gi\|326507517\|dbj\|AK371954.1\|	112509	g3406	i0	83.478	0.807962529274005	345	57	81	0	83	427	1135	791	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2143N22	blastn	345	322	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
16928108	16928108	PRJNA1242190_S_NODE_3074_length_443_cov_1.740541_g3067_i0	PRJNA1242190	3074	443	1.740541	7.71059663	Hordeum vulgare	4513	Plants	Plants	667	0	NTclustered	gi\|326497356\|dbj\|AK371065.1\|	112509	g3067	i0	100	9.93679458239278	361	0	81	0	83	443	1115	755	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2123O06	blastn	4402	667	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
16928125	16928125	PRJNA1242190_S_NODE_5314_length_357_cov_2.105634_g5307_i0	PRJNA1242190	5314	357	2.105634	7.51711338	Oryza sativa	4530	Plants	Plants	220	8.76e-53	NTclustered	gi\|116641420\|emb\|CT836962.1\|	39946	g5307	i0	82.353	59.8067226890756	255	43	71	2	104	357	423	170	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA211B12, full insert sequence	blastn	21351	220	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
16928184	16928184	PRJNA1242190_S_NODE_9314_length_282_cov_1.157895_g9307_i0	PRJNA1242190	9314	282	1.157895	3.2652639	Cecropia pachystachya	1472306	Plants	Plants	73.1	2e-8	NTclustered	gi\|2254130330\|gb\|OM892756.1\|	1472306	g9307	i0	95.556	14.1808510638298	45	2	16	0	219	263	2935	2979	Cecropia pachystachya isolate W55 18S small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S large subunit ribosomal RNA gene, partial sequence	blastn	3999	73.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Urticaceae	Cecropia	Cecropia pachystachya
19477051	19477051	PRJNA1242190_S_NODE_7736_length_306_cov_1.317597_g7729_i0	PRJNA1242190	7736	306	1.317597	4.03184682	Oryza sativa	4530	Plants	Plants	158	5.88e-34	NTclustered	gi\|116641716\|emb\|CT837055.1\|	39946	g7729	i0	78.295	0.843137254901961	258	46	83	10	53	305	1024	772	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA209C05, full insert sequence	blastn	258	158	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
22027604	22027604	PRJNA1242190_S_NODE_12718_length_247_cov_2.080460_g12711_i0	PRJNA1242190	12718	247	2.08046	5.1387362	Oryza sativa	4530	Plants	Plants	132	2.79e-26	NTclustered	gi\|116641420\|emb\|CT836962.1\|	39946	g12711	i0	87.288	20.6720647773279	118	11	47	3	3	118	307	422	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA211B12, full insert sequence	blastn	5106	132	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
22027671	22027671	PRJNA1242190_S_NODE_5898_length_342_cov_1.263941_g5891_i0	PRJNA1242190	5898	342	1.263941	4.32267822	Oryza sativa	4530	Plants	Plants	344	4.76e-90	NTclustered	gi\|116641411\|emb\|CT836953.1\|	39946	g5891	i0	85.088	1.8187134502924	342	45	99	5	1	339	532	870	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA114K09, full insert sequence	blastn	622	344	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
23303308	23303308	PRJNA1242190_S_NODE_4479_length_383_cov_1.751613_g4472_i0	PRJNA1242190	4479	383	1.751613	6.70867779	Oryza sativa	4530	Plants	Plants	292	1.98e-74	NTclustered	gi\|32972574\|dbj\|AK062556.1\|	39947	g4472	i0	83.492	72.0078328981723	315	50	82	2	70	383	619	306	Oryza sativa Japonica Group cDNA clone:001-104-H10, full insert sequence	blastn	27579	292	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
25277186	25277186	PRJNA1242190_S_NODE_3980_length_401_cov_5.817073_g3973_i0	PRJNA1242190	3980	401	5.817073	23.32646273	Eukaryota	2759	Plants	Plants	69.4	3.82e-7	NTclustered	gi\|2217234705\|ref\|XM_047481278.1\|	253017	g3973	i0	84.722	3.4214463840399	72	7	17	4	1	70	160	229	PREDICTED: Impatiens glandulifera 60S ribosomal protein L29-1-like (LOC124940743), mRNA	blastn	1372	69.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Balsaminaceae	Impatiens	Impatiens glandulifera

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