metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA1012699" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA1012699" 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
158036	158036	PRJNA1012699_P_NODE_741_length_414_cov_1.354839_g709_i0	PRJNA1012699	741	414	1.354839	5.60903346	Lotus japonicus	34305	Plants	Plants	477	5.5399999999999986e-130	NTclustered	gi\|388509385\|gb\|BT142965.1\|	34305	g709	i0	87.621	3.16666666666667	412	50	99	1	2	413	479	69	Lotus japonicus clone JCVI-FLLj-1L16 unknown mRNA	blastn	1311	477	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
1432827	1432827	PRJNA1012699_P_NODE_2142_length_273_cov_2.330000_g2110_i0	PRJNA1012699	2142	273	2.33	6.3609	Hordeum vulgare	4513	Plants	Plants	466	7.55e-127	NTclustered	gi\|151418271\|dbj\|AK249623.1\|	112509	g2110	i0	97.778	9.32234432234432	270	6	99	0	2	271	68	337	Hordeum vulgare subsp. vulgare cDNA clone: FLbaf44i09, mRNA sequence	blastn	2545	466	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
2708317	2708317	PRJNA1012699_P_NODE_1023_length_361_cov_3.451389_g991_i0	PRJNA1012699	1023	361	3.451389	12.45951429	Hordeum vulgare	4513	Plants	Plants	514	3.63e-141	NTclustered	gi\|326523806\|dbj\|AK361870.1\|	112509	g991	i0	92.479	0.994459833795014	359	27	99	0	2	360	838	480	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2001A08	blastn	359	514	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
2708353	2708353	PRJNA1012699_P_NODE_2843_length_251_cov_1.735955_g2811_i0	PRJNA1012699	2843	251	1.735955	4.35724705	Hordeum vulgare	4513	Plants	Plants	403	5.45e-108	NTclustered	gi\|326531787\|dbj\|AK366695.1\|	112509	g2811	i0	95.968	0.98804780876494	248	10	99	0	3	250	398	151	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2045N18	blastn	248	403	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
5260857	5260857	PRJNA1012699_P_NODE_1605_length_300_cov_1.951542_g1573_i0	PRJNA1012699	1605	300	1.951542	5.854626	Hordeum vulgare	4513	Plants	Plants	490	4.99e-134	NTclustered	gi\|326523806\|dbj\|AK361870.1\|	112509	g1573	i0	96.309	3.97333333333333	298	11	99	0	2	299	61	358	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2001A08	blastn	1192	490	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
5260908	5260908	PRJNA1012699_P_NODE_745_length_413_cov_1.361765_g713_i0	PRJNA1012699	745	413	1.361765	5.62408945	Oryza sativa	4530	Plants	Plants	73.1	3.05e-8	NTclustered	gi\|116638505\|emb\|CT829061.1\|	39946	g713	i0	88.525	0.351089588377724	61	6	15	1	2	61	1011	951	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA117L04, full insert sequence	blastn	145	73.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
6536190	6536190	PRJNA1012699_P_NODE_1226_length_336_cov_1.760456_g1194_i0	PRJNA1012699	1226	336	1.760456	5.91513216	Zea mays	4577	Plants	Plants	392	1.6399999999999995e-104	NTclustered	gi\|77818192\|gb\|DQ245509.1\|	4577	g1194	i0	88.545	99.5238095238095	323	37	96	0	11	333	460	782	Zea mays clone 16532 mRNA sequence	blastn	33440	392	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
6536220	6536220	PRJNA1012699_P_NODE_2966_length_250_cov_1.056497_g2934_i0	PRJNA1012699	2966	250	1.056497	2.6412425	Carica papaya	3649	Plants	Plants	71.3	6.25e-8	NTclustered	gi\|1227944680\|ref\|XM_022052643.1\|	3649	g2934	i0	78.378	0.656	111	22	44	2	117	226	3943	3834	PREDICTED: Carica papaya DNA-directed RNA polymerase II subunit 1 (LOC110822512), mRNA	blastn	164	71.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Caricaceae	Carica	Carica papaya
9085561	9085561	PRJNA1012699_P_NODE_1068_length_356_cov_1.579505_g1036_i0	PRJNA1012699	1068	356	1.579505	5.6230378	Hordeum vulgare	4513	Plants	Plants	568	2.7099999999999993e-157	NTclustered	gi\|326524258\|dbj\|AK369311.1\|	112509	g1036	i0	95.518	1.00280898876405	357	13	99	2	2	355	489	133	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2088O11	blastn	357	568	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
9085590	9085590	PRJNA1012699_P_NODE_2528_length_256_cov_2.551913_g2496_i0	PRJNA1012699	2528	256	2.551913	6.53289728	Hordeum vulgare	4513	Plants	Plants	366	7.3199999999999995e-97	NTclustered	gi\|151419171\|dbj\|AK250522.1\|	112509	g2496	i0	94.191	0.94140625	241	12	94	2	16	255	295	56	Hordeum vulgare subsp. vulgare cDNA clone: FLbaf80g03, mRNA sequence	blastn	241	366	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
9930460	9930460	PRJNA1012699_P_NODE_748_length_411_cov_12.946746_g716_i0	PRJNA1012699	748	411	12.946746	53.21112606	Magnoliopsida	3398	Plants	Plants	739	0	NTclustered	gi\|2571153582\|gb\|OR493979.1\|	46367	g716	i0	99.267	105.175182481752	409	3	99	0	2	410	5796	5388	Bupleurum falcatum voucher 2009100601 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	43227	745	0.991946308724832	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Apiales	Apiaceae	Bupleurum	Bupleurum falcatum
10361236	10361236	PRJNA1012699_P_NODE_1529_length_307_cov_2.606838_g1497_i0	PRJNA1012699	1529	307	2.606838	8.00299266	Hordeum vulgare	4513	Plants	Plants	159	1.6399999999999999e-34	NTclustered	gi\|326488240\|dbj\|AK362585.1\|	112509	g1497	i0	79.661	0.768729641693811	236	37	76	7	75	306	432	660	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2008H07	blastn	236	159	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
10361274	10361274	PRJNA1012699_P_NODE_3669_length_244_cov_1.812865_g3637_i0	PRJNA1012699	3669	244	1.812865	4.4233906	Oryza sativa	4530	Plants	Plants	381	2.4699999999999993e-101	NTclustered	gi\|32972533\|dbj\|AK062515.1\|	39947	g3637	i0	98.165	0.89344262295082	218	4	89	0	2	219	282	65	Oryza sativa Japonica Group cDNA clone:001-104-C06, full insert sequence	blastn	218	381	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
11205705	11205705	PRJNA1012699_P_NODE_3429_length_246_cov_2.427746_g3397_i0	PRJNA1012699	3429	246	2.427746	5.97225516	Triticum	4564	Plants	Plants	364	2.509999999999999e-96	NTclustered	gi\|383100758\|emb\|HE774676.1\|	4565	g3397	i0	93.574	163.272357723577	249	9	100	5	1	246	303390	303146	Triticum aestivum chromosome arm 3DS-specific BAC library, contig ctg447	blastn	40165	366	0.994535519125683	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
11636593	11636593	PRJNA1012699_P_NODE_1730_length_293_cov_2.113636_g1698_i0	PRJNA1012699	1730	293	2.113636	6.19295348	Hordeum vulgare	4513	Plants	Plants	424	4.999999999999999e-114	NTclustered	gi\|151426304\|dbj\|AK252896.1\|	112509	g1698	i0	92.808	0.996587030716723	292	21	99	0	2	293	122	413	Hordeum vulgare subsp. vulgare cDNA clone: FLbaf180j19, mRNA sequence	blastn	292	424	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
11636608	11636608	PRJNA1012699_P_NODE_2530_length_256_cov_2.519126_g2498_i0	PRJNA1012699	2530	256	2.519126	6.44896256	Oryza sativa	4530	Plants	Plants	73.1	1.79e-8	NTclustered	gi\|116640891\|emb\|CT836634.1\|	39946	g2498	i0	92.157	0.19921875	51	4	20	0	82	132	119	169	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA224L05, full insert sequence	blastn	51	73.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
12911611	12911611	PRJNA1012699_P_NODE_1791_length_291_cov_1.068807_g1759_i0	PRJNA1012699	1791	291	1.068807	3.11022837	Oryza sativa	4530	Plants	Plants	405	1.7999999999999997e-108	NTclustered	gi\|32971027\|dbj\|AK061009.1\|	39947	g1759	i0	99.111	48.7628865979381	225	2	77	0	2	226	1185	1409	Oryza sativa Japonica Group cDNA clone:006-204-A10, full insert sequence	blastn	14190	405	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
12911639	12911639	PRJNA1012699_P_NODE_3571_length_245_cov_0.906977_g3539_i0	PRJNA1012699	3571	245	0.906977	2.22209365	Zea mays	4577	Plants	Plants	176	1.26e-39	NTclustered	gi\|195624561\|gb\|EU961993.1\|	4577	g3539	i0	81.818	36.6571428571429	220	31	88	8	2	217	404	190	Zea mays clone 239517 histone H2A variant 1 mRNA, complete cds	blastn	8981	176	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
12911651	12911651	PRJNA1012699_P_NODE_71_length_1191_cov_4.163685_g51_i0	PRJNA1012699	71	1191	4.163685	49.58948835	Hordeum vulgare	4513	Plants	Plants	1725	0	NTclustered	gi\|151419311\|dbj\|AK250662.1\|	112509	g51	i0	92.821	60.4492023509656	1198	75	99	5	1	1189	255	1450	Hordeum vulgare subsp. vulgare cDNA clone: FLbaf93b09, mRNA sequence	blastn	71995	1725	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
14186631	14186631	PRJNA1012699_P_NODE_232_length_679_cov_3.810231_g204_i0	PRJNA1012699	232	679	3.810231	25.87146849	Hordeum vulgare	4513	Plants	Plants	933	0	NTclustered	gi\|326496930\|dbj\|AK367289.1\|	112509	g204	i0	91.964	60.2459499263623	672	45	99	8	2	670	497	1162	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2054B13	blastn	40907	933	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
15460664	15460664	PRJNA1012699_P_NODE_2293_length_266_cov_2.471503_g2261_i0	PRJNA1012699	2293	266	2.471503	6.57419798	Lactuca sativa	4236	Plants	Plants	117	8.5e-22	NTclustered	gi\|2416544786\|ref\|XM_023881849.3\|	4236	g2261	i0	81.633	9.53383458646617	147	21	54	6	3	146	641	784	PREDICTED: Lactuca sativa 40S ribosomal protein S2-4 (LOC111885603), mRNA	blastn	2536	117	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Lactuca	Lactuca sativa
18009872	18009872	PRJNA1012699_P_NODE_3895_length_243_cov_0.917647_g3863_i0	PRJNA1012699	3895	243	0.917647	2.22988221	Brassica rapa	3711	Plants	Plants	161	3.4899999999999997e-35	NTclustered	gi\|1516541655\|emb\|LR031577.1\|	3711	g3863	i0	81.313	70.1399176954732	198	37	81	0	30	227	13958645	13958842	Brassica rapa genome, scaffold: A10	blastn	17044	161	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica rapa
19283642	19283642	PRJNA1012699_P_NODE_2376_length_262_cov_4.037037_g2344_i0	PRJNA1012699	2376	262	4.037037	10.57703694	Triticum aestivum	4565	Plants	Plants	58.4	5.14e-4	NTclustered	gi\|2123588891\|ref\|XR_006435912.1\|	4565	g2344	i0	100	0.232824427480916	31	0	12	0	2	32	3112	3142	PREDICTED: Triticum aestivum 28S ribosomal RNA (LOC123074255), rRNA	blastn	61	58.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
19283653	19283653	PRJNA1012699_P_NODE_2836_length_251_cov_2.488764_g2804_i0	PRJNA1012699	2836	251	2.488764	6.24679764	Oryza sativa	4530	Plants	Plants	322	1.57e-83	NTclustered	gi\|116641722\|emb\|CT837061.1\|	39946	g2804	i0	90.079	1.2390438247012	252	19	99	5	2	250	422	174	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA106D15, full insert sequence	blastn	311	322	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
20559161	20559161	PRJNA1012699_P_NODE_1277_length_330_cov_1.638132_g1245_i0	PRJNA1012699	1277	330	1.638132	5.4058356	Hordeum vulgare	4513	Plants	Plants	387	7.5e-103	NTclustered	gi\|326512517\|dbj\|AK368411.1\|	112509	g1245	i0	88.182	1	330	31	99	4	1	329	159	481	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2073D20	blastn	330	387	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
20559169	20559169	PRJNA1012699_P_NODE_157_length_816_cov_45.391655_g130_i0	PRJNA1012699	157	816	45.391655	370.3959048	Hordeum vulgare	4513	Plants	Plants	538	5.159999999999999e-148	NTclustered	gi\|326496930\|dbj\|AK367289.1\|	112509	g130	i0	84.386	50.4914215686275	570	65	68	20	228	784	553	1111	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2054B13	blastn	41201	538	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
20559179	20559179	PRJNA1012699_P_NODE_197_length_713_cov_2.132812_g170_i0	PRJNA1012699	197	713	2.132812	15.20694956	Hordeum vulgare	4513	Plants	Plants	987	0	NTclustered	gi\|151420084\|dbj\|AK251436.1\|	112509	g170	i0	91.737	2.00280504908836	714	53	99	5	2	712	792	82	Hordeum vulgare subsp. vulgare cDNA clone: FLbaf117d02, mRNA sequence	blastn	1428	987	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
20559217	20559217	PRJNA1012699_P_NODE_3517_length_246_cov_0.901734_g3485_i0	PRJNA1012699	3517	246	0.901734	2.21826564	Lotus japonicus	34305	Plants	Plants	298	2.5799999999999998e-76	NTclustered	gi\|388496171\|gb\|BT136357.1\|	34305	g3485	i0	88.571	0.995934959349594	245	28	99	0	1	245	583	339	Lotus japonicus clone JCVI-FLLj-1E11 unknown mRNA	blastn	245	298	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
21834835	21834835	PRJNA1012699_P_NODE_1778_length_291_cov_1.885321_g1746_i0	PRJNA1012699	1778	291	1.885321	5.48628411	Oryza sativa	4530	Plants	Plants	250	8.909999999999999e-62	NTclustered	gi\|116638505\|emb\|CT829061.1\|	39946	g1746	i0	82.857	0.962199312714777	280	46	96	2	1	279	532	810	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA117L04, full insert sequence	blastn	280	250	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
21834838	21834838	PRJNA1012699_P_NODE_1878_length_285_cov_2.386792_g1846_i0	PRJNA1012699	1878	285	2.386792	6.8023572	Helianthus annuus x Helianthus debilis subsp. debilis	193314	Plants	Plants	459	1.3299999999999996e-124	NTclustered	gi\|59380439\|gb\|AY899919.1\|	193314	g1846	i0	97.736	0.929824561403509	265	6	93	0	21	285	411	147	Helianthus annuus x Helianthus debilis subsp. debilis quinone-oxidoreductase mRNA, partial cds	blastn	265	459	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Helianthus	Helianthus annuus x Helianthus debilis subsp. debilis
23110314	23110314	PRJNA1012699_P_NODE_2319_length_265_cov_1.619792_g2287_i0	PRJNA1012699	2319	265	1.619792	4.2924488	Hordeum vulgare	4513	Plants	Plants	385	2.0999999999999996e-102	NTclustered	gi\|326505149\|dbj\|AK371764.1\|	112509	g2287	i0	93.13	89.3245283018868	262	18	99	0	4	265	1061	800	Hordeum vulgare subsp. vulgare mRNA for predicted protein, partial cds, clone: NIASHv2141B17	blastn	23671	385	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
23110325	23110325	PRJNA1012699_P_NODE_2979_length_250_cov_0.881356_g2947_i0	PRJNA1012699	2979	250	0.881356	2.20339	Zea mays	4577	Plants	Plants	52.8	0.023	NTclustered	gi\|77818097\|gb\|DQ245414.1\|	4577	g2947	i0	100	0.112	28	0	11	0	190	217	260	287	Zea mays clone 15325 mRNA sequence	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
24384091	24384091	PRJNA1012699_P_NODE_1320_length_326_cov_2.446640_g1288_i0	PRJNA1012699	1320	326	2.44664	7.9760464	Eutrema salsugineum	72664	Plants	Plants	150	1.0599999999999998e-31	NTclustered	gi\|1350301903\|ref\|XM_006418857.2\|	72664	g1288	i0	84.076	9.09509202453988	157	23	48	2	1	156	215	370	PREDICTED: Eutrema salsugineum histone H4 (LOC18014079), mRNA	blastn	2965	150	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Eutrema	Eutrema salsugineum

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