metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax

17 rows where analysis = "diamond", bioproject = "PRJEB73599" 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
2270628	2270628	PRJEB73599_P_NODE_7022_length_218_cov_3.000000_g6735_i0	PRJEB73599	7022	218	3	6.54	Streptophyta	35493	Plants	Plants	72.8	1.35e-13	NR	CAM6026948.1	128184	g6735	i0	80	31.1422018348624	40	8	55	0	215	96	136	175	CAM6026948.1 unnamed protein product [Sphagnum balticum]	diamond	6789	73.2	0.994535519125683	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
6513240	6513240	PRJEB73599_P_NODE_1326_length_647_cov_2.752427_g1123_i0	PRJEB73599	1326	647	2.752427	17.80820269	Streptophyta	35493	Plants	Plants	206	1.48e-63	NR	KAI5068948.1	13818	g1123	i0	54.9	24.0185471406492	215	79	99.7	5	2	646	1	197	KAI5068948.1 hypothetical protein GOP47_0015249 [Adiantum capillus-veneris]	diamond	15540	207	0.995169082125604	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
6513255	6513255	PRJEB73599_P_NODE_3046_length_414_cov_1.942857_g2761_i0	PRJEB73599	3046	414	1.942857	8.04342798	Eukaryota	2759	Plants	Plants	102	4.41e-22	NR	MCL7034904.1	74823	g2761	i0	51.5	6.32608695652174	97	47	70.3	0	292	2	494	590	MCL7034904.1 hypothetical protein [Papaver nudicaule]	diamond	2619	103	0.990291262135922	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Papaveraceae	Papaver	Papaver nudicaule
20536084	20536084	PRJEB73599_P_NODE_3997_length_346_cov_1.870662_g3710_i0	PRJEB73599	3997	346	1.870662	6.47249052	Riccia fluitans	41844	Plants	Plants	115	6.1399999999999995e-30	NR	KAL2623906.1	41844	g3710	i0	81.8	1.71676300578035	66	12	57.2	0	83	280	80	145	KAL2623906.1 hypothetical protein R1flu_008151 [Riccia fluitans]	diamond	594	115	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Marchantiopsida	Marchantiales	Ricciaceae	Riccia	Riccia fluitans
24360982	24360982	PRJEB73599_P_NODE_3060_length_413_cov_2.963542_g2775_i0	PRJEB73599	3060	413	2.963542	12.23942846	Opisthokonta	33154	Plants	Plants	196	7.3e-59	NR	GBG82800.1	69332	g2775	i0	75.4	10.953995157385	138	33	99.5	1	3	413	139	276	GBG82800.1 hypothetical protein CBR_g36331 [Chara braunii]	diamond	4524	197	0.99492385786802	Eukaryota		Viridiplantae	Streptophyta	Charophyceae	Charales	Characeae	Chara	Chara braunii
26837192	26837192	PRJEB73599_P_NODE_8141_length_189_cov_1.443750_g7854_i0	PRJEB73599	8141	189	1.44375	2.7286875	Magnoliopsida	3398	Plants	Plants	62	2.86e-9	NR	GMH03277.1	150966	g7854	i0	47.5	3.87301587301587	61	32	96.8	0	3	185	725	785	GMH03277.1 hypothetical protein Nepgr_005116 [Nepenthes gracilis]	diamond	732	62	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Nepenthaceae	Nepenthes	Nepenthes gracilis
27879795	27879795	PRJEB73599_P_NODE_5585_length_267_cov_2.147059_g5298_i0	PRJEB73599	5585	267	2.147059	5.73264753	Viridiplantae	33090	Plants	Plants	64.3	6.07e-11	NR	KAJ6756078.1	77065	g5298	i0	54.2	4.31460674157303	72	31	79.8	2	15	227	41	111	KAJ6756078.1 30S 40S RIBOSOMAL PROTEIN [Salix purpurea]	diamond	1152	64.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Salix	Salix purpurea
28669289	28669289	PRJEB73599_P_NODE_2147_length_506_cov_2.750524_g1891_i0	PRJEB73599	2147	506	2.750524	13.91765144	Eukaryota	2759	Plants	Plants	137	2.4e-36	NR	QDX19557.1	39947	g1891	i0	46	13.0079051383399	163	82	93.7	2	482	9	5	166	QDX19557.1 hypothetical protein [Oryza sativa Japonica Group]	diamond	6582	138	0.992753623188406	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
29213335	29213335	PRJEB73599_P_NODE_4609_length_311_cov_2.460993_g4322_i0	PRJEB73599	4609	311	2.460993	7.65368823	Anisodus tanguticus	243964	Plants	Plants	42.7	0.0465	NR	KAK4369194.1	243964	g4322	i0	45.2	0.405144694533762	42	23	40.5	0	154	29	6	47	KAK4369194.1 hypothetical protein RND71_012986 [Anisodus tanguticus]	diamond	126	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Anisodus	Anisodus tanguticus
29371074	29371074	PRJEB73599_P_NODE_8189_length_188_cov_1.515723_g7902_i0	PRJEB73599	8189	188	1.515723	2.84955924	Tanacetum cinerariifolium	118510	Plants	Plants	76.3	2.77e-14	NR	GEU28527.1	118510	g7902	i0	75	3.15957446808511	52	12	83	1	33	188	3425	3475	GEU28527.1 aspartate--tRNA ligase, chloroplastic/mitochondrial [Tanacetum cinerariifolium]	diamond	594	76.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
29616040	29616040	PRJEB73599_P_NODE_4110_length_339_cov_1.909677_g3823_i0	PRJEB73599	4110	339	1.909677	6.47380503	Eukaryota	2759	Plants	Plants	53.9	4.48e-6	NR	PWZ11267.1	4577	g3823	i0	44.7	3.17699115044248	76	40	66.4	2	1	225	13	87	PWZ11267.1 Uncharacterized protein Zm00014a_012555 [Zea mays]	diamond	1077	53.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
30816809	30816809	PRJEB73599_P_NODE_3494_length_380_cov_1.629630_g3208_i0	PRJEB73599	3494	380	1.62963	6.192594	Streptophyta	35493	Plants	Plants	129	2.36e-32	NR	KAG0567129.1	3225	g3208	i0	56.8	3.97105263157895	132	50	98.7	2	6	380	309	440	KAG0567129.1 hypothetical protein KC19_7G112700 [Ceratodon purpureus]	diamond	1509	129	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Pseudoditrichales	Ditrichaceae	Ceratodon	Ceratodon purpureus
30855553	30855553	PRJEB73599_P_NODE_10154_length_150_cov_2.165289_g9867_i0	PRJEB73599	10154	150	2.165289	3.2479335	Brassica carinata	52824	Plants	Plants	48.5	7.03e-5	NR	KAL0642007.1	52824	g9867	i0	67.5	0.8	40	10	78	2	146	30	18	55	KAL0642007.1 hypothetical protein Bca4012_102970 [Brassica carinata]	diamond	120	48.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica carinata
31266457	31266457	PRJEB73599_P_NODE_5555_length_268_cov_2.548117_g5268_i0	PRJEB73599	5555	268	2.548117	6.82895356	Durio zibethinus	66656	Plants	Plants	83.2	6.09e-18	NR	XP_022752929.1	66656	g5268	i0	61.8	2.18283582089552	68	20	69.4	1	78	263	64	131	XP_022752929.1 SUMO-conjugating enzyme UBC9-like isoform X1 [Durio zibethinus]	diamond	585	83.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Durio	Durio zibethinus
31638650	31638650	PRJEB73599_P_NODE_7536_length_203_cov_1.982759_g7249_i0	PRJEB73599	7536	203	1.982759	4.02500077	Streptophyta	35493	Plants	Plants	81.6	3.35e-16	NR	KAG6545352.1	56867	g7249	i0	57.9	12.3546798029557	76	22	97.5	1	203	6	128	203	KAG6545352.1 hypothetical protein Mapa_013201 [Marchantia paleacea]	diamond	2508	81.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Marchantiopsida	Marchantiales	Marchantiaceae	Marchantia	Marchantia paleacea
32342231	32342231	PRJEB73599_P_NODE_819_length_836_cov_1.950434_g662_i0	PRJEB73599	819	836	1.950434	16.30562824	Cryptomeria japonica	3369	Plants	Plants	160	9.29e-43	NR	XP_057865708.1	3369	g662	i0	43.2	2.47607655502392	222	104	75	9	90	716	62	274	XP_057865708.1 cysteine proteinase 15A [Cryptomeria japonica]	diamond	2070	160	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
32745346	32745346	PRJEB73599_P_NODE_8040_length_191_cov_1.895062_g7753_i0	PRJEB73599	8040	191	1.895062	3.61956842	Eukaryota	2759	Plants	Plants	76.6	2.09e-14	NR	TVU17487.1	38414	g7753	i0	68.8	13.7120418848168	64	19	99	1	2	190	291	354	TVU17487.1 hypothetical protein EJB05_33525, partial [Eragrostis curvula]	diamond	2619	77	0.994805194805195	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Eragrostis	Eragrostis curvula

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