metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA694557" 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
673462	673462	PRJNA694557_P_NODE_3781_length_784_cov_3.696203_g3580_i0	PRJNA694557	3781	784	3.696203	28.97823152	Adiantum nelumboides	2759587	Plants	Plants	315	2.5299999999999995e-106	NR	MCO5592073.1	2759587	g3580	i0	84.2	1.89795918367347	165	26	63.1	0	781	287	1	165	MCO5592073.1 hypothetical protein [Adiantum nelumboides]	diamond	1488	315	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
1179805	1179805	PRJNA694557_P_NODE_8081_length_493_cov_2.938095_g7861_i0	PRJNA694557	8081	493	2.938095	14.48480835	Humulus scandens	228586	Plants	Plants	56.2	2.98e-7	NR	AVY54507.1	228586	g7861	i0	39.7	0.44421906693712	73	44	44.4	0	119	337	1	73	AVY54507.1 Hum s 3 allergen [Humulus scandens]	diamond	219	56.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Humulus	Humulus scandens
3224393	3224393	PRJNA694557_P_NODE_2723_length_947_cov_3.102975_g2542_i0	PRJNA694557	2723	947	3.102975	29.38517325	Adiantum nelumboides	2759587	Plants	Plants	426	2.14e-140	NR	MCO5602604.1	2759587	g2542	i0	85.1	0.807814149947202	255	36	80.5	2	16	777	541	794	MCO5602604.1 hypothetical protein [Adiantum nelumboides]	diamond	765	426	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
13427228	13427228	PRJNA694557_P_NODE_5791_length_609_cov_3.899254_g5572_i0	PRJNA694557	5791	609	3.899254	23.74645686	Adiantum nelumboides	2759587	Plants	Plants	238	3.620000000000001e-77	NR	MCO5578107.1	2759587	g5572	i0	91.2	0.67487684729064	137	12	67.5	0	6	416	8	144	MCO5578107.1 hypothetical protein [Adiantum nelumboides]	diamond	411	238	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
22350821	22350821	PRJNA694557_P_NODE_5078_length_660_cov_2.764906_g4862_i0	PRJNA694557	5078	660	2.764906	18.2483796	Adiantum capillus-veneris	13818	Plants	Plants	288	3.64e-90	NR	KAI5062321.1	13818	g4862	i0	76.5	1.66363636363636	183	37	80.5	2	592	62	149	331	KAI5062321.1 hypothetical protein GOP47_0022860 [Adiantum capillus-veneris]	diamond	1098	288	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
26733999	26733999	PRJNA694557_P_NODE_11401_length_398_cov_2.369231_g11181_i0	PRJNA694557	11401	398	2.369231	9.42953938	Cannabis sativa	3483	Plants	Plants	116	1.99e-27	NR	XP_030497248.2	3483	g11181	i0	79.4	0.994974874371859	63	13	47.5	0	2	190	497	559	XP_030497248.2 pectinesterase [Cannabis sativa]	diamond	396	116	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa
26924439	26924439	PRJNA694557_P_NODE_15222_length_332_cov_1.783784_g15002_i0	PRJNA694557	15222	332	1.783784	5.92216288	Impatiens glandulifera	253017	Plants	Plants	53.1	5.73e-6	NR	XP_047329815.1	253017	g15002	i0	28.6	3.09036144578313	105	71	91.3	1	329	27	6	110	XP_047329815.1 zinc finger CCCH domain-containing protein 63-like [Impatiens glandulifera]	diamond	1026	53.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Balsaminaceae	Impatiens	Impatiens glandulifera
27662727	27662727	PRJNA694557_P_NODE_19904_length_280_cov_2.376812_g19684_i0	PRJNA694557	19904	280	2.376812	6.6550736	Streptophyta	35493	Plants	Plants	86.7	1.83e-17	NR	WJX80173.1	3899	g19684	i0	91.3	12.3642857142857	46	4	49.3	0	251	114	435	480	WJX80173.1 hypothetical protein P8452_63207 [Trifolium repens]	diamond	3462	86.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Trifolium	Trifolium repens
28010081	28010081	PRJNA694557_P_NODE_20685_length_273_cov_2.310000_g20465_i0	PRJNA694557	20685	273	2.31	6.3063	Adiantum	13817	Plants	Plants	143	1.5399999999999998e-37	NR	KAI5062321.1	13818	g20465	i0	75.6	1.97802197802198	90	22	98.9	0	272	3	562	651	KAI5062321.1 hypothetical protein GOP47_0022860 [Adiantum capillus-veneris]	diamond	540	143	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
28535495	28535495	PRJNA694557_P_NODE_11007_length_407_cov_1.335329_g10787_i0	PRJNA694557	11007	407	1.335329	5.43478903	Ricinus communis	3988	Plants	Plants	81.3	7.93e-15	NR	XP_002520202.2	3988	g10787	i0	58.5	0.604422604422604	82	24	56	4	356	129	133	210	XP_002520202.2 formin-like protein 4 [Ricinus communis]	diamond	246	81.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Ricinus	Ricinus communis
28661728	28661728	PRJNA694557_P_NODE_12907_length_367_cov_4.095238_g12687_i0	PRJNA694557	12907	367	4.095238	15.02952346	Hordeum vulgare	4513	Plants	Plants	87	2.72e-18	NR	KAE8775869.1	4513	g12687	i0	48.1	1.4550408719346	108	33	88.3	2	358	35	43	127	KAE8775869.1 putative oxidoreductase [Hordeum vulgare]	diamond	534	87	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
28882524	28882524	PRJNA694557_P_NODE_13048_length_365_cov_2.366438_g12828_i0	PRJNA694557	13048	365	2.366438	8.6374987	Ricinus communis	3988	Plants	Plants	88.2	8.24e-18	NR	EEF46317.1	3988	g12828	i0	69.8	0.435616438356164	53	16	43.6	0	20	178	309	361	EEF46317.1 conserved hypothetical protein [Ricinus communis]	diamond	159	88.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Ricinus	Ricinus communis
28946027	28946027	PRJNA694557_P_NODE_13768_length_354_cov_1.391459_g13548_i0	PRJNA694557	13768	354	1.391459	4.92576486	Parasponia andersonii	3476	Plants	Plants	193	3.41e-56	NR	PON43221.1	3476	g13548	i0	73.9	2.92372881355932	115	30	97.5	0	346	2	367	481	PON43221.1 Pectinesterase inhibitor domain containing protein [Parasponia andersonii]	diamond	1035	193	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Parasponia	Parasponia andersonii
29367649	29367649	PRJNA694557_P_NODE_6269_length_580_cov_2.591716_g6050_i0	PRJNA694557	6269	580	2.591716	15.0319528	Pteridaceae	13819	Plants	Plants	145	3.03e-38	NR	KAI5082097.1	13818	g6050	i0	95.7	1.06034482758621	69	3	35.7	0	571	365	308	376	KAI5082097.1 hypothetical protein GOP47_0001840 [Adiantum capillus-veneris]	diamond	615	145	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
29556850	29556850	PRJNA694557_P_NODE_13110_length_364_cov_2.378007_g12890_i0	PRJNA694557	13110	364	2.378007	8.65594548	Adiantum	13817	Plants	Plants	199	3.63e-62	NR	KAI5065677.1	13818	g12890	i0	79.3	3.98076923076923	121	25	99.7	0	363	1	54	174	KAI5065677.1 hypothetical protein GOP47_0020372 [Adiantum capillus-veneris]	diamond	1449	199	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
29766572	29766572	PRJNA694557_P_NODE_8971_length_461_cov_3.278351_g8751_i0	PRJNA694557	8971	461	3.278351	15.11319811	Ricinus communis	3988	Plants	Plants	64.3	1.14e-8	NR	XP_002520202.2	3988	g8751	i0	68.5	0.351409978308026	54	12	35.1	2	87	248	1	49	XP_002520202.2 formin-like protein 4 [Ricinus communis]	diamond	162	64.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Ricinus	Ricinus communis
30493390	30493390	PRJNA694557_P_NODE_7893_length_500_cov_5.950820_g7673_i0	PRJNA694557	7893	500	5.95082	29.7541	Adiantum capillus-veneris	13818	Plants	Plants	106	5.6799999999999995e-25	NR	KAI5065677.1	13818	g7673	i0	76.1	0.402	67	16	40.2	0	500	300	172	238	KAI5065677.1 hypothetical protein GOP47_0020372 [Adiantum capillus-veneris]	diamond	201	106	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
30619619	30619619	PRJNA694557_P_NODE_19333_length_285_cov_6.240566_g19113_i0	PRJNA694557	19333	285	6.240566	17.7856131	Parasponia andersonii	3476	Plants	Plants	85.1	3.79e-19	NR	PON58107.1	3476	g19113	i0	72.2	0.831578947368421	79	18	81.1	2	55	285	22	98	PON58107.1 hypothetical protein PanWU01x14_168770 [Parasponia andersonii]	diamond	237	85.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Parasponia	Parasponia andersonii
31124853	31124853	PRJNA694557_P_NODE_11155_length_403_cov_3.872727_g10935_i0	PRJNA694557	11155	403	3.872727	15.60708981	Cannabis sativa	3483	Plants	Plants	73.2	2.53e-14	NR	XP_030494560.2	3483	g10935	i0	76.7	0.446650124069479	60	11	42.4	1	68	238	1	60	XP_030494560.2 arabinogalactan protein 23 [Cannabis sativa]	diamond	180	73.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa
31156490	31156490	PRJNA694557_P_NODE_14575_length_341_cov_2.067164_g14355_i0	PRJNA694557	14575	341	2.067164	7.04902924	Adiantum capillus-veneris	13818	Plants	Plants	57	1.52e-7	NR	KAI5073363.1	13818	g14355	i0	63.6	0.580645161290323	66	17	52.8	3	309	130	69	133	KAI5073363.1 hypothetical protein GOP47_0011376 [Adiantum capillus-veneris]	diamond	198	57	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
31473207	31473207	PRJNA694557_P_NODE_4136_length_746_cov_3.872214_g3926_i0	PRJNA694557	4136	746	3.872214	28.88671644	Ricinus communis	3988	Plants	Plants	135	2.51e-36	NR	EEF49570.1	3988	g3926	i0	69.5	0.796246648793566	95	28	37.8	1	675	394	10	104	EEF49570.1 protein binding protein, putative [Ricinus communis]	diamond	594	135	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Ricinus	Ricinus communis
31568210	31568210	PRJNA694557_P_NODE_7376_length_524_cov_2.217295_g7156_i0	PRJNA694557	7376	524	2.217295	11.6186258	Klebsormidium nitens	105231	Plants	Plants	86.3	4.69e-16	NR	GAQ79973.1	105231	g7156	i0	38.1	0.887404580152672	155	72	88.2	5	5	466	64	195	GAQ79973.1 bifunctional dihydrofolate reductase - thymidylate synthase [Klebsormidium nitens]	diamond	465	86.3	1	Eukaryota		Viridiplantae	Streptophyta	Klebsormidiophyceae	Klebsormidiales	Klebsormidiaceae	Klebsormidium	Klebsormidium nitens
31769000	31769000	PRJNA694557_P_NODE_23357_length_251_cov_1.550562_g23137_i0	PRJNA694557	23357	251	1.550562	3.89191062	Eukaryota	2759	Plants	Plants	84.3	8.23e-17	NR	BAJ95319.1	112509	g23137	i0	50	1.75697211155378	76	36	88.4	1	17	238	34	109	BAJ95319.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	441	84.7	0.995277449822904	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
31863779	31863779	PRJNA694557_P_NODE_8477_length_479_cov_3.770936_g8257_i0	PRJNA694557	8477	479	3.770936	18.06278344	Adiantum	13817	Plants	Plants	138	1.16e-38	NR	KAI5057389.1	13818	g8257	i0	80.9	1.66597077244259	89	17	55.7	0	337	71	40	128	KAI5057389.1 hypothetical protein GOP47_0027404 [Adiantum capillus-veneris]	diamond	798	138	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum capillus-veneris
32454049	32454049	PRJNA694557_P_NODE_15819_length_324_cov_3.733068_g15599_i0	PRJNA694557	15819	324	3.733068	12.09514032	Humulus lupulus	3486	Plants	Plants	138	2.0999999999999999e-38	NR	XP_062083289.1	3486	g15599	i0	84.2	0.703703703703704	76	12	70.4	0	2	229	145	220	XP_062083289.1 vesicle-associated membrane protein 711-like [Humulus lupulus]	diamond	228	138	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Humulus	Humulus lupulus
32706126	32706126	PRJNA694557_P_NODE_26740_length_228_cov_5.187097_g26520_i0	PRJNA694557	26740	228	5.187097	11.82658116	Melia azedarach	155640	Plants	Plants	44.3	0.00869	NR	KAJ4728177.1	155640	g26520	i0	36	0.657894736842105	50	32	65.8	0	196	47	381	430	KAJ4728177.1 Intracellular protein transporter USO1-like protein [Melia azedarach]	diamond	150	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Meliaceae	Melia	Melia azedarach
32874908	32874908	PRJNA694557_P_NODE_19040_length_288_cov_2.832558_g18820_i0	PRJNA694557	19040	288	2.832558	8.15776704	Cannabaceae	3481	Plants	Plants	49.7	2.22e-4	NR	KAF4357614.1	3483	g18820	i0	95.8	0.5	24	1	25	0	265	194	477	500	KAF4357614.1 hypothetical protein F8388_007150 [Cannabis sativa]	diamond	144	50.1	0.992015968063872	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa

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