metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA749559" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA749559" and tax_kingdom = "Viridiplantae"

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
24952480	24952480	PRJNA749559_P_NODE_5020_length_201_cov_0.914286_g4950_i0	PRJNA749559	5020	201	0.914286	1.83771486	Sphagnum compactum	128190	Plants	Plants	102	6.3299999999999995e-25	NR	CAM6031714.1	128190	g4950	i0	76.9	1.95522388059702	65	15	97	0	5	199	136	200	CAM6031714.1 unnamed protein product, partial [Sphagnum compactum]	diamond	393	102	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum compactum
27052863	27052863	PRJNA749559_P_NODE_4902_length_202_cov_0.907801_g4832_i0	PRJNA749559	4902	202	0.907801	1.83375802	Volvox carteri f. nagariensis	3068	Plants	Plants	51.6	1.65e-5	NR	XP_002948017.1	3068	g4832	i0	39.1	0.95049504950495	64	39	95	0	5	196	192	255	XP_002948017.1 uncharacterized protein VOLCADRAFT_88209 [Volvox carteri f. nagariensis]	diamond	192	51.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
27747955	27747955	PRJNA749559_P_NODE_3044_length_248_cov_1.711230_g2974_i0	PRJNA749559	3044	248	1.71123	4.2438504	Citrus unshiu	55188	Plants	Plants	79.3	5.22e-15	NR	GAY34710.1	55188	g2974	i0	53.8	2.90322580645161	80	34	94.4	2	14	247	533	611	GAY34710.1 hypothetical protein CUMW_012880 [Citrus unshiu]	diamond	720	79.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus unshiu
27915437	27915437	PRJNA749559_P_NODE_3285_length_238_cov_1.446328_g3215_i0	PRJNA749559	3285	238	1.446328	3.44226064	Streptophyta	35493	Plants	Plants	72.8	1.64e-13	NR	PTQ48915.1	3197	g3215	i0	45.5	6.85714285714286	77	40	97.1	1	5	235	79	153	PTQ48915.1 hypothetical protein MARPO_0004s0172 [Marchantia polymorpha]	diamond	1632	72.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Marchantiopsida	Marchantiales	Marchantiaceae	Marchantia	Marchantia polymorpha
28325881	28325881	PRJNA749559_P_NODE_3966_length_214_cov_1.143791_g3896_i0	PRJNA749559	3966	214	1.143791	2.44771274	Magnoliopsida	3398	Plants	Plants	97.1	1.48e-21	NR	KAJ3695967.1	13579	g3896	i0	59.1	11.481308411215	66	27	92.5	0	213	16	277	342	KAJ3695967.1 hypothetical protein LUZ60_001344 [Juncus effusus]	diamond	2457	97.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Juncaceae	Juncus	Juncus effusus
29273048	29273048	PRJNA749559_P_NODE_4089_length_210_cov_1.436242_g4019_i0	PRJNA749559	4089	210	1.436242	3.0161082	Chlorophyta	3041	Plants	Plants	52.8	1.76e-6	NR	XP_003059180.1	564608	g4019	i0	48.5	1.9	68	30	97.1	1	209	6	18	80	XP_003059180.1 uncharacterized protein MICPUCDRAFT_49622 [Micromonas pusilla CCMP1545]	diamond	399	52.8	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Mamiellaceae	Micromonas	Micromonas pusilla
29326351	29326351	PRJNA749559_P_NODE_1669_length_343_cov_1.347518_g1599_i0	PRJNA749559	1669	343	1.347518	4.62198674	Nymphaea colorata	210225	Plants	Plants	137	6.29e-39	NR	VVW86319.1	210225	g1599	i0	60.4	5.82507288629738	111	44	97.1	0	338	6	1	111	VVW86319.1 unnamed protein product, partial [Nymphaea colorata]	diamond	1998	137	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
29863172	29863172	PRJNA749559_P_NODE_4951_length_202_cov_0.907801_g4881_i0	PRJNA749559	4951	202	0.907801	1.83375802	Haematococcus lacustris	44745	Plants	Plants	43.1	0.0158	NR	KAJ9515922.1	44745	g4881	i0	39.6	0.787128712871287	53	32	78.7	0	201	43	106	158	KAJ9515922.1 hypothetical protein QJQ45_016906, partial [Haematococcus lacustris]	diamond	159	43.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
31348475	31348475	PRJNA749559_P_NODE_3596_length_227_cov_1.156627_g3526_i0	PRJNA749559	3596	227	1.156627	2.62554329	Eragrostis curvula	38414	Plants	Plants	53.5	4.54e-6	NR	TVU50040.1	38414	g3526	i0	36	2.49779735682819	75	48	99.1	0	226	2	17	91	TVU50040.1 hypothetical protein EJB05_01394, partial [Eragrostis curvula]	diamond	567	53.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Eragrostis	Eragrostis curvula
31822625	31822625	PRJNA749559_P_NODE_3677_length_224_cov_1.539877_g3607_i0	PRJNA749559	3677	224	1.539877	3.44932448	Quillaja saponaria	32244	Plants	Plants	73.2	3.58e-13	NR	KAJ7947068.1	32244	g3607	i0	53.6	2.79910714285714	69	32	92.4	0	224	18	212	280	KAJ7947068.1 Cysteine Protease [Quillaja saponaria]	diamond	627	73.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Quillajaceae	Quillaja	Quillaja saponaria
32676355	32676355	PRJNA749559_P_NODE_3080_length_246_cov_3.367568_g3010_i0	PRJNA749559	3080	246	3.367568	8.28421728	Sphagnum balticum	128184	Plants	Plants	100	9.06e-25	NR	CAM6005785.1	128184	g3010	i0	72.7	1.64634146341463	66	18	80.5	0	48	245	8	73	CAM6005785.1 unnamed protein product [Sphagnum balticum]	diamond	405	100	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum

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