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

5 rows where analysis = "blastn", bioproject = "PRJNA700095" 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
5786717	5786717	PRJNA700095_P_NODE_39145_length_278_cov_1.453659_g37881_i0	PRJNA700095	39145	278	1.453659	4.04117202	Nematoda environmental sample	554024	Nematoda	Nematoda	472	1.6599999999999998e-128	NTclustered	gi\|2743156117\|gb\|PP910122.1\|	554024	g37881	i0	97.802	66.158273381295	273	6	98	0	6	278	580	308	Nematoda environmental sample isolate SN_I large subunit ribosomal RNA gene, partial sequence	blastn	18392	472	1	Eukaryota	Opisthokonta	Metazoa	Nematoda					Nematoda environmental sample
10887184	10887184	PRJNA700095_P_NODE_20609_length_388_cov_1.587302_g19346_i0	PRJNA700095	20609	388	1.587302	6.15873176	Strongyloides ratti	34506	Nematoda	Nematoda	363	1.51e-95	NTclustered	gi\|1376148845\|ref\|XM_024642710.1\|	34506	g19346	i0	84.658	94.5309278350515	365	54	94	2	25	388	1316	953	Strongyloides ratti Tubulin beta-2A chain (SRAE_2000390300), partial mRNA	blastn	36678	363	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
12663766	12663766	PRJNA700095_P_NODE_64730_length_241_cov_2.339286_g63466_i0	PRJNA700095	64730	241	2.339286	5.63767926	Metazoa	33208	Nematoda	Nematoda	73.1	1.67e-8	NTclustered	gi\|256251567\|emb\|FM207826.1\|	6313	g63466	i0	80.645	0.771784232365145	93	18	39	0	148	240	434	342	Angiostrongylus cantonensis partial mRNA ORF1 for Putative protein, clone 00012D12	blastn	186	73.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Angiostrongylus	Angiostrongylus cantonensis
15985968	15985968	PRJNA700095_P_NODE_70973_length_200_cov_5.874016_g69708_i0	PRJNA700095	70973	200	5.874016	11.748032	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.017	NTclustered	gi\|690020769\|emb\|LM528349.1\|	174720	g69708	i0	100	0.14	28	0	14	0	12	39	805	832	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0002678	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
19810052	19810052	PRJNA700095_P_NODE_24976_length_344_cov_1.701107_g23712_i0	PRJNA700095	24976	344	1.701107	5.85180808	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.033	NTclustered	gi\|413006602\|emb\|Z83230.2\|	6239	g23712	i0	100	0.162790697674419	28	0	8	0	87	114	2024	1997	Caenorhabditis elegans Cosmid F56A8, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans

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