metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax_phylum = "Nematoda"

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
26700022	26700022	PRJNA605033_P_NODE_249201_length_150_cov_1.382609_g247632_i0	PRJNA605033	249201	150	1.382609	2.0739135	Heterodera trifolii	157864	Nematoda	Nematoda	47	3.28e-4	NR	KAL3079934.1	157864	g247632	i0	70.6	0.68	34	9	66	1	51	149	1281	1314	KAL3079934.1 hypothetical protein niasHT_032490 [Heterodera trifolii]	diamond	102	47	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
26953320	26953320	PRJNA605033_P_NODE_161222_length_185_cov_12.380000_g159653_i0	PRJNA605033	161222	185	12.38	22.903	Heterodera trifolii	157864	Nematoda	Nematoda	129	3.5199999999999997e-37	NR	KAL3106525.1	157864	g159653	i0	96.7	1.97837837837838	61	2	98.9	0	3	185	20	80	KAL3106525.1 hypothetical protein niasHT_017582 [Heterodera trifolii]	diamond	366	129	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
29669101	29669101	PRJNA605033_P_NODE_23850_length_302_cov_1.419476_g22289_i0	PRJNA605033	23850	302	1.419476	4.28681752	Heterodera schachtii	97005	Nematoda	Nematoda	95.1	1.43e-20	NR	KAL3077799.1	97005	g22289	i0	73.4	1.05298013245033	64	16	63.6	1	300	109	22	84	KAL3077799.1 hypothetical protein niasHS_011602 [Heterodera schachtii]	diamond	318	95.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera schachtii
31375781	31375781	PRJNA605033_P_NODE_29116_length_281_cov_1.528455_g27550_i0	PRJNA605033	29116	281	1.528455	4.29495855	Heterodera schachtii	97005	Nematoda	Nematoda	89.4	3.94e-20	NR	KAL3101968.1	97005	g27550	i0	68.6	0.747330960854093	70	22	74.7	0	3	212	85	154	KAL3101968.1 hypothetical protein niasHS_003377 [Heterodera schachtii]	diamond	210	89.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera schachtii
32103167	32103167	PRJNA605033_P_NODE_170398_length_180_cov_1.586207_g168829_i0	PRJNA605033	170398	180	1.586207	2.8551726	Heterodera trifolii	157864	Nematoda	Nematoda	97.8	9.83e-25	NR	KAL3118217.1	157864	g168829	i0	86	1.88333333333333	57	8	95	0	9	179	18	74	KAL3118217.1 hypothetical protein niasHT_004099 [Heterodera trifolii]	diamond	339	97.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii

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