metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA1136957" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA1136957" 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
11763187	11763187	PRJNA1136957_S_NODE_12830_length_240_cov_5.348066_g12733_i0	PRJNA1136957	12830	240	5.348066	12.8353584	Magnoliopsida	3398	Plants	Plants	115	4.49e-30	NR	KAF4360744.1	3483	g12733	i0	67.9	36.95	78	25	97.5	0	238	5	131	208	KAF4360744.1 hypothetical protein G4B88_007810 [Cannabis sativa]	diamond	8868	115	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa
16334430	16334430	PRJNA1136957_S_NODE_4653_length_364_cov_1.531148_g4556_i0	PRJNA1136957	4653	364	1.531148	5.57337872	Klebsormidium nitens	105231	Plants	Plants	67	4.94e-10	NR	GAQ77980.1	105231	g4556	i0	44.6	0.60989010989011	74	41	61	0	363	142	1676	1749	GAQ77980.1 hypothetical protein KFL_000060450 [Klebsormidium nitens]	diamond	222	67	1	Eukaryota		Viridiplantae	Streptophyta	Klebsormidiophyceae	Klebsormidiales	Klebsormidiaceae	Klebsormidium	Klebsormidium nitens
27133222	27133222	PRJNA1136957_S_NODE_4502_length_368_cov_2.207120_g4405_i0	PRJNA1136957	4502	368	2.20712	8.1222016	Andrographis paniculata	175694	Plants	Plants	92	8.29e-19	NR	XP_051114945.1	175694	g4405	i0	48.1	0.880434782608696	108	48	88	2	363	40	624	723	XP_051114945.1 long chain acyl-CoA synthetase 8 [Andrographis paniculata]	diamond	324	92	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Acanthaceae	Andrographis	Andrographis paniculata
27280790	27280790	PRJNA1136957_S_NODE_18583_length_202_cov_1.279720_g18486_i0	PRJNA1136957	18583	202	1.27972	2.5850344	Eukaryota	2759	Plants	Plants	53.5	3.35e-6	NR	PTQ41178.1	3197	g18486	i0	91.7	23.1980198019802	24	2	35.6	0	202	131	370	393	PTQ41178.1 hypothetical protein MARPO_0036s0149 [Marchantia polymorpha]	diamond	4686	53.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Marchantiopsida	Marchantiales	Marchantiaceae	Marchantia	Marchantia polymorpha
27386634	27386634	PRJNA1136957_S_NODE_7623_length_302_cov_1.962963_g7526_i0	PRJNA1136957	7623	302	1.962963	5.92814826	Populus alba x Populus x berolinensis	444605	Plants	Plants	51.2	7.84e-5	NR	KAJ6885491.1	444605	g7526	i0	46.8	0.933774834437086	47	25	46.7	0	11	151	111	157	KAJ6885491.1 hypothetical protein NC651_026198 [Populus alba x Populus x berolinensis]	diamond	282	51.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus alba x Populus x berolinensis
27481165	27481165	PRJNA1136957_S_NODE_6603_length_320_cov_1.402299_g6506_i0	PRJNA1136957	6603	320	1.402299	4.4873568	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	79	1.41e-14	NR	BAK02948.1	112509	g6506	i0	46	0.815625	87	46	81.6	1	318	58	315	400	BAK02948.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	261	79	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
27954825	27954825	PRJNA1136957_S_NODE_8065_length_295_cov_1.343220_g7968_i0	PRJNA1136957	8065	295	1.34322	3.962499	Adiantum nelumboides	2759587	Plants	Plants	52	3.82e-5	NR	MCO5611203.1	2759587	g7968	i0	37.3	1.85084745762712	83	50	82.4	2	293	51	36	118	MCO5611203.1 hypothetical protein [Adiantum nelumboides]	diamond	546	52	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
28101598	28101598	PRJNA1136957_S_NODE_5505_length_342_cov_1.056537_g5408_i0	PRJNA1136957	5505	342	1.056537	3.61335654	Magnoliopsida	3398	Plants	Plants	76.6	1.56e-14	NR	XP_017238157.1	79200	g5408	i0	52.2	3.44736842105263	67	32	58.8	0	342	142	121	187	XP_017238157.1 uncharacterized protein LOC108211145 [Daucus carota subsp. sativus]	diamond	1179	77	0.994805194805195	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Apiales	Apiaceae	Daucus	Daucus carota
28365073	28365073	PRJNA1136957_S_NODE_21986_length_182_cov_2.178862_g21889_i0	PRJNA1136957	21986	182	2.178862	3.96552884	Saponaria officinalis	3572	Plants	Plants	44.7	0.00292	NR	KAK9715166.1	3572	g21889	i0	50	2.37362637362637	36	18	59.3	0	11	118	56	91	KAK9715166.1 hypothetical protein RND81_06G147200 [Saponaria officinalis]	diamond	432	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Caryophyllaceae	Saponaria	Saponaria officinalis
28480622	28480622	PRJNA1136957_S_NODE_1466_length_520_cov_25.134490_g1371_i0	PRJNA1136957	1466	520	25.13449	130.699348	root	1	Root_unresolved	Root_unresolved	97.1	1.08e-22	NR	KAG0582164.1	3225	g1371	i0	95.3	106.65	43	2	24.8	0	519	391	57	99	KAG0582164.1 hypothetical protein KC19_3G038700 [Ceratodon purpureus]	diamond	55458	97.8	0.992842535787321	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Pseudoditrichales	Ditrichaceae	Ceratodon	Ceratodon purpureus
29186377	29186377	PRJNA1136957_S_NODE_10569_length_263_cov_1.397059_g10472_i0	PRJNA1136957	10569	263	1.397059	3.67426517	Ensete ventricosum	4639	Plants	Plants	42.7	0.0455	NR	RWW46293.1	4639	g10472	i0	41	0.889733840304182	78	31	89	3	20	253	176	238	RWW46293.1 hypothetical protein BHE74_00047805 [Ensete ventricosum]	diamond	234	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Musaceae	Ensete	Ensete ventricosum
30291949	30291949	PRJNA1136957_S_NODE_12112_length_247_cov_1.297872_g12015_i0	PRJNA1136957	12112	247	1.297872	3.20574384	Cinnamomum micranthum f. kanehirae	337451	Plants	Plants	140	1.95e-37	NR	RWR93714.1	337451	g12015	i0	93.3	0.910931174089069	75	5	91.1	0	246	22	378	452	RWR93714.1 hypothetical protein CKAN_02298200 [Cinnamomum micranthum f. kanehirae]	diamond	225	140	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Laurales	Lauraceae	Cinnamomum	Cinnamomum micranthum
30512675	30512675	PRJNA1136957_S_NODE_15553_length_220_cov_5.906832_g15456_i0	PRJNA1136957	15553	220	5.906832	12.9950304	Adiantum nelumboides	2759587	Plants	Plants	95.9	1.2299999999999997e-23	NR	MCO5581356.1	2759587	g15456	i0	68.5	2.98636363636364	73	23	99.5	0	2	220	19	91	MCO5581356.1 hypothetical protein [Adiantum nelumboides]	diamond	657	95.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
30892020	30892020	PRJNA1136957_S_NODE_17814_length_206_cov_1.612245_g17717_i0	PRJNA1136957	17814	206	1.612245	3.3212247	Macadamia integrifolia	60698	Plants	Plants	46.2	0.00138	NR	XP_042508745.1	60698	g17717	i0	40	1.01941747572816	70	29	84.5	2	4	177	680	748	XP_042508745.1 vesicle-fusing ATPase-like [Macadamia integrifolia]	diamond	210	46.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Proteales	Proteaceae	Macadamia	Macadamia integrifolia
31007310	31007310	PRJNA1136957_S_NODE_2794_length_430_cov_1.493261_g2697_i0	PRJNA1136957	2794	430	1.493261	6.4210223	Eukaryota	2759	Plants	Plants	52.4	9.96e-5	NR	KAF8402606.1	13715	g2697	i0	39.3	1.3046511627907	61	37	42.6	0	11	193	275	335	KAF8402606.1 hypothetical protein HHK36_010695 [Tetracentron sinense]	diamond	561	52.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Trochodendrales	Trochodendraceae	Tetracentron	Tetracentron sinense
31871952	31871952	PRJNA1136957_S_NODE_2357_length_453_cov_3.053299_g2260_i0	PRJNA1136957	2357	453	3.053299	13.83144447	Abrus precatorius	3816	Plants	Plants	106	7.89e-24	NR	XP_027355674.1	3816	g2260	i0	66.2	6.5364238410596	74	24	48.3	1	1	219	247	320	XP_027355674.1 E3 ubiquitin-protein ligase RGLG4-like [Abrus precatorius]	diamond	2961	106	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Abrus	Abrus precatorius
31924304	31924304	PRJNA1136957_S_NODE_16577_length_214_cov_1.464516_g16480_i0	PRJNA1136957	16577	214	1.464516	3.13406424	Magnoliopsida	3398	Plants	Plants	65.5	3.45e-11	NR	KAK4769192.1	22666	g16480	i0	48.5	3.49065420560748	68	35	95.3	0	210	7	91	158	KAK4769192.1 hypothetical protein SAY86_027342 [Trapa natans]	diamond	747	65.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Lythraceae	Trapa	Trapa natans
32462365	32462365	PRJNA1136957_S_NODE_17359_length_209_cov_1.346667_g17262_i0	PRJNA1136957	17359	209	1.346667	2.81453403	Magnoliopsida	3398	Plants	Plants	47	7.63e-4	NR	KAI8548184.1	49168	g17262	i0	45.3	14.066985645933	53	24	68.9	1	63	206	411	463	KAI8548184.1 hypothetical protein RHMOL_Rhmol07G0253100 [Rhododendron molle]	diamond	2940	47	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Ericaceae	Rhododendron	Rhododendron molle
32882823	32882823	PRJNA1136957_S_NODE_14260_length_229_cov_1.435294_g14163_i0	PRJNA1136957	14260	229	1.435294	3.28682326	Salvia miltiorrhiza	226208	Plants	Plants	55.8	1.07e-7	NR	XP_057772723.1	226208	g14163	i0	50	10.8078602620087	72	32	89.1	2	11	214	37	108	XP_057772723.1 uncharacterized protein At2g34160-like [Salvia miltiorrhiza]	diamond	2475	55.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Lamiaceae	Salvia	Salvia miltiorrhiza

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