metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA1132896" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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
1558203	1558203	PRJNA1132896_P_NODE_3102_length_318_cov_1.126531_g3011_i0	PRJNA1132896	3102	318	1.126531	3.58236858	Linum usitatissimum	4006	Plants	Plants	516	8.79e-142	NTclustered	gi\|192336980\|gb\|EU830593.1\|	4006	g3011	i0	100	15.5660377358491	279	0	88	0	40	318	401	679	Linum usitatissimum clone LU0026D12 mRNA sequence	blastn	4950	516	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Linaceae	Linum	Linum usitatissimum
2834273	2834273	PRJNA1132896_P_NODE_3363_length_308_cov_1.310638_g3272_i0	PRJNA1132896	3363	308	1.310638	4.03676504	Oryza sativa	4530	Plants	Plants	148	3.56e-31	NTclustered	gi\|347659529\|gb\|BT129881.1\|	39947	g3272	i0	83.23	0.522727272727273	161	27	52	0	104	264	212	52	Oryza sativa clone RRlibD00421 mRNA sequence	blastn	161	148	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
4859800	4859800	PRJNA1132896_P_NODE_2344_length_357_cov_1.897887_g2253_i0	PRJNA1132896	2344	357	1.897887	6.77545659	Ipomoea	4119	Plants	Plants	254	8.63e-63	NTclustered	gi\|1109244018\|ref\|XM_019341199.1\|	35883	g2253	i0	80.357	29.0196078431373	336	64	94	2	7	341	1325	991	PREDICTED: Ipomoea nil heat shock cognate protein 80-like (LOC109190650), mRNA	blastn	10360	254	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Convolvulaceae	Ipomoea	Ipomoea nil
4859801	4859801	PRJNA1132896_P_NODE_2584_length_343_cov_2.307407_g2493_i0	PRJNA1132896	2584	343	2.307407	7.91440601	Eukaryota	2759	Plants	Plants	503	7.449999999999998e-138	NTclustered	gi\|150172490\|emb\|CU406894.1\|	4529	g2493	i0	93.294	4.97376093294461	343	19	99	3	1	341	361	21	Oryza rufipogon (W1943) cDNA clone: ORW1943C111D01, full insert sequence	blastn	1706	508	0.990157480314961	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza rufipogon
4859809	4859809	PRJNA1132896_P_NODE_5404_length_269_cov_1.178571_g5313_i0	PRJNA1132896	5404	269	1.178571	3.17035599	Eukaryota	2759	Plants	Plants	470	5.74e-128	NTclustered	gi\|150172490\|emb\|CU406894.1\|	4529	g5313	i0	98.141	4.87732342007435	269	5	100	0	1	269	782	514	Oryza rufipogon (W1943) cDNA clone: ORW1943C111D01, full insert sequence	blastn	1312	470	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza rufipogon
5386832	5386832	PRJNA1132896_P_NODE_4605_length_280_cov_2.130435_g4514_i0	PRJNA1132896	4605	280	2.130435	5.965218	Oryza sativa	4530	Plants	Plants	477	3.5899999999999985e-130	NTclustered	gi\|32973086\|dbj\|AK063068.1\|	39947	g4514	i0	97.491	5.57857142857143	279	7	99	0	2	280	558	280	Oryza sativa Japonica Group cDNA clone:001-110-G10, full insert sequence	blastn	1562	477	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
5386879	5386879	PRJNA1132896_P_NODE_8865_length_245_cov_0.895349_g8774_i0	PRJNA1132896	8865	245	0.895349	2.19360505	Vitis vinifera	29760	Plants	Plants	52.8	0.022	NTclustered	gi\|123687690\|emb\|AM431248.1\|	29760	g8774	i0	100	0.114285714285714	28	0	11	0	1	28	3590	3617	Vitis vinifera, whole genome shotgun sequence, contig VV78X143067.9, clone ENTAV 115	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
6134616	6134616	PRJNA1132896_P_NODE_9225_length_244_cov_0.900585_g9134_i0	PRJNA1132896	9225	244	0.900585	2.1974274	Citrus	2706	Plants	Plants	448	2.4e-121	NTclustered	gi\|2395896056\|ref\|XM_006492601.4\|	2711	g9134	i0	100	28.4016393442623	242	0	99	0	3	244	5748	5507	PREDICTED: Citrus sinensis callose synthase 3 (LOC102611841), mRNA	blastn	6930	448	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus sinensis
6661542	6661542	PRJNA1132896_P_NODE_8746_length_245_cov_0.895349_g8655_i0	PRJNA1132896	8746	245	0.895349	2.19360505	Malus domestica	3750	Plants	Plants	283	7.2e-72	NTclustered	gi\|2810943379\|gb\|CP168777.1\|	3750	g8655	i0	87.755	288.044897959184	245	27	100	3	1	245	24186497	24186738	Malus domestica cultivar Golden Delicious chromosome 13	blastn	70571	283	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Malus	Malus domestica
7409671	7409671	PRJNA1132896_P_NODE_3946_length_289_cov_2.138889_g3855_i0	PRJNA1132896	3946	289	2.138889	6.18138921	Eukaryota	2759	Plants	Plants	534	2.18e-147	NTclustered	gi\|270135136\|gb\|BT102088.1\|	3330	g3855	i0	100	13.9653979238754	289	0	100	0	1	289	666	378	Picea glauca clone GQ0166_A15 mRNA sequence	blastn	4036	534	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea glauca
7409700	7409700	PRJNA1132896_P_NODE_9626_length_243_cov_0.905882_g9535_i0	PRJNA1132896	9626	243	0.905882	2.20129326	Magnoliopsida	3398	Plants	Plants	171	5.8e-38	NTclustered	gi\|2293046643\|ref\|XM_050429964.1\|	38942	g9535	i0	91.803	40.7818930041152	122	10	50	0	3	124	322	443	PREDICTED: Quercus robur T-complex protein 1 subunit eta (LOC126725319), mRNA	blastn	9910	172	0.994186046511628	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus robur
7936614	7936614	PRJNA1132896_P_NODE_1147_length_485_cov_1.121359_g1056_i0	PRJNA1132896	1147	485	1.121359	5.43859115	Picea glauca	3330	Plants	Plants	316	1.5199999999999996e-81	NTclustered	gi\|270135130\|gb\|BT102082.1\|	3330	g1056	i0	90.456	0.783505154639175	241	21	50	2	79	319	871	1109	Picea glauca clone GQ0165_O16 mRNA sequence	blastn	380	316	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea glauca
7936642	7936642	PRJNA1132896_P_NODE_4047_length_288_cov_1.451163_g3956_i0	PRJNA1132896	4047	288	1.451163	4.17934944	Oryza sativa	4530	Plants	Plants	532	7.8e-147	NTclustered	gi\|32971027\|dbj\|AK061009.1\|	39947	g3956	i0	100	114.871527777778	288	0	100	0	1	288	741	454	Oryza sativa Japonica Group cDNA clone:006-204-A10, full insert sequence	blastn	33083	532	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
7936679	7936679	PRJNA1132896_P_NODE_6887_length_251_cov_0.865169_g6796_i0	PRJNA1132896	6887	251	0.865169	2.17157419	Triticum aestivum	4565	Plants	Plants	113	1.03e-20	NTclustered	gi\|1251766431\|dbj\|AK448060.1\|	4565	g6796	i0	100	0.243027888446215	61	0	24	0	1	61	3399	3459	Triticum aestivum mRNA, clone: tplb0046d08, cultivar Chinese Spring	blastn	61	113	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
9211630	9211630	PRJNA1132896_P_NODE_5088_length_273_cov_2.040000_g4997_i0	PRJNA1132896	5088	273	2.04	5.5692	Magnolia sinica	86752	Plants	Plants	359	1.32e-94	NTclustered	gi\|2548509932\|ref\|XM_058255243.1\|	86752	g4997	i0	90.441	81.6959706959707	272	26	99	0	2	273	485	214	PREDICTED: Magnolia sinica small ribosomal subunit protein uS13z/uS13y/uS13x-like (LOC131254249), mRNA	blastn	22303	359	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Magnoliales	Magnoliaceae	Magnolia	Magnolia sinica
9959916	9959916	PRJNA1132896_P_NODE_9408_length_243_cov_1.470588_g9317_i0	PRJNA1132896	9408	243	1.470588	3.57352884	Solanum	4107	Plants	Plants	243	1.2100000000000004e-59	NTclustered	gi\|565404840\|ref\|XM_006367770.1\|	4113	g9317	i0	85.652	24.7818930041152	230	33	95	0	1	230	2442	2671	PREDICTED: Solanum tuberosum ATP-dependent Clp protease ATP-binding subunit ClpA homolog CD4A, chloroplastic-like (LOC102594555), mRNA	blastn	6022	243	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum tuberosum
10487172	10487172	PRJNA1132896_P_NODE_7129_length_250_cov_0.870056_g7038_i0	PRJNA1132896	7129	250	0.870056	2.17514	Sesuvium portulacastrum	221166	Plants	Plants	272	1.6e-68	NTclustered	gi\|1117535714\|gb\|KY056737.1\|	221166	g7038	i0	93.443	72.588	183	12	100	0	68	250	764	946	Sesuvium portulacastrum actin 11 mRNA, complete cds	blastn	18147	272	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Aizoaceae	Sesuvium	Sesuvium portulacastrum
11762214	11762214	PRJNA1132896_P_NODE_2370_length_356_cov_1.088339_g2279_i0	PRJNA1132896	2370	356	1.088339	3.87448684	Lotus japonicus	34305	Plants	Plants	196	1.47e-45	NTclustered	gi\|388505135\|gb\|BT140839.1\|	34305	g2279	i0	77.941	31.7584269662921	340	57	92	16	20	345	385	50	Lotus japonicus clone JCVI-FLLj-20I13 unknown mRNA	blastn	11306	196	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
13037331	13037331	PRJNA1132896_P_NODE_4131_length_287_cov_1.406542_g4040_i0	PRJNA1132896	4131	287	1.406542	4.03677554	Morus notabilis	981085	Plants	Plants	305	1.84e-78	NTclustered	gi\|1350261860\|ref\|XM_010101443.2\|	981085	g4040	i0	85.965	0.993031358885017	285	40	99	0	3	287	3090	3374	PREDICTED: Morus notabilis uncharacterized LOC21407887 (LOC21407887), mRNA	blastn	285	305	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Morus	Morus notabilis
13785108	13785108	PRJNA1132896_P_NODE_6011_length_261_cov_1.101064_g5920_i0	PRJNA1132896	6011	261	1.101064	2.87377704	Oryza	4527	Plants	Plants	481	2.56e-131	NTclustered	gi\|2348116236\|ref\|XM_052284325.1\|	4538	g5920	i0	100	15	260	0	99	0	1	260	1685	1944	PREDICTED: Oryza glaberrima plastidic glucose transporter 4 (LOC127760113), transcript variant X1, mRNA	blastn	3915	481	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza glaberrima
14312527	14312527	PRJNA1132896_P_NODE_10572_length_231_cov_2.867089_g10481_i0	PRJNA1132896	10572	231	2.867089	6.62297559	Juglans microcarpa x Juglans regia	2249226	Plants	Plants	62.1	3.43e-5	NTclustered	gi\|2031547103\|ref\|XM_041143653.1\|	2249226	g10481	i0	97.222	1.80519480519481	36	1	16	0	93	128	1333	1368	PREDICTED: Juglans microcarpa x Juglans regia zinc finger protein GAI-ASSOCIATED FACTOR 1-like (LOC121245788), mRNA	blastn	417	62.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Juglandaceae	Juglans	Juglans microcarpa x Juglans regia
14312531	14312531	PRJNA1132896_P_NODE_1552_length_426_cov_1.436261_g1461_i0	PRJNA1132896	1552	426	1.436261	6.11847186	Cajanus cajan	3821	Plants	Plants	171	1.0899999999999998e-37	NTclustered	gi\|1662934709\|ref\|XM_020378064.2\|	3821	g1461	i0	77.451	57.1596244131455	306	56	70	12	104	401	818	1118	PREDICTED: Cajanus cajan ADP,ATP carrier protein 1, mitochondrial (LOC109813805), mRNA	blastn	24350	171	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Cajanus	Cajanus cajan
14312537	14312537	PRJNA1132896_P_NODE_2792_length_332_cov_1.868726_g2701_i0	PRJNA1132896	2792	332	1.868726	6.20417032	Hordeum vulgare	4513	Plants	Plants	289	2.19e-73	NTclustered	gi\|326497336\|dbj\|AK371055.1\|	112509	g2701	i0	82.831	92.0301204819277	332	47	98	7	3	329	176	502	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2123K09	blastn	30554	289	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
15059462	15059462	PRJNA1132896_P_NODE_3932_length_290_cov_1.133641_g3841_i0	PRJNA1132896	3932	290	1.133641	3.2875589	Eukaryota	2759	Plants	Plants	52.8	0.027	NTclustered	gi\|1666263421\|ref\|XM_025846948.2\|	3818	g3841	i0	100	0.386206896551724	28	0	10	0	64	91	896	923	PREDICTED: Arachis hypogaea F-box/LRR-repeat protein At3g59190 (LOC112803452), mRNA	blastn	112	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Arachis	Arachis hypogaea
17609438	17609438	PRJNA1132896_P_NODE_6894_length_251_cov_0.865169_g6803_i0	PRJNA1132896	6894	251	0.865169	2.17157419	Citrus	2706	Plants	Plants	460	3.1899999999999997e-125	NTclustered	gi\|2395976008\|ref\|XM_052443389.1\|	2711	g6803	i0	100	25.00796812749	249	0	99	0	3	251	666	418	PREDICTED: Citrus sinensis uncharacterized LOC102615044 (LOC102615044), transcript variant X3, mRNA	blastn	6277	460	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus sinensis
19409540	19409540	PRJNA1132896_P_NODE_6416_length_255_cov_1.423077_g6325_i0	PRJNA1132896	6416	255	1.423077	3.62884635	Triticum aestivum	4565	Plants	Plants	56.5	0.002	NTclustered	gi\|2123902513\|ref\|XM_044554488.1\|	4565	g6325	i0	96.97	0.129411764705882	33	1	13	0	48	80	124	156	PREDICTED: Triticum aestivum uncharacterized LOC123135419 (LOC123135419), mRNA	blastn	33	56.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
21433654	21433654	PRJNA1132896_P_NODE_3317_length_310_cov_1.299578_g3226_i0	PRJNA1132896	3317	310	1.299578	4.0286918	Eukaryota	2759	Plants	Plants	427	4.12e-115	NTclustered	gi\|241984942\|dbj\|AK332202.1\|	4565	g3226	i0	100	75.4935483870968	231	0	84	0	80	310	650	420	Triticum aestivum cDNA, clone: SET1_M06, cultivar: Chinese Spring	blastn	23403	427	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
23235929	23235929	PRJNA1132896_P_NODE_3979_length_289_cov_1.402778_g3888_i0	PRJNA1132896	3979	289	1.402778	4.05402842	Platanus orientalis	122832	Plants	Plants	518	2.19e-142	NTclustered	gi\|162949337\|gb\|EU296477.1\|	122832	g3888	i0	98.962	2.93771626297578	289	3	100	0	1	289	360	648	Platanus orientalis pollen allergen Pla o 2 mRNA, complete cds	blastn	849	518	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Proteales	Platanaceae	Platanus	Platanus orientalis
23235936	23235936	PRJNA1132896_P_NODE_4879_length_277_cov_0.970588_g4788_i0	PRJNA1132896	4879	277	0.970588	2.68852876	Oryza sativa	4530	Plants	Plants	459	1.29e-124	NTclustered	gi\|32990362\|dbj\|AK105153.1\|	39947	g4788	i0	96.763	1.00361010830325	278	4	100	4	1	277	320	47	Oryza sativa Japonica Group cDNA clone:001-103-F03, full insert sequence	blastn	278	459	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
24509550	24509550	PRJNA1132896_P_NODE_2140_length_370_cov_3.771044_g2049_i0	PRJNA1132896	2140	370	3.771044	13.9528628	Lotus japonicus	34305	Plants	Plants	215	4.24e-51	NTclustered	gi\|388505135\|gb\|BT140839.1\|	34305	g2049	i0	87.568	43.4675675675676	185	23	50	0	8	192	32	216	Lotus japonicus clone JCVI-FLLj-20I13 unknown mRNA	blastn	16083	215	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
25258066	25258066	PRJNA1132896_P_NODE_1180_length_478_cov_18.177778_g1089_i0	PRJNA1132896	1180	478	18.177778	86.88977884	Streptophyta	35493	Plants	Plants	119	4.52e-22	NTclustered	gi\|8099444\|gb\|AF226036.1\|	3234	g1089	i0	85.124	18.5439330543933	121	12	25	5	43	162	379	264	Anthoceros punctatus 26S ribosomal RNA gene, partial sequence	blastn	8864	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Anthocerotopsida	Anthocerotales	Anthocerotaceae	Anthoceros	Anthoceros punctatus

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