metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1263632" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1263632" and tax_phylum = "Streptophyta"

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
363789	363789	PRJNA1263632_P_NODE_7841_length_244_cov_0.900585_g7823_i0	PRJNA1263632	7841	244	0.900585	2.1974274	Oryza sativa	4530	Plants	Plants	274	4.31e-69	NTclustered	gi\|116641837\|emb\|CT837176.1\|	39946	g7823	i0	86.885	1	244	32	100	0	1	244	367	124	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA111P02, full insert sequence	blastn	244	274	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
1638572	1638572	PRJNA1263632_P_NODE_5522_length_269_cov_1.586735_g5504_i0	PRJNA1263632	5522	269	1.586735	4.26831715	Nymphaea colorata	210225	Plants	Plants	198	2.99e-46	NTclustered	gi\|1750920132\|emb\|LR722063.1\|	210225	g5504	i0	80.074	2.01486988847584	271	50	100	2	1	269	16574	16842	XXX	blastn	542	198	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
2914483	2914483	PRJNA1263632_P_NODE_6863_length_249_cov_0.875000_g6845_i0	PRJNA1263632	6863	249	0.875	2.17875	Hordeum vulgare	4513	Plants	Plants	276	1.2299999999999999e-69	NTclustered	gi\|326512847\|dbj\|AK372133.1\|	112509	g6845	i0	86.694	25.0160642570281	248	33	99	0	1	248	2001	1754	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2146P05	blastn	6229	276	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
4190851	4190851	PRJNA1263632_P_NODE_5764_length_264_cov_1.376963_g5746_i0	PRJNA1263632	5764	264	1.376963	3.63518232	Raphanus sativus	3726	Plants	Plants	161	3.84e-35	NTclustered	gi\|2515575766\|ref\|XM_018577648.2\|	3726	g5746	i0	79.167	27.9090909090909	240	44	90	6	3	239	333	97	PREDICTED: Raphanus sativus 60S ribosomal protein L8-1 (LOC108805715), mRNA	blastn	7368	161	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Raphanus	Raphanus sativus
4190872	4190872	PRJNA1263632_P_NODE_6464_length_251_cov_0.865169_g6446_i0	PRJNA1263632	6464	251	0.865169	2.17157419	Nymphaea colorata	210225	Plants	Plants	137	6.100000000000001e-28	NTclustered	gi\|1750920580\|emb\|LR722097.1\|	210225	g6446	i0	86.885	0.48605577689243	122	16	49	0	2	123	27487	27608	XXX	blastn	122	137	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
8706795	8706795	PRJNA1263632_P_NODE_4127_length_306_cov_1.339056_g4109_i0	PRJNA1263632	4127	306	1.339056	4.09751136	Bryaspis	110000	Plants	Plants	206	2.0699999999999997e-48	NTclustered	gi\|1382343544\|gb\|MF177984.1\|	110001	g4109	i0	82.759	44.7254901960784	232	38	75	2	3	233	242	12	Bryaspis lupulina voucher KG369400 clone B cyclophilin 1 (CYP1) gene, partial cds	blastn	13686	206	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Bryaspis	Bryaspis lupulina
9291784	9291784	PRJNA1263632_P_NODE_2088_length_420_cov_1.553314_g2070_i0	PRJNA1263632	2088	420	1.553314	6.5239188	Medicago truncatula	3880	Plants	Plants	261	6.17e-65	NTclustered	gi\|90656477\|gb\|DQ455530.1\|	3880	g2070	i0	92.553	11.0761904761905	188	5	44	9	103	286	1	183	Medicago truncatula cDNA-AFLP fragment BT43M22_480 sequence	blastn	4652	261	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Medicago	Medicago truncatula
12532656	12532656	PRJNA1263632_P_NODE_2890_length_359_cov_1.989510_g2872_i0	PRJNA1263632	2890	359	1.98951	7.1423409	Eukaryota	2759	Plants	Plants	226	1.8899999999999998e-54	NTclustered	gi\|270147606\|gb\|BT114558.1\|	3330	g2872	i0	80.743	71.3844011142061	296	51	82	4	38	330	179	471	Picea glauca clone GQ03517_A15 mRNA sequence	blastn	25627	226	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea glauca
16356437	16356437	PRJNA1263632_P_NODE_2033_length_426_cov_1.093484_g2015_i0	PRJNA1263632	2033	426	1.093484	4.65824184	Streptophyta	35493	Plants	Plants	119	3.99e-22	NTclustered	gi\|8099444\|gb\|AF226036.1\|	3234	g2015	i0	85.124	20.6760563380282	121	12	28	5	2	121	379	264	Anthoceros punctatus 26S ribosomal RNA gene, partial sequence	blastn	8808	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Anthocerotopsida	Anthocerotales	Anthocerotaceae	Anthoceros	Anthoceros punctatus
16941088	16941088	PRJNA1263632_P_NODE_914_length_619_cov_2.086081_g897_i0	PRJNA1263632	914	619	2.086081	12.91284139	Impatiens glandulifera	253017	Plants	Plants	263	2.61e-65	NTclustered	gi\|2217250433\|ref\|XM_047452740.1\|	253017	g897	i0	80.952	46.9789983844911	336	60	54	4	286	619	417	84	PREDICTED: Impatiens glandulifera ubiquitin-40S ribosomal protein S27a-like (LOC124912179), mRNA	blastn	29080	263	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Balsaminaceae	Impatiens	Impatiens glandulifera
18215474	18215474	PRJNA1263632_P_NODE_555_length_769_cov_6.790230_g538_i0	PRJNA1263632	555	769	6.79023	52.2168687	Oryza rufipogon	4529	Plants	Plants	1258	0	NTclustered	gi\|150172490\|emb\|CU406894.1\|	4529	g538	i0	96.229	4.98829648894668	769	27	100	1	1	769	774	8	Oryza rufipogon (W1943) cDNA clone: ORW1943C111D01, full insert sequence	blastn	3836	1258	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza rufipogon
18215563	18215563	PRJNA1263632_P_NODE_875_length_630_cov_1.299820_g858_i0	PRJNA1263632	875	630	1.29982	8.188866	Hordeum vulgare	4513	Plants	Plants	1160	0	NTclustered	gi\|326497356\|dbj\|AK371065.1\|	112509	g858	i0	100	3.08888888888889	628	0	99	0	3	630	733	106	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2123O06	blastn	1946	1160	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
19489746	19489746	PRJNA1263632_P_NODE_4836_length_286_cov_1.441315_g4818_i0	PRJNA1263632	4836	286	1.441315	4.1221609	Hordeum vulgare	4513	Plants	Plants	340	5.04e-89	NTclustered	gi\|326500677\|dbj\|AK363802.1\|	112509	g4818	i0	88.112	30.020979020979	286	34	100	0	1	286	187	472	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2019A03	blastn	8586	340	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
23315929	23315929	PRJNA1263632_P_NODE_6639_length_250_cov_0.870056_g6621_i0	PRJNA1263632	6639	250	0.870056	2.17514	Oryza sativa	4530	Plants	Plants	366	7.12e-97	NTclustered	gi\|32972574\|dbj\|AK062556.1\|	39947	g6621	i0	93.496	29.236	246	16	98	0	1	246	567	322	Oryza sativa Japonica Group cDNA clone:001-104-H10, full insert sequence	blastn	7309	366	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa

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