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

5 rows where analysis = "blastn", bioproject = "PRJDB4941" 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
1284452	1284452	PRJDB4941_P_NODE_18402_length_241_cov_0.812500_g17634_i0	PRJDB4941	18402	241	0.8125	1.958125	Bursaphelenchus xylophilus	6326	Nematoda	Nematoda	268	1.98e-67	NTclustered	gi\|268619095\|gb\|GU130131.1\|	6326	g17634	i0	86.722	79.8174273858921	241	32	100	0	1	241	613	853	Bursaphelenchus xylophilus ATP synthase beta chain mRNA, complete cds	blastn	19236	268	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
3532284	3532284	PRJDB4941_P_NODE_34903_length_168_cov_1.310924_g34135_i0	PRJDB4941	34903	168	1.310924	2.20235232	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.5	0.001	NTclustered	gi\|1972303827\|ref\|NM_075703.5\|	6239	g34135	i0	85.714	4.66071428571429	56	5	32	3	92	145	1550	1604	Caenorhabditis elegans Activated in Blocked Unfolded protein response (abu-12), mRNA	blastn	783	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12763667	12763667	PRJDB4941_P_NODE_16951_length_253_cov_3.465686_g16183_i0	PRJDB4941	16951	253	3.465686	8.76818558	Caenorhabditis elegans	6239	Nematoda	Nematoda	56.5	0.002	NTclustered	gi\|687866156\|emb\|LK927872.1\|	6239	g16183	i0	100	0.237154150197628	30	0	12	0	41	70	80929	80900	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000049	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
16587562	16587562	PRJDB4941_P_NODE_7254_length_453_cov_2.438119_g6486_i0	PRJDB4941	7254	453	2.438119	11.04467907	Strongyloides papillosus	174720	Nematoda	Nematoda	182	5.37e-41	NTclustered	gi\|687022641\|emb\|LM525555.1\|	174720	g6486	i0	75.668	0.82560706401766	374	85	82	5	83	453	465351	465721	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000001	blastn	374	182	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
17862133	17862133	PRJDB4941_P_NODE_2355_length_1098_cov_3.801716_g1751_i0	PRJDB4941	2355	1098	3.801716	41.74284168	Ancylostoma caninum	29170	Nematoda	Nematoda	412	4.449999999999999e-110	NTclustered	gi\|86160923\|gb\|DQ358106.1\|	29170	g1751	i0	73.794	3.89799635701275	1099	264	99	22	12	1098	2638	1552	Ancylostoma caninum paramyosin mRNA, complete cds	blastn	4280	412	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma caninum

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