metadata: contig_metadata: 4 rows where bioproject = "PRJNA474426" and tax

4 rows where bioproject = "PRJNA474426" 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
10025315	10025315	PRJNA474426_P_NODE_8988_length_360_cov_2.672026_g8783_i0	PRJNA474426	8988	360	2.672026	9.6192936	Cephalobidae	29166	Nematoda	Nematoda	590	5.849999999999998e-164	NTclustered	gi\|76560651\|gb\|DQ145676.1\|	345482	g8783	i0	97.143	96.7277777777778	350	9	97	1	11	360	257	605	Cephalobus sp. JB-67 28S ribosomal RNA gene, partial sequence	blastn	34822	590	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Cephalobidae	Cephalobus	Cephalobus sp. JB-67
18948384	18948384	PRJNA474426_P_NODE_24795_length_196_cov_1.551020_g24590_i0	PRJNA474426	24795	196	1.55102	3.0399992	Rhabditida	6236	Nematoda	Nematoda	339	1.16e-88	NTclustered	gi\|284507052\|dbj\|AB478628.1\|	49351	g24590	i0	100	93.3673469387755	183	0	93	0	14	196	356	174	Zeldia punctata gene for 18S ribosomal RNA, partial sequence	blastn	18300	339	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Cephalobidae	Zeldia	Zeldia punctata
27550085	27550085	PRJNA474426_P_NODE_18684_length_233_cov_1.358696_g18479_i0	PRJNA474426	18684	233	1.358696	3.16576168	Toxocara canis	6265	Nematoda	Nematoda	43.5	0.0178	NR	VDM41077.1	6265	g18479	i0	58.1	0.399141630901288	31	13	39.9	0	140	232	136	166	VDM41077.1 unnamed protein product [Toxocara canis]	diamond	93	43.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
30329535	30329535	PRJNA474426_P_NODE_14352_length_275_cov_0.889381_g14147_i0	PRJNA474426	14352	275	0.889381	2.44579775	Meloidogyne enterolobii	390850	Nematoda	Nematoda	48.1	6.98e-4	NR	CAK5069761.1	390850	g14147	i0	33.3	1.89818181818182	87	52	93.8	3	7	264	728	809	CAK5069761.1 unnamed protein product [Meloidogyne enterolobii]	diamond	522	48.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne enterolobii

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