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

5 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392083	392083	PRJNA340009_P_NODE_28401_length_232_cov_3.655738_g28094_i0	PRJNA340009	28401	232	3.655738	8.48131216	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.021	NTclustered	gi\|690018453\|emb\|LM525691.1\|	174720	g28094	i0	100	0.120689655172414	28	0	12	0	7	34	71051	71078	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000088	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
392595	392595	PRJNA340009_P_NODE_74961_length_162_cov_0.902655_g74654_i0	PRJNA340009	74961	162	0.902655	1.4623011	Ficotylus congestae	458166	Nematoda	Nematoda	65.8	1.73e-6	NTclustered	gi\|154819873\|gb\|EU018047.1\|	458166	g74654	i0	97.368	19.1604938271605	38	1	23	0	120	157	586	623	Ficotylus congestae isolate 460 28S ribosomal RNA gene, partial sequence	blastn	3104	65.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neotylenchidae	Ficotylus	Ficotylus congestae
5495940	5495940	PRJNA340009_P_NODE_51425_length_181_cov_2.303030_g51118_i0	PRJNA340009	51425	181	2.30303	4.1684843	Strongyloides ratti	34506	Nematoda	Nematoda	52.8	0.015	NTclustered	gi\|1376157323\|ref\|XM_024646105.1\|	34506	g51118	i0	100	0.154696132596685	28	0	15	0	21	48	285	312	Strongyloides ratti 7TM GPCR, serpentine receptor class v (Srv) family-containing protein (SRAE_0000024200), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
11273333	11273333	PRJNA340009_P_NODE_66149_length_165_cov_1.672414_g65842_i0	PRJNA340009	66149	165	1.672414	2.7594831	Metazoa	33208	Nematoda	Nematoda	58.4	2.97e-4	NTclustered	gi\|2082287883\|ref\|XM_043081596.1\|	6279	g65842	i0	92.683	2.65454545454545	41	2	24	1	24	63	281	321	Brugia malayi Uncharacterized protein (Bm10604), partial mRNA	blastn	438	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
18243939	18243939	PRJNA340009_P_NODE_55275_length_175_cov_4.047619_g54968_i0	PRJNA340009	55275	175	4.047619	7.08333325	Trichinella spiralis	6334	Nematoda	Nematoda	52.8	0.015	NTclustered	gi\|120407193\|gb\|AC196187.1\|	6334	g54968	i0	100	0.16	28	0	16	0	87	114	117734	117761	Trichinella spiralis BAC clone TS195-17H12 from chromosome unknown, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis

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