metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJEB50765" and tax

25 rows where analysis = "blastn", bioproject = "PRJEB50765" 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
119550	119550	PRJEB50765_P_NODE_1101_length_303_cov_1.597744_g1077_i0	PRJEB50765	1101	303	1.597744	4.84116432	Asparagus officinalis	4686	Plants	Plants	128	4.56e-25	NTclustered	gi\|1150745047\|ref\|XM_020391108.1\|	4686	g1077	i0	87.963	13.8481848184818	108	13	36	0	1	108	585	692	PREDICTED: Asparagus officinalis 40S ribosomal protein S5-like (LOC109824499), mRNA	blastn	4196	128	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asparagales	Asparagaceae	Asparagus	Asparagus officinalis
119565	119565	PRJEB50765_P_NODE_521_length_474_cov_3.521739_g498_i0	PRJEB50765	521	474	3.521739	16.69304286	Impatiens glandulifera	253017	Plants	Plants	250	1.52e-61	NTclustered	gi\|2217250433\|ref\|XM_047452740.1\|	253017	g498	i0	81.639	53.8059071729958	305	52	64	4	171	473	417	115	PREDICTED: Impatiens glandulifera ubiquitin-40S ribosomal protein S27a-like (LOC124912179), mRNA	blastn	25504	250	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Balsaminaceae	Impatiens	Impatiens glandulifera
2266598	2266598	PRJEB50765_P_NODE_2802_length_165_cov_2.703125_g2778_i0	PRJEB50765	2802	165	2.703125	4.46015625	Chara	13778	Plants	Plants	300	4.46e-77	NTclustered	gi\|111610553\|gb\|DQ846906.1\|	69334	g2778	i0	99.394	47.3636363636364	165	1	100	0	1	165	20	184	Chara contraria clone 4 actin mRNA, partial cds	blastn	7815	300	1	Eukaryota		Viridiplantae	Streptophyta	Charophyceae	Charales	Characeae	Chara	Chara contraria
2669622	2669622	PRJEB50765_P_NODE_2383_length_183_cov_1.568493_g2359_i0	PRJEB50765	2383	183	1.568493	2.87034219	Triticum dicoccoides	85692	Plants	Plants	54.7	0.004	NTclustered	gi\|1931554709\|ref\|XM_037587967.1\|	85692	g2359	i0	96.875	1.55191256830601	32	1	17	0	111	142	619	588	PREDICTED: Triticum dicoccoides histone H1-like (LOC119312241), mRNA	blastn	284	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum dicoccoides
3945641	3945641	PRJEB50765_P_NODE_1764_length_221_cov_1.244565_g1740_i0	PRJEB50765	1764	221	1.244565	2.75048865	Hordeum vulgare	4513	Plants	Plants	213	8.49e-51	NTclustered	gi\|151421524\|dbj\|AK252677.1\|	112509	g1740	i0	86.224	0.886877828054299	196	27	89	0	22	217	425	230	Hordeum vulgare subsp. vulgare cDNA clone: FLbaf163n05, mRNA sequence	blastn	196	213	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
5221958	5221958	PRJEB50765_P_NODE_1565_length_240_cov_1.536946_g1541_i0	PRJEB50765	1565	240	1.536946	3.6886704	Phyllostachys edulis	38705	Plants	Plants	444	3.05e-120	NTclustered	gi\|242385686\|emb\|FP093538.1\|	38705	g1541	i0	100	1	240	0	100	0	1	240	1005	766	Phyllostachys edulis cDNA clone: bphyem126a22, full insert sequence	blastn	240	444	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
5221960	5221960	PRJEB50765_P_NODE_1785_length_219_cov_1.472527_g1761_i0	PRJEB50765	1785	219	1.472527	3.22483413	Triticum aestivum	4565	Plants	Plants	405	1.29e-108	NTclustered	gi\|1251755471\|dbj\|AK454002.1\|	4565	g1761	i0	100	1.27397260273973	219	0	100	0	1	219	592	374	Triticum aestivum mRNA, clone: tplb0004c01, cultivar Chinese Spring	blastn	279	405	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
5221972	5221972	PRJEB50765_P_NODE_505_length_480_cov_3.293454_g482_i0	PRJEB50765	505	480	3.293454	15.8085792	Phyllostachys edulis	38705	Plants	Plants	887	0	NTclustered	gi\|242388190\|emb\|FP094850.1\|	38705	g482	i0	100	1.87083333333333	480	0	100	0	1	480	123	602	Phyllostachys edulis cDNA clone: bphyem103d09, full insert sequence	blastn	898	887	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
6497783	6497783	PRJEB50765_P_NODE_106_length_984_cov_4.564942_g95_i0	PRJEB50765	106	984	4.564942	44.91902928	Phyllostachys edulis	38705	Plants	Plants	1796	0	NTclustered	gi\|242385481\|emb\|FP098484.1\|	38705	g95	i0	99.897	41.3150406504065	975	1	99	0	1	975	2	976	Phyllostachys edulis cDNA clone: bphyem103i24, full insert sequence	blastn	40654	1796	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
6497795	6497795	PRJEB50765_P_NODE_2486_length_178_cov_1.900709_g2462_i0	PRJEB50765	2486	178	1.900709	3.38326202	Nelumbo nucifera	4432	Plants	Plants	148	1.87e-31	NTclustered	gi\|1102796387\|ref\|XM_010249276.2\|	4432	g2462	i0	83.75	44.5224719101124	160	22	90	2	9	168	448	293	PREDICTED: Nelumbo nucifera adenosylhomocysteinase (LOC104590561), mRNA	blastn	7925	148	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Proteales	Nelumbonaceae	Nelumbo	Nelumbo nucifera
6497806	6497806	PRJEB50765_P_NODE_846_length_359_cov_1.397516_g822_i0	PRJEB50765	846	359	1.397516	5.01708244	Cryptomeria japonica	3369	Plants	Plants	193	1.92e-44	NTclustered	gi\|1173203591\|dbj\|AK407401.1\|	3369	g822	i0	85.106	57.0278551532033	188	28	52	0	167	354	247	434	Cryptomeria japonica mRNA, clone: CFFL011_E08, expressed in female strobili	blastn	20473	193	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
7368869	7368869	PRJEB50765_P_NODE_3286_length_151_cov_1.368421_g3262_i0	PRJEB50765	3286	151	1.368421	2.06631571	Oryza	4527	Plants	Plants	93.5	7.26e-15	NTclustered	gi\|8570076\|dbj\|AP002522.1\|	39947	g3262	i0	93.548	7.02649006622517	62	4	41	0	65	126	142791	142730	Oryza sativa Japonica Group genomic DNA, chromosome 1, PAC clone:P0009G03	blastn	1061	93.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
7771959	7771959	PRJEB50765_P_NODE_3107_length_156_cov_1.285714_g3083_i0	PRJEB50765	3107	156	1.285714	2.00571384	Phyllostachys edulis	38705	Plants	Plants	281	1.51e-71	NTclustered	gi\|242385686\|emb\|FP093538.1\|	38705	g3083	i0	99.359	1	156	0	100	1	1	156	166	12	Phyllostachys edulis cDNA clone: bphyem126a22, full insert sequence	blastn	156	281	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
9046797	9046797	PRJEB50765_P_NODE_648_length_426_cov_3.164524_g624_i0	PRJEB50765	648	426	3.164524	13.48087224	Oryza sativa	4530	Plants	Plants	599	1.1699999999999997e-166	NTclustered	gi\|116641420\|emb\|CT836962.1\|	39946	g624	i0	92.217	5.3169014084507	424	31	99	2	1	423	22	444	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA211B12, full insert sequence	blastn	2265	599	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
12470317	12470317	PRJEB50765_P_NODE_2590_length_174_cov_1.138686_g2566_i0	PRJEB50765	2590	174	1.138686	1.98131364	Eukaryota	2759	Plants	Plants	58.4	3.15e-4	NTclustered	gi\|2008855349\|emb\|HG996468.1\|	214687	g2566	i0	100	17.8505747126437	31	0	18	0	127	157	1387413	1387383	Musa acuminata subsp. malaccensis strain Doubled-haploid Pahang (DH-Pahang) genome assembly, chromosome: A03	blastn	3106	58.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Musaceae	Musa	Musa acuminata
15421926	15421926	PRJEB50765_P_NODE_93_length_1024_cov_2.458967_g83_i0	PRJEB50765	93	1024	2.458967	25.17982208	Hordeum vulgare	4513	Plants	Plants	1869	0	NTclustered	gi\|326497356\|dbj\|AK371065.1\|	112509	g83	i0	99.61	2.5400390625	1025	3	100	1	1	1024	1043	19	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2123O06	blastn	2601	1869	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
17971106	17971106	PRJEB50765_P_NODE_2015_length_202_cov_2.345455_g1991_i0	PRJEB50765	2015	202	2.345455	4.7378191	Oryza sativa	4530	Plants	Plants	230	7.569999999999998e-56	NTclustered	gi\|116641411\|emb\|CT836953.1\|	39946	g1991	i0	87.192	1.18811881188119	203	24	100	2	1	202	947	746	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA114K09, full insert sequence	blastn	240	230	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
17971112	17971112	PRJEB50765_P_NODE_2795_length_166_cov_1.201550_g2771_i0	PRJEB50765	2795	166	1.20155	1.994573	Triticum aestivum	4565	Plants	Plants	307	2.69e-79	NTclustered	gi\|1251755471\|dbj\|AK454002.1\|	4565	g2771	i0	100	5.19277108433735	166	0	100	0	1	166	967	802	Triticum aestivum mRNA, clone: tplb0004c01, cultivar Chinese Spring	blastn	862	307	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
19245132	19245132	PRJEB50765_P_NODE_2356_length_184_cov_2.054422_g2332_i0	PRJEB50765	2356	184	2.054422	3.78013648	Zingiber officinale	94328	Plants	Plants	62.1	2.61e-5	NTclustered	gi\|2069986514\|ref\|XM_042552608.1\|	94328	g2332	i0	86.667	0.326086956521739	60	2	30	5	119	174	938	995	PREDICTED: Zingiber officinale histone-lysine N-methyltransferase ASHR2-like (LOC121997933), mRNA	blastn	60	62.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Zingiberaceae	Zingiber	Zingiber officinale
20520441	20520441	PRJEB50765_P_NODE_1177_length_287_cov_2.144000_g1153_i0	PRJEB50765	1177	287	2.144	6.15328	Camelina sativa	90675	Plants	Plants	207	5.35e-49	NTclustered	gi\|1109148992\|ref\|XM_010417426.2\|	90675	g1153	i0	86.082	73.8118466898955	194	25	67	2	78	270	409	217	PREDICTED: Camelina sativa ADP-ribosylation factor 2-B (LOC104701687), transcript variant X1, mRNA	blastn	21184	207	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Camelina	Camelina sativa
20520454	20520454	PRJEB50765_P_NODE_37_length_1452_cov_7.590106_g32_i0	PRJEB50765	37	1452	7.590106	110.20833912	Phyllostachys edulis	38705	Plants	Plants	2675	0	NTclustered	gi\|242386712\|emb\|FP099117.1\|	38705	g32	i0	99.931	58.7906336088154	1451	1	99	0	2	1452	1466	16	Phyllostachys edulis cDNA clone: bphyem207e20, full insert sequence	blastn	85364	2675	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
23071559	23071559	PRJEB50765_P_NODE_1659_length_230_cov_1.502591_g1635_i0	PRJEB50765	1659	230	1.502591	3.4559593	Hordeum vulgare	4513	Plants	Plants	372	1.39e-98	NTclustered	gi\|326507517\|dbj\|AK371954.1\|	112509	g1635	i0	96.053	3.13913043478261	228	9	99	0	1	228	246	19	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2143N22	blastn	722	372	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
23071574	23071574	PRJEB50765_P_NODE_519_length_474_cov_4.775744_g496_i0	PRJEB50765	519	474	4.775744	22.63702656	Phyllostachys edulis	38705	Plants	Plants	876	0	NTclustered	gi\|242387325\|emb\|FP099531.1\|	38705	g496	i0	100	2.90295358649789	474	0	100	0	1	474	486	13	Phyllostachys edulis cDNA clone: bphyem109b08, full insert sequence	blastn	1376	876	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
24345413	24345413	PRJEB50765_P_NODE_2140_length_195_cov_1.981013_g2116_i0	PRJEB50765	2140	195	1.981013	3.86297535	Oryza sativa	4530	Plants	Plants	228	2.609999999999999e-55	NTclustered	gi\|116640654\|emb\|CT836596.1\|	39946	g2116	i0	91.515	91.1487179487179	165	14	85	0	1	165	16	180	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA116N01, full insert sequence	blastn	17774	228	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
24345418	24345418	PRJEB50765_P_NODE_2540_length_176_cov_1.654676_g2516_i0	PRJEB50765	2540	176	1.654676	2.91222976	Papaver somniferum	3469	Plants	Plants	97.1	6.76e-16	NTclustered	gi\|1484805139\|ref\|XM_026537910.1\|	3469	g2516	i0	80.147	2.84090909090909	136	21	76	6	4	136	530	398	PREDICTED: Papaver somniferum V-type proton ATPase 16 kDa proteolipid subunit-like (LOC113288790), mRNA	blastn	500	97.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Papaveraceae	Papaver	Papaver somniferum

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