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

31 rows where analysis = "blastn", bioproject = "PRJNA1082072" 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
193177	193177	PRJNA1082072_P_NODE_1581_length_281_cov_1.480769_g1574_i0	PRJNA1082072	1581	281	1.480769	4.16096089	Hordeum vulgare	4513	Plants	Plants	470	6.04e-128	NTclustered	gi\|326517161\|dbj\|AK368744.1\|	112509	g1574	i0	96.797	1	281	9	100	0	1	281	700	980	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2078P18	blastn	281	470	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
193189	193189	PRJNA1082072_P_NODE_261_length_588_cov_1.640777_g254_i0	PRJNA1082072	261	588	1.640777	9.64776876	Hordeum vulgare	4513	Plants	Plants	931	0	NTclustered	gi\|326507517\|dbj\|AK371954.1\|	112509	g254	i0	95.238	66.2295918367347	588	28	100	0	1	588	47	634	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2143N22	blastn	38943	931	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
2292524	2292524	PRJNA1082072_P_NODE_482_length_446_cov_1.238606_g475_i0	PRJNA1082072	482	446	1.238606	5.52418276	Eukaryota	2759	Plants	Plants	529	1.64e-145	NTclustered	gi\|326529132\|dbj\|AK369759.1\|	112509	g475	i0	89.976	101.363228699552	409	41	92	0	37	445	1169	761	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2097H01	blastn	45208	529	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
2743899	2743899	PRJNA1082072_P_NODE_183_length_681_cov_2.100329_g176_i0	PRJNA1082072	183	681	2.100329	14.30324049	Hordeum vulgare	4513	Plants	Plants	1258	0	NTclustered	gi\|326498642\|dbj\|AK371109.1\|	112509	g176	i0	100	1.96182085168869	681	0	100	0	1	681	718	38	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2125H04	blastn	1336	1258	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
2743901	2743901	PRJNA1082072_P_NODE_1943_length_259_cov_1.241935_g1936_i0	PRJNA1082072	1943	259	1.241935	3.21661165	Hordeum vulgare	4513	Plants	Plants	289	1.65e-73	NTclustered	gi\|326498374\|dbj\|AK367412.1\|	112509	g1936	i0	87.302	0.972972972972973	252	32	97	0	3	254	959	708	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2056L03	blastn	252	289	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
2743904	2743904	PRJNA1082072_P_NODE_2663_length_245_cov_0.895349_g2656_i0	PRJNA1082072	2663	245	0.895349	2.19360505	Oryza sativa	4530	Plants	Plants	405	1.47e-108	NTclustered	gi\|116642053\|emb\|CT837391.1\|	39946	g2656	i0	97.863	0.955102040816327	234	5	96	0	1	234	25	258	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA102K19, full insert sequence	blastn	234	405	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
4019741	4019741	PRJNA1082072_P_NODE_124_length_837_cov_2.952880_g120_i0	PRJNA1082072	124	837	2.95288	24.7156056	Nymphaea colorata	210225	Plants	Plants	715	0	NTclustered	gi\|1750920132\|emb\|LR722063.1\|	210225	g120	i0	82.206	2.01433691756272	843	138	100	9	1	837	16528	17364	XXX	blastn	1686	715	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
4019748	4019748	PRJNA1082072_P_NODE_1964_length_257_cov_1.255435_g1957_i0	PRJNA1082072	1964	257	1.255435	3.22646795	Hordeum vulgare	4513	Plants	Plants	475	1.1699999999999999e-129	NTclustered	gi\|326496792\|dbj\|AK367220.1\|	112509	g1957	i0	100	2	257	0	100	0	1	257	2056	1800	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2053C04	blastn	514	475	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
5295971	5295971	PRJNA1082072_P_NODE_1765_length_271_cov_1.555556_g1758_i0	PRJNA1082072	1765	271	1.555556	4.21555676	Oryza sativa	4530	Plants	Plants	468	2.08e-127	NTclustered	gi\|116640859\|emb\|CT836602.1\|	39946	g1758	i0	97.786	1	271	6	100	0	1	271	871	1141	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA113N23, full insert sequence	blastn	271	468	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
5295980	5295980	PRJNA1082072_P_NODE_885_length_356_cov_1.074205_g878_i0	PRJNA1082072	885	356	1.074205	3.8241698	Hordeum vulgare	4513	Plants	Plants	608	1.589999999999999e-169	NTclustered	gi\|326517161\|dbj\|AK368744.1\|	112509	g878	i0	97.472	1	356	9	100	0	1	356	326	681	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2078P18	blastn	356	608	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
6571084	6571084	PRJNA1082072_P_NODE_1886_length_263_cov_1.584211_g1879_i0	PRJNA1082072	1886	263	1.584211	4.16647493	Hordeum vulgare	4513	Plants	Plants	486	5.5499999999999986e-133	NTclustered	gi\|326489008\|dbj\|AK366913.1\|	112509	g1879	i0	100	1	263	0	100	0	1	263	1047	785	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2048D04	blastn	263	486	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
9120807	9120807	PRJNA1082072_P_NODE_2868_length_242_cov_0.911243_g2861_i0	PRJNA1082072	2868	242	0.911243	2.20520806	Oryza sativa	4530	Plants	Plants	261	3.33e-65	NTclustered	gi\|116640607\|emb\|CT836548.1\|	39946	g2861	i0	90.05	195.376033057851	201	20	83	0	41	241	462	262	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA126A09, full insert sequence	blastn	47281	261	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
9120811	9120811	PRJNA1082072_P_NODE_508_length_436_cov_1.272727_g501_i0	PRJNA1082072	508	436	1.272727	5.54908972	Hordeum vulgare	4513	Plants	Plants	784	0	NTclustered	gi\|326489008\|dbj\|AK366913.1\|	112509	g501	i0	99.083	1	436	4	100	0	1	436	783	348	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2048D04	blastn	436	784	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
11671864	11671864	PRJNA1082072_P_NODE_1070_length_333_cov_1.776923_g1063_i0	PRJNA1082072	1070	333	1.776923	5.91715359	Hordeum vulgare	4513	Plants	Plants	616	8.87e-172	NTclustered	gi\|326517313\|dbj\|AK368820.1\|	112509	g1063	i0	100	1	333	0	100	0	1	333	958	626	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2080I07	blastn	333	616	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
11671868	11671868	PRJNA1082072_P_NODE_2030_length_252_cov_1.290503_g2023_i0	PRJNA1082072	2030	252	1.290503	3.25206756	Hordeum vulgare	4513	Plants	Plants	460	3.2e-125	NTclustered	gi\|326524615\|dbj\|AK369490.1\|	112509	g2023	i0	99.603	1	252	1	100	0	1	252	1812	2063	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2092G08	blastn	252	460	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
12946910	12946910	PRJNA1082072_P_NODE_1111_length_327_cov_1.515748_g1104_i0	PRJNA1082072	1111	327	1.515748	4.95649596	Oryza sativa	4530	Plants	Plants	577	4.099999999999999e-160	NTclustered	gi\|116640859\|emb\|CT836602.1\|	39946	g1104	i0	98.471	1	327	5	100	0	1	327	346	20	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA113N23, full insert sequence	blastn	327	577	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
12946920	12946920	PRJNA1082072_P_NODE_51_length_1180_cov_4.966576_g48_i0	PRJNA1082072	51	1180	4.966576	58.6055968	Oryza sativa	4530	Plants	Plants	867	0	NTclustered	gi\|32993583\|dbj\|AK108374.1\|	39947	g48	i0	90.98	55.4822033898305	643	58	54	0	1	643	656	14	Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence	blastn	65469	867	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
14221931	14221931	PRJNA1082072_P_NODE_2792_length_243_cov_0.905882_g2785_i0	PRJNA1082072	2792	243	0.905882	2.20129326	Hordeum vulgare	4513	Plants	Plants	388	1.47e-103	NTclustered	gi\|326498818\|dbj\|AK371197.1\|	112509	g2785	i0	95.473	1	243	11	100	0	1	243	1258	1016	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2127O20	blastn	243	388	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
15495829	15495829	PRJNA1082072_P_NODE_693_length_387_cov_1.732484_g686_i0	PRJNA1082072	693	387	1.732484	6.70471308	Oryza sativa	4530	Plants	Plants	549	1.0799999999999997e-151	NTclustered	gi\|32993583\|dbj\|AK108374.1\|	39947	g686	i0	94.429	58.8217054263566	359	16	92	3	31	387	838	482	Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence	blastn	22764	549	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
16770149	16770149	PRJNA1082072_P_NODE_1474_length_287_cov_1.901869_g1467_i0	PRJNA1082072	1474	287	1.901869	5.45836403	Hordeum vulgare	4513	Plants	Plants	497	2.84e-136	NTclustered	gi\|326517155\|dbj\|AK368741.1\|	112509	g1467	i0	97.909	2.98954703832753	287	6	100	0	1	287	412	698	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2078P10	blastn	858	497	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
19318929	19318929	PRJNA1082072_P_NODE_616_length_401_cov_3.103659_g609_i0	PRJNA1082072	616	401	3.103659	12.44567259	Oryza sativa	4530	Plants	Plants	300	1.24e-76	NTclustered	gi\|116635679\|emb\|CT834279.1\|	39946	g609	i0	83.385	0.810473815461347	325	52	81	2	77	400	421	744	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA113F11, full insert sequence	blastn	325	300	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
19318930	19318930	PRJNA1082072_P_NODE_796_length_370_cov_1.814815_g789_i0	PRJNA1082072	796	370	1.814815	6.7148155	Hordeum vulgare	4513	Plants	Plants	684	0	NTclustered	gi\|326498642\|dbj\|AK371109.1\|	112509	g789	i0	100	2	370	0	100	0	1	370	811	1180	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2125H04	blastn	740	684	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
20594222	20594222	PRJNA1082072_P_NODE_1937_length_259_cov_1.543011_g1930_i0	PRJNA1082072	1937	259	1.543011	3.99639849	Oryza sativa	4530	Plants	Plants	468	1.98e-127	NTclustered	gi\|116633454\|emb\|CT833258.1\|	39946	g1930	i0	99.228	1.27799227799228	259	2	100	0	1	259	407	665	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA202E04, full insert sequence	blastn	331	468	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
20594230	20594230	PRJNA1082072_P_NODE_377_length_493_cov_1.000000_g370_i0	PRJNA1082072	377	493	1	4.93	Oryza sativa	4530	Plants	Plants	449	1.4599999999999998e-121	NTclustered	gi\|116642017\|emb\|CT837355.1\|	39946	g370	i0	83.402	1.77079107505071	488	77	100	4	1	486	728	243	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA115D19, full insert sequence	blastn	873	449	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
20594232	20594232	PRJNA1082072_P_NODE_537_length_427_cov_1.305085_g530_i0	PRJNA1082072	537	427	1.305085	5.57271295	Oryza sativa	4530	Plants	Plants	662	0	NTclustered	gi\|116641691\|emb\|CT837030.1\|	39946	g530	i0	94.626	1.15222482435597	428	21	100	2	1	427	461	35	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCPI012C10, full insert sequence	blastn	492	662	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
20594233	20594233	PRJNA1082072_P_NODE_57_length_1126_cov_1.764482_g54_i0	PRJNA1082072	57	1126	1.764482	19.86806732	Oryza sativa	4530	Plants	Plants	942	0	NTclustered	gi\|116641411\|emb\|CT836953.1\|	39946	g54	i0	82.849	40.9147424511545	1067	167	94	15	56	1114	1170	112	Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA114K09, full insert sequence	blastn	46070	942	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
21870006	21870006	PRJNA1082072_P_NODE_2718_length_244_cov_0.900585_g2711_i0	PRJNA1082072	2718	244	0.900585	2.1974274	Hordeum vulgare	4513	Plants	Plants	412	8.759999999999998e-111	NTclustered	gi\|326517361\|dbj\|AK368844.1\|	112509	g2711	i0	97.131	1	244	7	100	0	1	244	1565	1322	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2080O21	blastn	244	412	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
23145373	23145373	PRJNA1082072_P_NODE_519_length_433_cov_0.855556_g512_i0	PRJNA1082072	519	433	0.855556	3.70455748	Hordeum vulgare	4513	Plants	Plants	800	0	NTclustered	gi\|326500767\|dbj\|AK363847.1\|	112509	g512	i0	100	2.03926096997691	433	0	100	0	1	433	1176	1608	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2019G14	blastn	883	800	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
23145375	23145375	PRJNA1082072_P_NODE_719_length_382_cov_0.996764_g712_i0	PRJNA1082072	719	382	0.996764	3.80763848	Lotus japonicus	34305	Plants	Plants	119	3.54e-22	NTclustered	gi\|388500897\|gb\|BT138720.1\|	34305	g712	i0	77.612	25.6753926701571	201	42	52	3	159	357	250	51	Lotus japonicus clone JCVI-FLLj-13G3 unknown mRNA	blastn	9808	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
24419048	24419048	PRJNA1082072_P_NODE_2280_length_249_cov_0.875000_g2273_i0	PRJNA1082072	2280	249	0.875	2.17875	Hordeum vulgare	4513	Plants	Plants	405	1.5e-108	NTclustered	gi\|326498818\|dbj\|AK371197.1\|	112509	g2273	i0	96.341	0.987951807228916	246	9	99	0	1	246	157	402	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2127O20	blastn	246	405	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
24419055	24419055	PRJNA1082072_P_NODE_760_length_376_cov_1.369637_g753_i0	PRJNA1082072	760	376	1.369637	5.14983512	Hordeum vulgare	4513	Plants	Plants	501	2.96e-137	NTclustered	gi\|326498374\|dbj\|AK367412.1\|	112509	g753	i0	90.691	1	376	35	100	0	1	376	2578	2953	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2056L03	blastn	376	501	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare

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