metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1108009" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1108009" 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
213053	213053	PRJNA1108009_P_NODE_26001_length_249_cov_0.875000_g25683_i0	PRJNA1108009	26001	249	0.875	2.17875	Nematoda sp. RS-2017	2020970	Nematoda	Nematoda	309	1.21e-79	NTclustered	gi\|1235052990\|gb\|KX372289.1\|	2020970	g25683	i0	90.254	97.6787148594377	236	23	95	0	14	249	2	237	Nematoda sp. RS-2017 isolate VdBRL2014_v1 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial	blastn	24322	309	1	Eukaryota	Opisthokonta	Metazoa	Nematoda					Nematoda sp. RS-2017
6591260	6591260	PRJNA1108009_P_NODE_29466_length_244_cov_0.900585_g29148_i0	PRJNA1108009	29466	244	0.900585	2.1974274	Brugia malayi	6279	Nematoda	Nematoda	154	5.87e-33	NTclustered	gi\|2082294922\|ref\|XM_043074808.1\|	6279	g29148	i0	82.941	0.69672131147541	170	29	70	0	27	196	1659	1490	Brugia malayi ATP-citrate synthase, putative (Bm1778), partial mRNA	blastn	170	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
9140942	9140942	PRJNA1108009_P_NODE_7288_length_510_cov_3.977117_g6973_i0	PRJNA1108009	7288	510	3.977117	20.2832967	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.7e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g6973	i0	81.492	4.42352941176471	362	61	70	6	70	428	37	395	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2256	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
12967056	12967056	PRJNA1108009_P_NODE_31691_length_241_cov_0.916667_g31373_i0	PRJNA1108009	31691	241	0.916667	2.20916747	Panagrolaimus sp. PS1579	310962	Nematoda	Nematoda	291	4.22e-74	NTclustered	gi\|2752116812\|emb\|OZ077771.1\|	310962	g31373	i0	88.655	67.8589211618257	238	27	99	0	1	238	8397	8160	Panagrolaimus sp. PS1579 genome assembly, organelle: mitochondrion	blastn	16354	291	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Panagrolaimus	Panagrolaimus sp. PS1579
18064491	18064491	PRJNA1108009_P_NODE_17195_length_314_cov_3.373444_g16877_i0	PRJNA1108009	17195	314	3.373444	10.59261416	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	167	1.01e-36	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g16877	i0	81.166	42.4777070063694	223	28	69	11	32	247	264	49	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	13338	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus

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