metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA966993" 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
6045143	6045143	PRJNA966993_P_NODE_14705_length_546_cov_2.940803_g14264_i0	PRJNA966993	14705	546	2.940803	16.05678438	Strongyloides ratti	34506	Nematoda	Nematoda	268	4.9e-67	NTclustered	gi\|1376144539\|ref\|XM_024652732.1\|	34506	g14264	i0	79.328	16.8095238095238	387	76	71	4	60	444	450	66	Strongyloides ratti 40S ribosomal protein S14 (SRAE_2000174400), partial mRNA	blastn	9178	268	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
6045347	6045347	PRJNA966993_P_NODE_38185_length_348_cov_1.120000_g37733_i0	PRJNA966993	38185	348	1.12	3.8976	Caenorhabditis briggsae	6238	Nematoda	Nematoda	52.8	0.033	NTclustered	gi\|11094894\|gb\|AC084444.1\|AC084444	6238	g37733	i0	100	0.160919540229885	28	0	8	0	49	76	65616	65589	Caenorhabditis briggsae cosmid CB014E04, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
12421696	12421696	PRJNA966993_P_NODE_90730_length_246_cov_0.890173_g90278_i0	PRJNA966993	90730	246	0.890173	2.18982558	Strongyloides ratti	34506	Nematoda	Nematoda	63.9	1.03e-5	NTclustered	gi\|1376143263\|ref\|XM_024652000.1\|	34506	g90278	i0	82.432	0.300813008130081	74	11	30	2	157	229	618	546	Strongyloides ratti V-type proton ATPase subunit D (SRAE_2000109000), partial mRNA	blastn	74	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
13696106	13696106	PRJNA966993_P_NODE_75191_length_262_cov_1.629630_g74739_i0	PRJNA966993	75191	262	1.62963	4.2696306	Strongyloides ratti	34506	Nematoda	Nematoda	196	1.04e-45	NTclustered	gi\|1376147069\|ref\|XM_024654161.1\|	34506	g74739	i0	80.377	16.5419847328244	265	46	100	6	1	262	955	1216	Strongyloides ratti Adaptor protein complex 1/2, beta subunit (SRAE_2000301800), partial mRNA	blastn	4334	196	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
16245015	16245015	PRJNA966993_P_NODE_44573_length_323_cov_1.756000_g44121_i0	PRJNA966993	44573	323	1.756	5.67188	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.008	NTclustered	gi\|412975667\|emb\|FO080196.2\|	6239	g44121	i0	100	0.269349845201238	29	0	9	0	209	237	2431	2403	Caenorhabditis elegans Cosmid F42G9, complete sequence	blastn	87	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
20392004	20392004	PRJNA966993_P_NODE_80616_length_253_cov_1.711111_g80164_i0	PRJNA966993	80616	253	1.711111	4.32911083	Caenorhabditis	6237	Nematoda	Nematoda	73.1	1.76e-8	NTclustered	gi\|1972266638\|ref\|NM_068494.9\|	6239	g80164	i0	97.619	8.22529644268775	42	1	17	0	143	184	104	63	Caenorhabditis elegans Small ribosomal subunit protein eS25 (rps-25), mRNA	blastn	2081	73.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
22619727	22619727	PRJNA966993_P_NODE_91138_length_246_cov_0.890173_g90686_i0	PRJNA966993	91138	246	0.890173	2.18982558	Brugia malayi	6279	Nematoda	Nematoda	65.8	2.85e-6	NTclustered	gi\|2082282502\|ref\|XM_001897206.2\|	6279	g90686	i0	88.679	0.5	53	6	22	0	185	237	1043	1095	Brugia malayi uncharacterized protein (Bm2917), partial mRNA	blastn	123	65.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
23894424	23894424	PRJNA966993_P_NODE_11859_length_610_cov_15.543762_g11430_i0	PRJNA966993	11859	610	15.543762	94.8169482	Caenorhabditis remanei	31234	Nematoda	Nematoda	226	3.369999999999999e-54	NTclustered	gi\|2445366694\|ref\|XM_003110903.2\|	31234	g11430	i0	78.797	23.4016393442623	349	64	56	8	191	534	398	55	Caenorhabditis remanei uncharacterized protein (GCK72_010604), partial mRNA	blastn	14275	226	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
23894645	23894645	PRJNA966993_P_NODE_38539_length_346_cov_1.589744_g38087_i0	PRJNA966993	38539	346	1.589744	5.50051424	Heterodera glycines	51029	Nematoda	Nematoda	220	8.479999999999999e-53	NTclustered	gi\|2912264212\|gb\|PQ858779.1\|	51029	g38087	i0	78.551	15.8526011560694	345	66	99	8	5	345	1031	691	Heterodera glycines Guanine nucleotide-binding protein G(o) subunit alpha (goa-1) mRNA, complete cds	blastn	5485	220	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera glycines

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