metadata: contig_metadata: 18 rows where bioproject = "PRJNA1063685" and tax

18 rows where bioproject = "PRJNA1063685" 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
2730338	2730338	PRJNA1063685_S_NODE_67703_length_256_cov_2.103825_g67160_i0	PRJNA1063685	67703	256	2.103825	5.385792	Caenorhabditis brenneri	135651	Nematoda	Nematoda	94	1.54e-20	NR	EGT44810.1	135651	g67160	i0	50.6	2.98828125	85	42	99.6	0	256	2	259	343	EGT44810.1 hypothetical protein CAEBREN_18240 [Caenorhabditis brenneri]	diamond	765	94	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis brenneri
10382600	10382600	PRJNA1063685_S_NODE_10949_length_614_cov_72.567468_g10434_i0	PRJNA1063685	10949	614	72.567468	445.56425352	Metazoa	33208	Nematoda	Nematoda	260	3.11e-85	NR	KHN75153.1	6265	g10434	i0	71.9	13.9104234527687	171	48	83.6	0	71	583	26	196	KHN75153.1 60S ribosomal protein L11 [Toxocara canis]	diamond	8541	260	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
18031189	18031189	PRJNA1063685_S_NODE_29355_length_433_cov_14.505556_g28813_i0	PRJNA1063685	29355	433	14.505556	62.80905748	Caenorhabditis elegans	6239	Nematoda	Nematoda	303	1.05e-77	NTclustered	gi\|1972235554\|ref\|NM_001025879.7\|	6239	g28813	i0	86.17	67.0785219399538	282	37	65	2	22	302	1032	1312	Caenorhabditis elegans Tubulin alpha-2 chain (tba-2), mRNA	blastn	29045	303	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
27248498	27248498	PRJNA1063685_S_NODE_6303_length_698_cov_21.120000_g5826_i0	PRJNA1063685	6303	698	21.12	147.4176	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.2	2.98e-5	NR	KAI3411984.1	36090	g5826	i0	33.8	2.83667621776504	77	49	33.1	1	306	536	204	278	KAI3411984.1 hypothetical protein GPALN_002038 [Globodera pallida]	diamond	1980	56.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Globodera	Globodera pallida
27280197	27280197	PRJNA1063685_S_NODE_56303_length_293_cov_2.709091_g55760_i0	PRJNA1063685	56303	293	2.709091	7.93763663	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	45.8	0.00573	NR	WKY09393.1	27835	g55760	i0	44.2	4.35153583617747	52	29	53.2	0	1	156	458	509	WKY09393.1 hypothetical protein Q1695_002059 [Nippostrongylus brasiliensis]	diamond	1275	45.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Nippostrongylus	Nippostrongylus brasiliensis
28069554	28069554	PRJNA1063685_S_NODE_64345_length_266_cov_1.569948_g63802_i0	PRJNA1063685	64345	266	1.569948	4.17606168	Opisthokonta	33154	Nematoda	Nematoda	120	3.16e-29	NR	KHN72307.1	6265	g63802	i0	65.5	8.56015037593985	84	29	94.7	0	257	6	920	1003	KHN72307.1 putative methylmalonyl-CoA mutase, mitochondrial [Toxocara canis]	diamond	2277	120	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
28803778	28803778	PRJNA1063685_S_NODE_22288_length_488_cov_8.202410_g21748_i0	PRJNA1063685	22288	488	8.20241	40.0277608	Gnathostoma spinigerum	75299	Nematoda	Nematoda	70.5	1.82e-11	NR	MFH4973502.1	75299	g21748	i0	55.9	0.842213114754098	59	26	36.3	0	460	284	127	185	MFH4973502.1 hypothetical protein [Gnathostoma spinigerum]	diamond	411	70.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
28890366	28890366	PRJNA1063685_S_NODE_17768_length_532_cov_3.069717_g17232_i0	PRJNA1063685	17768	532	3.069717	16.33089444	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	209	1.09e-60	NR	KAE9414601.1	6313	g17232	i0	61.5	53.7011278195489	156	59	87.4	1	511	47	433	588	KAE9414601.1 hypothetical protein Angca_007700 [Angiostrongylus cantonensis]	diamond	28569	209	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Metastrongylidae	Angiostrongylus	Angiostrongylus cantonensis
29143352	29143352	PRJNA1063685_S_NODE_66149_length_261_cov_1.202128_g65606_i0	PRJNA1063685	66149	261	1.202128	3.13755408	Opisthokonta	33154	Nematoda	Nematoda	62.8	3.94e-9	NR	XP_002642121.2	6238	g65606	i0	52.7	4.72413793103448	55	23	62.1	2	179	18	244	296	XP_002642121.2 Protein CBG18067 [Caenorhabditis briggsae]	diamond	1233	63.2	0.993670886075949	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
29901006	29901006	PRJNA1063685_S_NODE_11871_length_601_cov_21.748106_g11355_i0	PRJNA1063685	11871	601	21.748106	130.70611706	Metazoa	33208	Nematoda	Nematoda	187	2.7199999999999992e-52	NR	XP_024510700.1	34506	g11355	i0	56.8	4.22296173044925	169	71	83.9	2	575	72	446	613	XP_024510700.1 ATPase, F1/V1/A1 complex, alpha/beta subunit, nucleotide-binding domain and ATPase, F1/V1/A1 complex, alpha/beta subunit, C-terminal domain and ATPase, F1 complex alpha/beta subunit, N-terminal domain and ATPase, V1 complex, subunit A family and V-type ATP synthase catalytic alpha chain family and ATPase, F1 complex beta subunit/V1 complex, C-terminal domain and P-loop containing nucleoside triphosphate hydrolase domain-containing protein [Strongyloides ratti]	diamond	2538	187	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
29995810	29995810	PRJNA1063685_S_NODE_39531_length_371_cov_1.526846_g38988_i0	PRJNA1063685	39531	371	1.526846	5.66459866	Nematoda	6231	Nematoda	Nematoda	63.5	8.24e-9	NR	KAF8362868.1	54126	g38988	i0	49.5	4.62533692722372	95	44	76.8	3	370	86	305	395	KAF8362868.1 hypothetical protein PRIPAC_89791 [Pristionchus pacificus]	diamond	1716	63.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus
30730586	30730586	PRJNA1063685_S_NODE_3074_length_813_cov_43.945946_g2684_i0	PRJNA1063685	3074	813	43.945946	357.28054098	Necator americanus	51031	Nematoda	Nematoda	45.1	0.0137	NR	ETN80231.1	51031	g2684	i0	42.9	0.180811808118081	49	21	15.5	1	178	303	11	59	ETN80231.1 hypothetical protein NECAME_09284 [Necator americanus]	diamond	147	45.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
30983556	30983556	PRJNA1063685_S_NODE_69994_length_250_cov_2.016949_g69451_i0	PRJNA1063685	69994	250	2.016949	5.0423725	Diploscapter pachys	2018661	Nematoda	Nematoda	51.6	5.2e-6	NR	PAV87256.1	2018661	g69451	i0	39.7	3.924	73	42	85.2	1	38	250	33	105	PAV87256.1 hypothetical protein WR25_15124 [Diploscapter pachys]	diamond	981	51.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Diploscapter	Diploscapter pachys
31140933	31140933	PRJNA1063685_S_NODE_16475_length_545_cov_8.351695_g15944_i0	PRJNA1063685	16475	545	8.351695	45.51673775	Steinernema carpocapsae	34508	Nematoda	Nematoda	67.8	3.45e-10	NR	TKR89800.1	34508	g15944	i0	34.8	1.01284403669725	92	59	50.6	1	1	276	127	217	TKR89800.1 hypothetical protein L596_013847 [Steinernema carpocapsae]	diamond	552	67.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
31457711	31457711	PRJNA1063685_S_NODE_49176_length_323_cov_1.540000_g48633_i0	PRJNA1063685	49176	323	1.54	4.9742	Gnathostoma spinigerum	75299	Nematoda	Nematoda	69.3	3.41e-13	NR	MFH4981986.1	75299	g48633	i0	61.8	1.51393188854489	55	21	51.1	0	273	109	5	59	MFH4981986.1 hypothetical protein [Gnathostoma spinigerum]	diamond	489	69.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
31615722	31615722	PRJNA1063685_S_NODE_63356_length_269_cov_2.311224_g62813_i0	PRJNA1063685	63356	269	2.311224	6.21719256	Heligmosomoides polygyrus	6339	Nematoda	Nematoda	57.4	1.54e-7	NR	VDP35923.1	6339	g62813	i0	51	0.568773234200744	51	24	56.9	1	3	155	128	177	VDP35923.1 unnamed protein product [Heligmosomoides polygyrus]	diamond	153	57.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Heligmosomoides	Heligmosomoides polygyrus
32335382	32335382	PRJNA1063685_S_NODE_4979_length_733_cov_10.681818_g4546_i0	PRJNA1063685	4979	733	10.681818	78.29772594	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	219	3.23e-63	NR	CDW56382.1	36087	g4546	i0	50.6	21.8226466575716	231	106	93.7	3	10	696	457	681	CDW56382.1 glycyl trna synthetase [Trichuris trichiura]	diamond	15996	221	0.990950226244344	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
32745622	32745622	PRJNA1063685_S_NODE_18300_length_526_cov_11.735099_g17764_i0	PRJNA1063685	18300	526	11.735099	61.72662074	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	45.1	0.0405	NR	KRX55875.1	181606	g17764	i0	33.3	0.929657794676806	81	50	43.9	1	365	135	34	114	KRX55875.1 B-cell receptor-associated protein 29 [Trichinella sp. T9]	diamond	489	45.4	0.993392070484582	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella sp. T9

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