metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1113956" 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
221976	221976	PRJNA1113956_P_NODE_9381_length_465_cov_0.742347_g9042_i0	PRJNA1113956	9381	465	0.742347	3.45191355	Dioscorea cayenensis	29710	Plants	Plants	793	0	NTclustered	gi\|1221815295\|dbj\|LC219378.1\|	55577	g9042	i0	97.419	85.9741935483871	465	12	100	0	1	465	9203	8739	Dioscorea rotundata mitochondrial DNA, contig: TDr_Mt_scaffold5_size12031, cultivar: TDr96_F1	blastn	39978	793	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Dioscoreales	Dioscoreaceae	Dioscorea	Dioscorea cayenensis
1496722	1496722	PRJNA1113956_P_NODE_21382_length_245_cov_1.511628_g21042_i0	PRJNA1113956	21382	245	1.511628	3.7034886	Prunus dulcis	3755	Plants	Plants	52.8	0.022	NTclustered	gi\|2699132183\|emb\|OZ022199.1\|	3755	g21042	i0	100	0.114285714285714	28	0	11	0	204	231	3711757	3711784	Prunus dulcis genome assembly, chromosome: 3	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Prunus	Prunus dulcis
5324951	5324951	PRJNA1113956_P_NODE_5445_length_723_cov_6.470769_g5138_i0	PRJNA1113956	5445	723	6.470769	46.78365987	Cicer arietinum	3827	Plants	Plants	73.1	5.55e-8	NTclustered	gi\|1535893373\|ref\|XM_004509673.3\|	3827	g5138	i0	87.5	0.20746887966805	64	6	9	2	478	540	757	695	PREDICTED: Cicer arietinum glycine-rich cell wall structural protein 1.0-like (LOC101508402), mRNA	blastn	150	73.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Cicer	Cicer arietinum
7874729	7874729	PRJNA1113956_P_NODE_11167_length_402_cov_12.258359_g10827_i0	PRJNA1113956	11167	402	12.258359	49.27860318	Panicum hallii	206008	Plants	Plants	56.5	0.003	NTclustered	gi\|1435173994\|ref\|XM_025967816.1\|	206008	g10827	i0	96.97	0.082089552238806	33	1	8	0	86	118	539	507	PREDICTED: Panicum hallii endochitinase A-like (LOC112899373), mRNA	blastn	33	56.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Panicum	Panicum hallii
10425535	10425535	PRJNA1113956_P_NODE_20549_length_248_cov_0.880000_g20209_i0	PRJNA1113956	20549	248	0.88	2.1824	Ziziphus jujuba	326968	Plants	Plants	52.8	0.022	NTclustered	gi\|2739574733\|gb\|CP157407.1\|	326968	g20209	i0	100	0.112903225806452	28	0	11	0	84	111	15004542	15004515	Ziziphus jujuba isolate TW-2024b chromosome 05	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rhamnaceae	Ziziphus	Ziziphus jujuba
12502677	12502677	PRJNA1113956_P_NODE_19330_length_255_cov_1.368132_g18990_i0	PRJNA1113956	19330	255	1.368132	3.4887366	Malus	3749	Plants	Plants	52.8	0.023	NTclustered	gi\|2878365103\|ref\|XM_008366767.4\|	3750	g18990	i0	96.875	0.501960784313725	32	0	12	1	69	99	1338	1369	PREDICTED: Malus domestica uncharacterized protein (LOC103428644), transcript variant X2, mRNA	blastn	128	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Malus	Malus domestica
14250888	14250888	PRJNA1113956_P_NODE_17652_length_277_cov_1.696078_g17312_i0	PRJNA1113956	17652	277	1.696078	4.69813606	Medicago truncatula	3880	Plants	Plants	52.8	0.025	NTclustered	gi\|37654168\|gb\|AC144502.5\|	3880	g17312	i0	100	0.101083032490975	28	0	10	0	248	275	30246	30219	Medicago truncatula clone mth2-5p10, complete sequence	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Medicago	Medicago truncatula
14250968	14250968	PRJNA1113956_P_NODE_22812_length_241_cov_0.916667_g22472_i0	PRJNA1113956	22812	241	0.916667	2.20916747	Solanum lycopersicum	4081	Plants	Plants	344	3.199999999999999e-90	NTclustered	gi\|15418711\|gb\|AY007367.1\|	4081	g22472	i0	92.5	312.775933609958	240	18	100	0	1	240	12177	11938	Lycopersicon esculentum tospovirus resistance protein C (Sw5-c), tospovirus resistance protein D (Sw5-d), and tospovirus resistance protein E (Sw5-e) genes, complete cds	blastn	75379	344	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum lycopersicum
16799036	16799036	PRJNA1113956_P_NODE_14914_length_319_cov_1.252033_g14574_i0	PRJNA1113956	14914	319	1.252033	3.99398527	Ipomoea triloba	35885	Plants	Plants	52.8	0.03	NTclustered	gi\|1766767796\|ref\|XR_004100687.1\|	35885	g14574	i0	100	0.175548589341693	28	0	9	0	218	245	2880	2853	PREDICTED: Ipomoea triloba uncharacterized LOC116031872 (LOC116031872), transcript variant X7, ncRNA	blastn	56	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Convolvulaceae	Ipomoea	Ipomoea triloba
18073644	18073644	PRJNA1113956_P_NODE_2635_length_1142_cov_3.287184_g2433_i0	PRJNA1113956	2635	1142	3.287184	37.53964128	Trichophorum cespitosum	76515	Plants	Plants	54.7	0.032	NTclustered	gi\|2919517562\|emb\|OZ238292.1\|	76515	g2433	i0	96.875	0.0280210157618214	32	1	3	0	217	248	1264690	1264659	Trichophorum cespitosum genome assembly, chromosome: 24	blastn	32	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Cyperaceae	Trichophorum	Trichophorum cespitosum
24448186	24448186	PRJNA1113956_P_NODE_9040_length_479_cov_87.581281_g8701_i0	PRJNA1113956	9040	479	87.581281	419.51433599	Medicago truncatula	3880	Plants	Plants	215	5.62e-51	NTclustered	gi\|217075589\|gb\|BT053496.1\|	3880	g8701	i0	81.679	30.9227557411274	262	44	54	4	135	394	191	450	Medicago truncatula clone MTYFP_FQ_FR_FS1G-I-6 unknown mRNA	blastn	14812	215	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Medicago	Medicago truncatula

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