metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax_clade = "Embryophyta"

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
1236865	1236865	PRJNA864829_S_NODE_11181_length_190_cov_2.517730_g11095_i0	PRJNA864829	11181	190	2.51773	4.783687	Eukaryota	2759	Plants	Plants	52.8	0.016	NTclustered	gi\|2835530366\|dbj\|LC777195.1\|	3329	g11095	i0	100	1.03157894736842	28	0	15	0	163	190	55	28	Picea abies Pa-Kumamoto-2022 PaMurB mRNA for UDP-N-acetylmuramate dehydrogenase, complete cds	blastn	196	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
1236869	1236869	PRJNA864829_S_NODE_2761_length_325_cov_6.340580_g2675_i0	PRJNA864829	2761	325	6.34058	20.606885	Magnoliopsida	3398	Plants	Plants	87.9	8.37e-13	NTclustered	gi\|2082500773\|ref\|XR_006239396.1\|	32201	g2675	i0	83.673	1.56923076923077	98	10	29	5	27	121	2781	2875	PREDICTED: Carya illinoinensis 28S ribosomal RNA (LOC122298349), rRNA	blastn	510	87.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Juglandaceae	Carya	Carya illinoinensis
2122637	2122637	PRJNA864829_S_NODE_13182_length_176_cov_11.251969_g13096_i0	PRJNA864829	13182	176	11.251969	19.80346544	Picea abies	3329	Plants	Plants	52.8	0.015	NTclustered	gi\|2835530393\|dbj\|LC777203.1\|	3329	g13096	i0	100	0.159090909090909	28	0	16	0	1	28	29	56	Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
2122660	2122660	PRJNA864829_S_NODE_5342_length_257_cov_2.365385_g5256_i0	PRJNA864829	5342	257	2.365385	6.07903945	Quercus robur	38942	Plants	Plants	446	9.179999999999998e-121	NTclustered	gi\|2293106273\|ref\|XM_050425991.1\|	38942	g5256	i0	98.054	2.75486381322957	257	3	100	2	1	257	331	585	PREDICTED: Quercus robur copper transport protein ATX1-like (LOC126722845), mRNA	blastn	708	446	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus robur
2512391	2512391	PRJNA864829_S_NODE_4322_length_279_cov_1.400000_g4236_i0	PRJNA864829	4322	279	1.4	3.906	root	1	Root_unresolved	Root_unresolved	52.8	0.026	NTclustered	gi\|2835530364\|dbj\|LC777194.1\|	3329	g4236	i0	100	0.200716845878136	28	0	10	0	1	28	29	56	Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds	blastn	56	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
4675763	4675763	PRJNA864829_S_NODE_9864_length_200_cov_3.463576_g9778_i0	PRJNA864829	9864	200	3.463576	6.927152	Ziziphus jujuba	326968	Plants	Plants	52.8	0.017	NTclustered	gi\|2739574740\|gb\|CP157414.1\|	326968	g9778	i0	100	0.14	28	0	14	0	18	45	17662983	17663010	Ziziphus jujuba isolate TW-2024b chromosome 12	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rhamnaceae	Ziziphus	Ziziphus jujuba
5950589	5950589	PRJNA864829_S_NODE_5225_length_259_cov_8.461905_g5139_i0	PRJNA864829	5225	259	8.461905	21.91633395	Picea abies	3329	Plants	Plants	60.2	1.41e-4	NTclustered	gi\|2835530366\|dbj\|LC777195.1\|	3329	g5139	i0	100	0.787644787644788	32	0	12	0	1	32	28	59	Picea abies Pa-Kumamoto-2022 PaMurB mRNA for UDP-N-acetylmuramate dehydrogenase, complete cds	blastn	204	60.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
8500208	8500208	PRJNA864829_S_NODE_7387_length_226_cov_3.638418_g7301_i0	PRJNA864829	7387	226	3.638418	8.22282468	Quercus suber	58331	Plants	Plants	315	2.32e-81	NTclustered	gi\|2743720803\|ref\|XM_065765310.1\|	58331	g7301	i0	91.703	5.05752212389381	229	15	100	4	1	226	1198	971	PREDICTED: Quercus suber protein CDI (LOC112025824), transcript variant X1, mRNA	blastn	1143	315	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus suber
9775284	9775284	PRJNA864829_S_NODE_11248_length_190_cov_1.127660_g11162_i0	PRJNA864829	11248	190	1.12766	2.142554	Helianthus annuus	4232	Plants	Plants	115	2.0500000000000003e-21	NTclustered	gi\|1898381395\|ref\|XM_022117010.2\|	4232	g11162	i0	77.895	1	190	38	99	4	2	190	406	592	PREDICTED: Helianthus annuus calmodulin-like protein 3 (LOC110867945), mRNA	blastn	190	115	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Helianthus	Helianthus annuus
9775290	9775290	PRJNA864829_S_NODE_13768_length_173_cov_1.927419_g13682_i0	PRJNA864829	13768	173	1.927419	3.33443487	Morus notabilis	981085	Plants	Plants	298	1.69e-76	NTclustered	gi\|1350205780\|ref\|XM_010114302.2\|	981085	g13682	i0	97.688	1	173	4	100	0	1	173	1044	1216	PREDICTED: Morus notabilis reticulon-like protein B4 (LOC21390106), mRNA	blastn	173	298	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Morus	Morus notabilis
10165417	10165417	PRJNA864829_S_NODE_2088_length_361_cov_1.935897_g2002_i0	PRJNA864829	2088	361	1.935897	6.98858817	Eukaryota	2759	Plants	Plants	641	1.5999999999999993e-179	NTclustered	gi\|1878849207\|gb\|MT796543.1\|	3512	g2002	i0	100	96.1218836565097	347	0	96	0	15	361	1644	1990	Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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	34700	641	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
11050989	11050989	PRJNA864829_S_NODE_11249_length_190_cov_1.127660_g11163_i0	PRJNA864829	11249	190	1.12766	2.142554	Picea abies	3329	Plants	Plants	58.4	3.51e-4	NTclustered	gi\|2835530398\|dbj\|LC777204.1\|	3329	g11163	i0	100	0.457894736842105	31	0	16	0	1	31	29	59	Picea abies Pa-Kumamoto-2022 PaPbp mRNA for penicillin-binding protein, complete cds	blastn	87	58.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
11440654	11440654	PRJNA864829_S_NODE_9869_length_200_cov_3.264901_g9783_i0	PRJNA864829	9869	200	3.264901	6.529802	Vitis	3603	Plants	Plants	108	3.66e-19	NTclustered	gi\|349709448\|emb\|FQ390599.1\|	29760	g9783	i0	92.105	13.765	76	6	38	0	16	91	451	526	Vitis vinifera clone SS0AEB17YD24	blastn	2753	108	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
12326440	12326440	PRJNA864829_S_NODE_5730_length_250_cov_34.049751_g5644_i0	PRJNA864829	5730	250	34.049751	85.1243775	Picea abies	3329	Plants	Plants	52.8	0.023	NTclustered	gi\|2835530393\|dbj\|LC777203.1\|	3329	g5644	i0	100	0.112	28	0	11	0	1	28	29	56	Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
13600941	13600941	PRJNA864829_S_NODE_1151_length_453_cov_3.393564_g1065_i0	PRJNA864829	1151	453	3.393564	15.37284492	Picea abies	3329	Plants	Plants	54.7	0.012	NTclustered	gi\|2835530393\|dbj\|LC777203.1\|	3329	g1065	i0	100	0.0640176600441501	29	0	6	0	425	453	57	29	Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds	blastn	29	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
13990761	13990761	PRJNA864829_S_NODE_7271_length_228_cov_1.558659_g7185_i0	PRJNA864829	7271	228	1.558659	3.55374252	Quercus	3511	Plants	Plants	333	6.479999999999999e-87	NTclustered	gi\|2293082522\|ref\|XM_050413958.1\|	38942	g7185	i0	92.982	27.8157894736842	228	16	100	0	1	228	178	405	PREDICTED: Quercus robur stress-induced protein KIN2-like (LOC126713981), mRNA	blastn	6342	333	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus robur
14875264	14875264	PRJNA864829_S_NODE_1052_length_469_cov_5.654762_g966_i0	PRJNA864829	1052	469	5.654762	26.52083378	Cuscuta howelliana	437266	Plants	Plants	104	1.24e-17	NTclustered	gi\|215400937\|gb\|EU883503.1\|	437266	g966	i0	90.123	10.865671641791	81	6	17	2	367	446	356	277	Cuscuta howelliana isolate 357 26S ribosomal RNA gene, partial sequence	blastn	5096	104	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Convolvulaceae	Cuscuta	Cuscuta howelliana
15264794	15264794	PRJNA864829_S_NODE_9272_length_206_cov_1.025478_g9186_i0	PRJNA864829	9272	206	1.025478	2.11248468	Eukaryota	2759	Plants	Plants	52.8	0.018	NTclustered	gi\|2835530366\|dbj\|LC777195.1\|	3329	g9186	i0	100	0.951456310679612	28	0	14	0	1	28	28	55	Picea abies Pa-Kumamoto-2022 PaMurB mRNA for UDP-N-acetylmuramate dehydrogenase, complete cds	blastn	196	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
16149952	16149952	PRJNA864829_S_NODE_14033_length_172_cov_1.032520_g13947_i0	PRJNA864829	14033	172	1.03252	1.7759344	Pinus tabuliformis	88731	Plants	Plants	213	6.25e-51	NTclustered	gi\|758852344\|gb\|KJ711046.1\|	88731	g13947	i0	95.489	0.773255813953488	133	6	77	0	1	133	916	1048	Pinus tabuliformis clone PtEXP1 EXP1 mRNA, complete cds	blastn	133	213	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Pinus	Pinus tabuliformis
17425450	17425450	PRJNA864829_S_NODE_15514_length_166_cov_0.923077_g15428_i0	PRJNA864829	15514	166	0.923077	1.53230782	Quercus suber	58331	Plants	Plants	261	2.12e-65	NTclustered	gi\|2743681091\|ref\|XM_024032270.2\|	58331	g15428	i0	95.152	18.2710843373494	165	8	99	0	2	166	429	593	PREDICTED: Quercus suber NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit 13-B (LOC112000163), mRNA	blastn	3033	261	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus suber
18698646	18698646	PRJNA864829_S_NODE_8675_length_212_cov_0.987730_g8589_i0	PRJNA864829	8675	212	0.98773	2.0939876	Lilium hybrid cultivar	156531	Plants	Plants	54.7	0.005	NTclustered	gi\|1789804197\|gb\|MF101406.2\|	156531	g8589	i0	100	0.674528301886792	29	0	14	0	1	29	30	58	Lilium hybrid cultivar soluble starch synthase (SSS) mRNA, complete cds	blastn	143	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Liliales	Liliaceae	Lilium	Lilium hybrid cultivar
19973914	19973914	PRJNA864829_S_NODE_9356_length_205_cov_1.378205_g9270_i0	PRJNA864829	9356	205	1.378205	2.82532025	Triticum dicoccoides	85692	Plants	Plants	52.8	0.018	NTclustered	gi\|1931459121\|ref\|XR_005175949.1\|	85692	g9270	i0	100	0.136585365853659	28	0	14	0	70	97	994	967	PREDICTED: Triticum dicoccoides uncharacterized LOC119366164 (LOC119366164), ncRNA	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum dicoccoides
20363233	20363233	PRJNA864829_S_NODE_2776_length_325_cov_2.547101_g2690_i0	PRJNA864829	2776	325	2.547101	8.27807825	Fagaceae	3503	Plants	Plants	558	1.48e-154	NTclustered	gi\|1878849207\|gb\|MT796543.1\|	3512	g2690	i0	100	92.9230769230769	302	0	93	0	24	325	4950	5251	Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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	30200	558	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
21638916	21638916	PRJNA864829_S_NODE_8037_length_218_cov_2.704142_g7951_i0	PRJNA864829	8037	218	2.704142	5.89502956	Celastraceae	4305	Plants	Plants	392	1e-104	NTclustered	gi\|1214985220\|gb\|KX232030.1\|	489995	g7951	i0	99.083	99.9357798165138	218	2	100	0	1	218	253	36	Haydenoxylon urbanianum voucher L. Biral 1063, Brazil (HRCB) 26S ribosomal RNA gene, partial sequence	blastn	21786	392	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Celastrales	Celastraceae	Haydenoxylon	Haydenoxylon urbanianum
22524011	22524011	PRJNA864829_S_NODE_8558_length_213_cov_1.463415_g8472_i0	PRJNA864829	8558	213	1.463415	3.11707395	Olea europaea	4146	Plants	Plants	327	2.78e-85	NTclustered	gi\|1279063535\|ref\|XM_023037846.1\|	158386	g8472	i0	94.366	4.69953051643192	213	12	100	0	1	213	914	702	PREDICTED: Olea europaea var. sylvestris stress-related protein-like (LOC111408075), mRNA	blastn	1001	327	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Olea	Olea europaea
22914566	22914566	PRJNA864829_S_NODE_7178_length_229_cov_2.083333_g7092_i0	PRJNA864829	7178	229	2.083333	4.77083257	Quercus	3511	Plants	Plants	383	6.38e-102	NTclustered	gi\|2743725481\|ref\|XM_024049559.2\|	58331	g7092	i0	96.943	4.68122270742358	229	6	100	1	1	229	275	502	PREDICTED: Quercus suber NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit 1 (LOC112017090), mRNA	blastn	1072	383	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus suber
23799564	23799564	PRJNA864829_S_NODE_8959_length_209_cov_1.731250_g8873_i0	PRJNA864829	8959	209	1.73125	3.6183125	Picea sitchensis	3332	Plants	Plants	387	4.42e-103	NTclustered	gi\|148906791\|gb\|EF676655.1\|	3332	g8873	i0	100	106	209	0	100	0	1	209	537	745	Picea sitchensis clone WS02746_H02 unknown mRNA	blastn	22154	387	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea sitchensis
24188401	24188401	PRJNA864829_S_NODE_5259_length_259_cov_1.614286_g5173_i0	PRJNA864829	5259	259	1.614286	4.18100074	Populus	3689	Plants	Plants	446	9.26e-121	NTclustered	gi\|2645349388\|ref\|XM_062090359.1\|	3691	g5173	i0	97.683	46.3899613899614	259	6	100	0	1	259	664	406	PREDICTED: Populus nigra cytochrome c (LOC133669984), mRNA	blastn	12015	446	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus nigra
24188402	24188402	PRJNA864829_S_NODE_5319_length_257_cov_14.605769_g5233_i0	PRJNA864829	5319	257	14.605769	37.53682633	root	1	Root_unresolved	Root_unresolved	52.8	0.023	NTclustered	gi\|2835530364\|dbj\|LC777194.1\|	3329	g5233	i0	100	0.217898832684825	28	0	11	0	1	28	29	56	Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds	blastn	56	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies

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