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

5 rows where analysis = "diamond", bioproject = "PRJNA782551" 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
30306876	30306876	PRJNA782551_P_NODE_23072_length_243_cov_0.905882_g22950_i0	PRJNA782551	23072	243	0.905882	2.20129326	Aphelenchoides bicaudatus	293665	Nematoda	Nematoda	54.7	2.31e-6	NR	KAI6192198.1	293665	g22950	i0	39.2	2.7283950617284	74	44	91.4	1	230	9	1331	1403	KAI6192198.1 FYVE zinc finger family protein [Aphelenchoides bicaudatus]	diamond	663	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus
31042732	31042732	PRJNA782551_P_NODE_16455_length_250_cov_1.581921_g16333_i0	PRJNA782551	16455	250	1.581921	3.9548025	Rhabditida	6236	Nematoda	Nematoda	82	5.39e-16	NR	XP_024510172.1	34506	g16333	i0	47.5	3.948	80	42	96	0	11	250	132	211	XP_024510172.1 Fads2 protein [Strongyloides ratti]	diamond	987	82	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
31358605	31358605	PRJNA782551_P_NODE_19916_length_246_cov_1.335260_g19794_i0	PRJNA782551	19916	246	1.33526	3.2847396	root	1	Root_unresolved	Root_unresolved	164	1.6600000000000001e-49	NR	NP_502959.1	6239	g19794	i0	93.9	515.243902439024	82	5	100	0	246	1	12	93	NP_502959.1 Ras-like GTP-binding protein rhoA [Caenorhabditis elegans]	diamond	126750	165	0.993939393939394	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
32181116	32181116	PRJNA782551_P_NODE_21638_length_244_cov_1.391813_g21516_i0	PRJNA782551	21638	244	1.391813	3.39602372	Onchocercidae	6296	Nematoda	Nematoda	58.5	1.03e-7	NR	XP_042936265.1	6279	g21516	i0	36	4.46311475409836	75	48	92.2	0	244	20	474	548	XP_042936265.1 Uncharacterized protein BM_BM5333 [Brugia malayi]	diamond	1089	58.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
32812514	32812514	PRJNA782551_P_NODE_5100_length_413_cov_1.064706_g4978_i0	PRJNA782551	5100	413	1.064706	4.39723578	Metazoa	33208	Nematoda	Nematoda	120	1.15e-28	NR	KAH7728030.1	70226	g4978	i0	58.8	4.43825665859564	97	37	70.5	1	121	411	752	845	KAH7728030.1 Protein MARS-1 b [Aphelenchoides avenae]	diamond	1833	120	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae

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