metadata: contig_metadata: 12 rows where bioproject = "PRJNA396510" and tax

12 rows where bioproject = "PRJNA396510" 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
5515622	5515622	PRJNA396510_P_NODE_15225_length_163_cov_0.894737_g15156_i0	PRJNA396510	15225	163	0.894737	1.45842131	Oryza sativa	4530	Plants	Plants	300	4.39e-77	NTclustered	gi\|30725921\|gb\|AC099043.6\|	39947	g15156	i0	100	6.20245398773006	162	0	99	0	2	163	70206	70045	Oryza sativa chromosome 3 BAC OSJNBa0079B15 genomic sequence, complete sequence	blastn	1011	300	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
5515626	5515626	PRJNA396510_P_NODE_16125_length_162_cov_0.902655_g16056_i0	PRJNA396510	16125	162	0.902655	1.4623011	Malus domestica	3750	Plants	Plants	52.8	0.013	NTclustered	gi\|2810943380\|gb\|CP168778.1\|	3750	g16056	i0	100	0.172839506172839	28	0	17	0	18	45	20799741	20799714	Malus domestica cultivar Golden Delicious chromosome 14	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Malus	Malus domestica
10615802	10615802	PRJNA396510_P_NODE_11129_length_181_cov_1.515152_g11060_i0	PRJNA396510	11129	181	1.515152	2.74242512	Triticum aestivum	4565	Plants	Plants	335	1.36e-87	NTclustered	gi\|2123746588\|ref\|XR_006435168.1\|	4565	g11060	i0	100	2	181	0	100	0	1	181	5608	5428	PREDICTED: Triticum aestivum homeobox protein cut-like 1 (LOC123072473), transcript variant X4, misc_RNA	blastn	362	335	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
14440816	14440816	PRJNA396510_P_NODE_14232_length_165_cov_0.879310_g14163_i0	PRJNA396510	14232	165	0.87931	1.4508615	Cicer arietinum	3827	Plants	Plants	305	9.59e-79	NTclustered	gi\|1535865752\|ref\|XM_004494231.3\|	3827	g14163	i0	100	53.3393939393939	165	0	100	0	1	165	105	269	PREDICTED: Cicer arietinum 60S ribosomal protein L35a-1-like (LOC101514440), mRNA	blastn	8801	305	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Cicer	Cicer arietinum
21480833	21480833	PRJNA396510_P_NODE_15737_length_162_cov_0.902655_g15668_i0	PRJNA396510	15737	162	0.902655	1.4623011	Poaceae	4479	Plants	Plants	300	4.36e-77	NTclustered	gi\|2155905707\|emb\|OV049916.1\|	4529	g15668	i0	100	101	162	0	100	0	1	162	49167	49006	Oryza rufipogon genome assembly, organelle: plastid:chloroplast	blastn	16362	300	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza rufipogon
22088429	22088429	PRJNA396510_P_NODE_16678_length_161_cov_0.910714_g16609_i0	PRJNA396510	16678	161	0.910714	1.46624954	Allium sativum	4682	Plants	Plants	171	3.54e-38	NTclustered	gi\|2221770600\|gb\|MK770769.1\|	4682	g16609	i0	93.103	0.720496894409938	116	8	72	0	1	116	116	1	Allium sativum satellite AsatSAT189 sequence	blastn	116	171	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asparagales	Amaryllidaceae	Allium	Allium sativum
26617293	26617293	PRJNA396510_P_NODE_11061_length_182_cov_0.894737_g10992_i0	PRJNA396510	11061	182	0.894737	1.62842134	Magnoliopsida	3398	Plants	Plants	44.3	0.00478	NR	RVW99369.1	29760	g10992	i0	53.2	3.0989010989011	47	22	77.5	0	163	23	530	576	RVW99369.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Vitis vinifera]	diamond	564	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
26917195	26917195	PRJNA396510_P_NODE_5662_length_244_cov_1.041026_g5593_i0	PRJNA396510	5662	244	1.041026	2.54010344	Tarenaya hassleriana	28532	Plants	Plants	45.8	0.00199	NR	XP_010548418.1	28532	g5593	i0	37.2	0.959016393442623	78	39	92.2	3	237	13	100	170	XP_010548418.1 PREDICTED: protein DCL, chloroplastic-like [Tarenaya hassleriana]	diamond	234	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Cleomaceae	Tarenaya	Tarenaya hassleriana
29285756	29285756	PRJNA396510_P_NODE_11089_length_181_cov_2.083333_g11020_i0	PRJNA396510	11089	181	2.083333	3.77083273	Adiantum nelumboides	2759587	Plants	Plants	53.9	1.73e-6	NR	MCO5553831.1	2759587	g11020	i0	53.8	16.3259668508287	39	18	64.6	0	119	3	60	98	MCO5553831.1 hypothetical protein [Adiantum nelumboides]	diamond	2955	53.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
30170011	30170011	PRJNA396510_P_NODE_15352_length_163_cov_0.894737_g15283_i0	PRJNA396510	15352	163	0.894737	1.45842131	Vitis vinifera	29760	Plants	Plants	63.5	5.8e-10	NR	RVW92637.1	29760	g15283	i0	64.3	5.50306748466258	42	15	77.3	0	1	126	722	763	RVW92637.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Vitis vinifera]	diamond	897	63.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
30801999	30801999	PRJNA396510_P_NODE_6294_length_233_cov_0.804348_g6225_i0	PRJNA396510	6294	233	0.804348	1.87413084	Triticum turgidum subsp. durum	4567	Plants	Plants	43.5	0.0174	NR	VAH95209.1	4567	g6225	i0	45.8	0.618025751072961	48	25	60.5	1	193	53	94	141	VAH95209.1 unnamed protein product [Triticum turgidum subsp. durum]	diamond	144	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum turgidum
32225187	32225187	PRJNA396510_P_NODE_10418_length_187_cov_0.978261_g10349_i0	PRJNA396510	10418	187	0.978261	1.82934807	Oryza sativa Japonica Group	39947	Plants	Plants	52.8	5.26e-6	NR	BAF23632.1	39947	g10349	i0	46.8	2.82352941176471	47	25	75.4	0	142	2	286	332	BAF23632.1 Os08g0389500 [Oryza sativa Japonica Group]	diamond	528	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza 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);;