metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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
312901	312901	PRJNA1166865_P_NODE_42181_length_336_cov_2.923954_g41940_i0	PRJNA1166865	42181	336	2.923954	9.82448544	Caenorhabditis elegans	6239	Nematoda	Nematoda	621	1.9299999999999997e-173	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g41940	i0	100	99.6398809523809	336	0	100	0	1	336	28543	28878	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	33479	621	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
4139111	4139111	PRJNA1166865_P_NODE_18504_length_499_cov_1.626761_g18263_i0	PRJNA1166865	18504	499	1.626761	8.11753739	Caenorhabditis briggsae	6238	Nematoda	Nematoda	152	4.6699999999999996e-32	NTclustered	gi\|11094977\|gb\|AC084527.1\|CBRG21F09	6238	g18263	i0	80.808	0.793587174348697	198	34	39	4	285	480	22407	22212	Caenorhabditis briggsae cosmid G21F09, complete sequence	blastn	396	152	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
4140759	4140759	PRJNA1166865_P_NODE_85724_length_246_cov_0.890173_g85483_i0	PRJNA1166865	85724	246	0.890173	2.18982558	Caenorhabditis elegans	6239	Nematoda	Nematoda	455	1.4500000000000002e-123	NTclustered	gi\|1972266898\|ref\|NM_001028105.7\|	6239	g85483	i0	100	7.98780487804878	246	0	100	0	1	246	2492	2737	Caenorhabditis elegans Vitellogenin-6 (vit-6), partial mRNA	blastn	1965	455	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6690504	6690504	PRJNA1166865_P_NODE_31106_length_386_cov_2.440895_g30865_i0	PRJNA1166865	31106	386	2.440895	9.4218547	Caenorhabditis elegans	6239	Nematoda	Nematoda	708	0	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g30865	i0	99.741	84.3834196891192	386	1	100	0	1	386	26592	26977	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	32572	708	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6690598	6690598	PRJNA1166865_P_NODE_34926_length_366_cov_2.040956_g34685_i0	PRJNA1166865	34926	366	2.040956	7.46989896	Strongyloides ratti	34506	Nematoda	Nematoda	161	5.529999999999998e-35	NTclustered	gi\|1376135061\|ref\|XM_024647529.1\|	34506	g34685	i0	76.568	1.8879781420765	303	65	82	6	7	306	535	834	Strongyloides ratti BcDNA.GM09489 (SRAE_1000066900), partial mRNA	blastn	691	161	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
7417478	7417478	PRJNA1166865_P_NODE_48446_length_316_cov_16.510288_g48205_i0	PRJNA1166865	48446	316	16.510288	52.17251008	Caenorhabditis	6237	Nematoda	Nematoda	63.9	1.37e-5	NTclustered	gi\|1972228534\|ref\|NM_001316854.4\|	6239	g48205	i0	95	0.493670886075949	40	2	13	0	31	70	47	86	Caenorhabditis elegans 60S ribosomal protein L41 (rpl-41.2), mRNA	blastn	156	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11790917	11790917	PRJNA1166865_P_NODE_20830_length_470_cov_2.806045_g20589_i0	PRJNA1166865	20830	470	2.806045	13.1884115	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	193	2.58e-44	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g20589	i0	77.848	19.7404255319149	316	66	67	3	41	354	16	329	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	9278	193	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
13792996	13792996	PRJNA1166865_P_NODE_89411_length_244_cov_0.900585_g89170_i0	PRJNA1166865	89411	244	0.900585	2.1974274	Caenorhabditis	6237	Nematoda	Nematoda	451	1.86e-122	NTclustered	gi\|2460759835\|gb\|OQ645709.1\|	6239	g89170	i0	100	101	244	0	100	0	1	244	343	100	Caenorhabditis elegans strain H60A small subunit ribosomal RNA gene, partial sequence	blastn	24644	451	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
17617333	17617333	PRJNA1166865_P_NODE_46814_length_321_cov_1.907258_g46573_i0	PRJNA1166865	46814	321	1.907258	6.12229818	Caenorhabditis	6237	Nematoda	Nematoda	593	3.9899999999999986e-165	NTclustered	gi\|356605872\|gb\|JN636061.1\|	6238	g46573	i0	100	98.8629283489097	321	0	100	0	1	321	4935	4615	Caenorhabditis briggsae 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	31735	593	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
19439766	19439766	PRJNA1166865_P_NODE_80556_length_248_cov_1.680000_g80315_i0	PRJNA1166865	80556	248	1.68	4.1664	Caenorhabditis remanei	31234	Nematoda	Nematoda	60.2	1.34e-4	NTclustered	gi\|2445352199\|ref\|XM_003095007.2\|	31234	g80315	i0	81.579	0.419354838709677	76	10	30	4	175	248	205	278	Caenorhabditis remanei uncharacterized protein (GCK72_002938), partial mRNA	blastn	104	60.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
24538878	24538878	PRJNA1166865_P_NODE_4540_length_951_cov_11.276765_g4378_i0	PRJNA1166865	4540	951	11.276765	107.24203515	Diplogastrellus sp. VS-2014	1538693	Nematoda	Nematoda	401	8.289999999999999e-107	NTclustered	gi\|675118831\|gb\|KJ877295.1\|	1538693	g4378	i0	77.171	56.7644584647739	714	147	74	16	78	783	43	748	Diplogastrellus sp. VS-2014 strain RS5608 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	53983	401	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus sp. VS-2014

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