metadata: contig_metadata: 26 rows where bioproject = "PRJNA1002570" and tax

26 rows where bioproject = "PRJNA1002570" 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
152343	152343	PRJNA1002570_P_NODE_28361_length_271_cov_2.565657_g28166_i0	PRJNA1002570	28361	271	2.565657	6.95293047	Caenorhabditis elegans	6239	Nematoda	Nematoda	501	2.05e-137	NTclustered	gi\|1972257122\|ref\|NM_001393237.1\|	6239	g28166	i0	100	3.00738007380074	271	0	100	0	1	271	16	286	Caenorhabditis elegans Multifunctional methyltransferase subunit TRM112-like protein (C04H5.1), partial mRNA	blastn	815	501	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
2702538	2702538	PRJNA1002570_P_NODE_25623_length_278_cov_1.502439_g25428_i0	PRJNA1002570	25623	278	1.502439	4.17678042	Caenorhabditis elegans	6239	Nematoda	Nematoda	514	2.7199999999999996e-141	NTclustered	gi\|1171505\|emb\|Z68341.1\|	6239	g25428	i0	100	4.12589928057554	278	0	100	0	1	278	19624	19901	Caenorhabditis elegans Cosmid F01G4, complete sequence	blastn	1147	514	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
3978958	3978958	PRJNA1002570_P_NODE_42784_length_242_cov_3.562130_g42589_i0	PRJNA1002570	42784	242	3.56213	8.6203546	Caenorhabditis elegans	6239	Nematoda	Nematoda	387	5.26e-103	NTclustered	gi\|1972261269\|ref\|NM_001027787.5\|	6239	g42589	i0	95.455	3	242	11	100	0	1	242	313	72	Caenorhabditis elegans Glycolipid transfer protein domain-containing protein (Y82E9BR.14), partial mRNA	blastn	726	387	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
5255069	5255069	PRJNA1002570_P_NODE_20105_length_290_cov_1.419355_g19910_i0	PRJNA1002570	20105	290	1.419355	4.1161295	Caenorhabditis elegans	6239	Nematoda	Nematoda	531	2.83e-146	NTclustered	gi\|1041319\|emb\|Z66512.1\|	6239	g19910	i0	99.655	3.42068965517241	290	1	100	0	1	290	4282	4571	Caenorhabditis elegans Cosmid F52H3, complete sequence	blastn	992	531	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
6530763	6530763	PRJNA1002570_P_NODE_43166_length_242_cov_0.911243_g42971_i0	PRJNA1002570	43166	242	0.911243	2.20520806	Caenorhabditis elegans	6239	Nematoda	Nematoda	448	2.3799999999999995e-121	NTclustered	gi\|735951\|emb\|X76112.1\|	6239	g42971	i0	100	6.90082644628099	242	0	100	0	1	242	265	24	C.elegans mRNA for ADP/ATP translocase	blastn	1670	448	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7805156	7805156	PRJNA1002570_P_NODE_44827_length_236_cov_3.662577_g44632_i0	PRJNA1002570	44827	236	3.662577	8.64368172	Caenorhabditis elegans	6239	Nematoda	Nematoda	436	4.999999999999999e-118	NTclustered	gi\|351064155\|emb\|FO081565.1\|	6239	g44632	i0	100	4	236	0	100	0	1	236	1938	2173	Caenorhabditis elegans Cosmid T02B11, complete sequence	blastn	944	436	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
9079789	9079789	PRJNA1002570_P_NODE_26128_length_277_cov_1.426471_g25933_i0	PRJNA1002570	26128	277	1.426471	3.95132467	Caenorhabditis elegans	6239	Nematoda	Nematoda	507	4.53e-139	NTclustered	gi\|27543076\|gb\|AY171204.1\|	6239	g25933	i0	99.639	100.036101083032	277	1	100	0	1	277	2876	3152	Caenorhabditis elegans isolate PB303 cytochrome oxidase subunit III (COIII) gene, partial cds; tRNA-Thr gene, complete sequence; NADH dehydrogenase subunit 4 (ND4) and cytochrome oxidase subunit I (COI) genes, complete cds; tRNA-Cys, tRNA-Met, tRNA-Asp, and tRNA-Gly genes, complete sequence; cytochrome oxidase subunit II (COII) gene, complete cds; tRNA-His gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial genes for mitochondrial products	blastn	27710	507	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11630819	11630819	PRJNA1002570_P_NODE_20870_length_288_cov_2.655814_g20675_i0	PRJNA1002570	20870	288	2.655814	7.64874432	Caenorhabditis elegans	6239	Nematoda	Nematoda	532	7.8e-147	NTclustered	gi\|1831521046\|ref\|NM_077611.6\|	6239	g20675	i0	100	4.10069444444444	288	0	100	0	1	288	415	702	Caenorhabditis elegans Peptidase_M16 domain-containing protein (ucr-2.1), mRNA	blastn	1181	532	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11630876	11630876	PRJNA1002570_P_NODE_24650_length_280_cov_1.859903_g24455_i0	PRJNA1002570	24650	280	1.859903	5.2077284	Caenorhabditis elegans	6239	Nematoda	Nematoda	518	2.12e-142	NTclustered	gi\|1972261834\|ref\|NM_065217.8\|	6239	g24455	i0	100	4.69285714285714	280	0	100	0	1	280	137	416	Caenorhabditis elegans Cytochrome oxidase c subunit VIb (cox-6B), mRNA	blastn	1314	518	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12905947	12905947	PRJNA1002570_P_NODE_21071_length_288_cov_1.432558_g20876_i0	PRJNA1002570	21071	288	1.432558	4.12576704	Caenorhabditis elegans	6239	Nematoda	Nematoda	532	7.8e-147	NTclustered	gi\|1845975116\|ref\|NM_067638.8\|	6239	g20876	i0	100	7.60069444444444	288	0	100	0	1	288	264	551	Caenorhabditis elegans SPARC (ost-1), mRNA	blastn	2189	532	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
12906016	12906016	PRJNA1002570_P_NODE_25051_length_279_cov_2.048544_g24856_i0	PRJNA1002570	25051	279	2.048544	5.71543776	Caenorhabditis elegans	6239	Nematoda	Nematoda	505	1.6399999999999995e-138	NTclustered	gi\|27543076\|gb\|AY171204.1\|	6239	g24856	i0	99.283	26.6523297491039	279	2	100	0	1	279	1387	1665	Caenorhabditis elegans isolate PB303 cytochrome oxidase subunit III (COIII) gene, partial cds; tRNA-Thr gene, complete sequence; NADH dehydrogenase subunit 4 (ND4) and cytochrome oxidase subunit I (COI) genes, complete cds; tRNA-Cys, tRNA-Met, tRNA-Asp, and tRNA-Gly genes, complete sequence; cytochrome oxidase subunit II (COII) gene, complete cds; tRNA-His gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial genes for mitochondrial products	blastn	7436	505	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
14180852	14180852	PRJNA1002570_P_NODE_20992_length_288_cov_1.851163_g20797_i0	PRJNA1002570	20992	288	1.851163	5.33134944	Caenorhabditis elegans	6239	Nematoda	Nematoda	527	3.63e-145	NTclustered	gi\|1972296258\|ref\|NM_074049.9\|	6239	g20797	i0	99.653	2.83333333333333	288	1	100	0	1	288	18	305	Caenorhabditis elegans DUF3444 domain-containing protein (C06B3.6), mRNA	blastn	816	527	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
14180922	14180922	PRJNA1002570_P_NODE_25232_length_279_cov_1.417476_g25037_i0	PRJNA1002570	25232	279	1.417476	3.95475804	Caenorhabditis elegans	6239	Nematoda	Nematoda	516	7.58e-142	NTclustered	gi\|1279324\|emb\|Z71266.1\|	6239	g25037	i0	100	4	279	0	100	0	1	279	26822	27100	Caenorhabditis elegans Cosmid R06C7, complete sequence	blastn	1116	516	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15454790	15454790	PRJNA1002570_P_NODE_15693_length_310_cov_2.991561_g15498_i0	PRJNA1002570	15693	310	2.991561	9.2738391	Caenorhabditis elegans	6239	Nematoda	Nematoda	278	4.39e-70	NTclustered	gi\|351020686\|emb\|FO080294.1\|	6239	g15498	i0	100	4.80645161290323	150	0	97	0	1	150	9595	9744	Caenorhabditis elegans Cosmid F26F12, complete sequence	blastn	1490	278	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15455074	15455074	PRJNA1002570_P_NODE_33093_length_259_cov_1.494624_g32898_i0	PRJNA1002570	33093	259	1.494624	3.87107616	Caenorhabditis elegans	6239	Nematoda	Nematoda	479	9.13e-131	NTclustered	gi\|1972306525\|ref\|NM_171702.7\|	6239	g32898	i0	100	3.99227799227799	259	0	100	0	1	259	10	268	Caenorhabditis elegans Aspartate aminotransferase (got-2.2), mRNA	blastn	1034	479	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15455090	15455090	PRJNA1002570_P_NODE_33933_length_256_cov_2.393443_g33738_i0	PRJNA1002570	33933	256	2.393443	6.12721408	Caenorhabditis elegans	6239	Nematoda	Nematoda	473	4.189999999999999e-129	NTclustered	gi\|1972262697\|ref\|NM_001384075.2\|	6239	g33738	i0	100	2.8671875	256	0	100	0	1	256	2448	2193	Caenorhabditis elegans Translational repressor ifet-1 (ifet-1), mRNA	blastn	734	473	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19277760	19277760	PRJNA1002570_P_NODE_19356_length_292_cov_2.255708_g19161_i0	PRJNA1002570	19356	292	2.255708	6.58666736	Caenorhabditis elegans	6239	Nematoda	Nematoda	534	2.1999999999999998e-147	NTclustered	gi\|412982082\|emb\|FO080802.2\|	6239	g19161	i0	99.658	8.25684931506849	292	1	100	0	1	292	31278	30987	Caenorhabditis elegans Cosmid C36E6, complete sequence	blastn	2411	534	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19277906	19277906	PRJNA1002570_P_NODE_27976_length_272_cov_2.231156_g27781_i0	PRJNA1002570	27976	272	2.231156	6.06874432	Rhabditidoides sp. RS5443	669111	Nematoda	Nematoda	189	1.8199999999999998e-43	NTclustered	gi\|256709233\|gb\|GQ422269.1\|	669111	g27781	i0	83.654	12.0808823529412	208	26	75	6	40	243	64	267	Rhabditidoides sp. RS5443 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	3286	189	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Rhabditidoides	Rhabditidoides sp. RS5443
19277956	19277956	PRJNA1002570_P_NODE_30076_length_267_cov_1.587629_g29881_i0	PRJNA1002570	30076	267	1.587629	4.23896943	Plectus minimus	446301	Nematoda	Nematoda	460	3.4299999999999996e-125	NTclustered	gi\|148614851\|gb\|EF417148.1\|	446301	g29881	i0	97.753	98.8052434456929	267	6	100	0	1	267	25	291	Plectus minimus large subunit ribosomal RNA gene, partial sequence	blastn	26381	460	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Plectida	Plectidae	Plectus	Plectus minimus
19278198	19278198	PRJNA1002570_P_NODE_44956_length_235_cov_2.722222_g44761_i0	PRJNA1002570	44956	235	2.722222	6.3972217	Caenorhabditis elegans	6239	Nematoda	Nematoda	435	1.79e-117	NTclustered	gi\|1041319\|emb\|Z66512.1\|	6239	g44761	i0	100	4.32340425531915	235	0	100	0	1	235	1279	1045	Caenorhabditis elegans Cosmid F52H3, complete sequence	blastn	1016	435	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21829229	21829229	PRJNA1002570_P_NODE_32598_length_260_cov_1.647059_g32403_i0	PRJNA1002570	32598	260	1.647059	4.2823534	Caenorhabditis elegans	6239	Nematoda	Nematoda	481	2.55e-131	NTclustered	gi\|870959\|emb\|Z49887.1\|	6239	g32403	i0	100	3.00384615384615	260	0	100	0	1	260	22480	22739	Caenorhabditis elegans Cosmid F09B9, complete sequence	blastn	781	481	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
21829368	21829368	PRJNA1002570_P_NODE_40118_length_246_cov_0.890173_g39923_i0	PRJNA1002570	40118	246	0.890173	2.18982558	Setostephanolaimus sp. OVN-2021	2893399	Nematoda	Nematoda	316	7.14e-82	NTclustered	gi\|2130729779\|gb\|OL416399.1\|	2893399	g39923	i0	90.574	94.4634146341463	244	16	97	5	9	246	2348	2106	Setostephanolaimus sp. OVN-2021 large subunit ribosomal RNA gene, partial sequence	blastn	23238	316	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Plectida	Camacolaimidae	Setostephanolaimus	Setostephanolaimus sp. OVN-2021
26615307	26615307	PRJNA1002570_P_NODE_5341_length_471_cov_1.821608_g5147_i0	PRJNA1002570	5341	471	1.821608	8.57977368	root	1	Root_unresolved	Root_unresolved	145	8.239999999999999e-37	NR	KJH43625.1	29172	g5147	i0	60.6	8.93630573248408	132	50	83.4	2	464	72	2006	2136	KJH43625.1 aspartate carbamoyltransferase [Dictyocaulus viviparus]	diamond	4209	146	0.993150684931507	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Dictyocaulus	Dictyocaulus viviparus
28069327	28069327	PRJNA1002570_P_NODE_37505_length_249_cov_1.375000_g37310_i0	PRJNA1002570	37505	249	1.375	3.42375	Metazoa	33208	Nematoda	Nematoda	50.1	1.05e-4	NR	CDW53376.1	36087	g37310	i0	47.8	2.10843373493976	46	24	55.4	0	101	238	232	277	CDW53376.1 TPR 1 and NARP1 domain containing protein [Trichuris trichiura]	diamond	525	50.4	0.994047619047619	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
30982404	30982404	PRJNA1002570_P_NODE_12874_length_334_cov_1.478927_g12679_i0	PRJNA1002570	12874	334	1.478927	4.93961618	Angiostrongylus cantonensis	6313	Nematoda	Nematoda	50.1	2.05e-4	NR	KAE9412456.1	6313	g12679	i0	87.5	0.215568862275449	24	3	21.6	0	332	261	222	245	KAE9412456.1 hypothetical protein Angca_007921, partial [Angiostrongylus cantonensis]	diamond	72	50.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Angiostrongylus	Angiostrongylus cantonensis
32342539	32342539	PRJNA1002570_P_NODE_30599_length_266_cov_1.196891_g30404_i0	PRJNA1002570	30599	266	1.196891	3.18373006	Heligmosomoides polygyrus	6339	Nematoda	Nematoda	42.7	0.0432	NR	VDO65198.1	6339	g30404	i0	32.9	0.823308270676692	73	44	82.3	1	5	223	135	202	VDO65198.1 unnamed protein product [Heligmosomoides polygyrus]	diamond	219	42.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Heligmosomoides	Heligmosomoides polygyrus

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