metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA474426" 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
17674537	17674537	PRJNA474426_P_NODE_28974_length_179_cov_1.269231_g28769_i0	PRJNA474426	28974	179	1.269231	2.27192349	Eukaryota	2759	Plants	Plants	100	8.379999999999999e-23	NR	GEV93424.1	118510	g28769	i0	87.5	8.44692737430168	56	7	93.9	0	177	10	174	229	GEV93424.1 cytochrome c oxidase subunit 1, mitochondrial [Tanacetum cinerariifolium]	diamond	1512	101	0.99009900990099	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
26601132	26601132	PRJNA474426_P_NODE_34701_length_164_cov_1.704348_g34496_i0	PRJNA474426	34701	164	1.704348	2.79513072	Nymphaea colorata	210225	Plants	Plants	41.2	0.0371	NR	VVW89273.1	210225	g34496	i0	68	0.457317073170732	25	8	45.7	0	4	78	50	74	VVW89273.1 unnamed protein product, partial [Nymphaea colorata]	diamond	75	41.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
27960662	27960662	PRJNA474426_P_NODE_8405_length_372_cov_5.956656_g8200_i0	PRJNA474426	8405	372	5.956656	22.15876032	Heracleum sosnowskyi	360622	Plants	Plants	52	8.94e-5	NR	KAK1367395.1	360622	g8200	i0	45.1	0.411290322580645	51	28	41.1	0	71	223	353	403	KAK1367395.1 hypothetical protein POM88_042956 [Heracleum sosnowskyi]	diamond	153	52	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Apiales	Apiaceae	Heracleum	Heracleum sosnowskyi
28687136	28687136	PRJNA474426_P_NODE_22167_length_210_cov_2.633540_g21962_i0	PRJNA474426	22167	210	2.63354	5.530434	Fraxinus pennsylvanica	56036	Plants	Plants	95.9	4.83e-21	NR	CAI9762998.1	56036	g21962	i0	77	0.871428571428571	61	14	87.1	0	192	10	897	957	CAI9762998.1 unnamed protein product [Fraxinus pennsylvanica]	diamond	183	95.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Fraxinus	Fraxinus pennsylvanica
28750043	28750043	PRJNA474426_P_NODE_36087_length_163_cov_0.877193_g35882_i0	PRJNA474426	36087	163	0.877193	1.42982459	Tanacetum cinerariifolium	118510	Plants	Plants	86.7	4.29e-18	NR	GEV56738.1	118510	g35882	i0	93.6	1.73006134969325	47	3	86.5	0	22	162	1203	1249	GEV56738.1 cytochrome b, mitochondrial [Tanacetum cinerariifolium]	diamond	282	86.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
30644794	30644794	PRJNA474426_P_NODE_25413_length_193_cov_1.812500_g25208_i0	PRJNA474426	25413	193	1.8125	3.498125	Glycine max	3847	Plants	Plants	40.8	0.0364	NR	KAH1213436.1	3847	g25208	i0	47.2	0.823834196891192	53	23	74.6	2	14	157	53	105	KAH1213436.1 hypothetical protein GmHk_14G041403 [Glycine max]	diamond	159	40.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Glycine	Glycine max

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