metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA951810" 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
1263643	1263643	PRJNA951810_P_NODE_30121_length_365_cov_1.924658_g29779_i0	PRJNA951810	30121	365	1.924658	7.0250017	Caenorhabditis	6237	Nematoda	Nematoda	272	2.4399999999999993e-68	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g29779	i0	87.395	64.7041095890411	238	28	65	2	1	237	1071	1307	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	23617	272	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
7641226	7641226	PRJNA951810_P_NODE_150086_length_258_cov_2.227027_g149741_i0	PRJNA951810	150086	258	2.227027	5.74572966	Opisthokonta	33154	Nematoda	Nematoda	209	1.32e-49	NTclustered	gi\|2707541074\|ref\|XM_013442878.2\|	51031	g149741	i0	81.323	54.2480620155039	257	48	99	0	1	257	970	1226	Necator americanus uncharacterized protein (RB195_004942), partial mRNA	blastn	13996	209	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
8589578	8589578	PRJNA951810_P_NODE_175287_length_237_cov_4.615854_g174942_i0	PRJNA951810	175287	237	4.615854	10.93957398	Caenorhabditis briggsae	6238	Nematoda	Nematoda	167	7.279999999999999e-37	NTclustered	gi\|2158424922\|ref\|XM_045237347.1\|	6238	g174942	i0	80	9.57805907172996	235	40	98	7	5	236	1927	2157	Caenorhabditis briggsae Protein CBR-EFT-2 (Cbr-eft-2), partial mRNA	blastn	2270	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
13690687	13690687	PRJNA951810_P_NODE_24511_length_406_cov_3.915916_g24171_i0	PRJNA951810	24511	406	3.915916	15.89861896	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.11e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g24171	i0	81.492	5.14285714285714	362	61	88	6	4	362	37	395	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2088	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
16238965	16238965	PRJNA951810_P_NODE_150273_length_258_cov_1.281081_g149928_i0	PRJNA951810	150273	258	1.281081	3.30518898	Caenorhabditis elegans	6239	Nematoda	Nematoda	477	3.2699999999999985e-130	NTclustered	gi\|1734336796\|ref\|NM_074105.4\|	6239	g149928	i0	100	3.0077519379845	258	0	100	0	1	258	370	113	Caenorhabditis elegans Carboxylic ester hydrolase (cest-1.1), mRNA	blastn	776	477	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23887667	23887667	PRJNA951810_P_NODE_100059_length_293_cov_2.827273_g99715_i0	PRJNA951810	100059	293	2.827273	8.28390989	Strongyloides ratti	34506	Nematoda	Nematoda	213	1.18e-50	NTclustered	gi\|1376148845\|ref\|XM_024642710.1\|	34506	g99715	i0	80.212	10.740614334471	283	56	97	0	1	283	351	633	Strongyloides ratti Tubulin beta-2A chain (SRAE_2000390300), partial mRNA	blastn	3147	213	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti

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