metadata: contig_metadata: 14 rows where bioproject = "PRJNA751877", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA751877", tax_clade = "Opisthokonta" 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
2002443	2002443	PRJNA751877_P_NODE_25362_length_247_cov_0.885057_g25240_i0	PRJNA751877	25362	247	0.885057	2.18609079	Rhabditida	6236	Nematoda	Nematoda	140	1.73e-36	NR	VDM43330.1	6265	g25240	i0	79.3	13.9433198380567	82	17	99.6	0	247	2	1046	1127	VDM43330.1 unnamed protein product [Toxocara canis]	diamond	3444	141	0.99290780141844	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
4554669	4554669	PRJNA751877_P_NODE_13964_length_307_cov_2.153846_g13842_i0	PRJNA751877	13964	307	2.153846	6.61230722	Aphelenchoides bicaudatus	293665	Nematoda	Nematoda	125	2.9999999999999998e-33	NR	KAI6182696.1	293665	g13842	i0	64.3	3.82084690553746	98	35	95.8	0	295	2	15	112	KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus]	diamond	1173	125	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus
7105270	7105270	PRJNA751877_P_NODE_4546_length_449_cov_1.228723_g4424_i0	PRJNA751877	4546	449	1.228723	5.51696627	Caenorhabditis elegans	6239	Nematoda	Nematoda	771	0	NTclustered	gi\|1429284\|emb\|Z75954.1\|	6239	g4424	i0	98.845	2.79287305122494	433	4	96	1	1	432	1168	736	Caenorhabditis elegans Cosmid F58H1, complete sequence	blastn	1254	771	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
8853006	8853006	PRJNA751877_P_NODE_1227_length_694_cov_1.776167_g1109_i0	PRJNA751877	1227	694	1.776167	12.32659898	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	318	1.3e-106	NR	TKR60891.1	34508	g1109	i0	65.5	22.2622478386167	229	79	99	0	688	2	26	254	TKR60891.1 hypothetical protein L596_028073 [Steinernema carpocapsae]	diamond	15450	321	0.990654205607477	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema carpocapsae
16028937	16028937	PRJNA751877_P_NODE_18993_length_271_cov_3.085859_g18871_i0	PRJNA751877	18993	271	3.085859	8.36267789	Caenorhabditis elegans	6239	Nematoda	Nematoda	501	2.05e-137	NTclustered	gi\|687865328\|emb\|LK927659.1\|	6239	g18871	i0	100	13.8929889298893	271	0	100	0	1	271	88846	89116	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000114	blastn	3765	501	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
17304661	17304661	PRJNA751877_P_NODE_4474_length_451_cov_1.404762_g4352_i0	PRJNA751877	4474	451	1.404762	6.33547662	Caenorhabditis elegans	6239	Nematoda	Nematoda	688	0	NTclustered	gi\|1429284\|emb\|Z75954.1\|	6239	g4352	i0	100	4.09534368070953	372	0	82	0	1	372	1859	2230	Caenorhabditis elegans Cosmid F58H1, complete sequence	blastn	1847	688	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23679561	23679561	PRJNA751877_P_NODE_7479_length_381_cov_4.292208_g7357_i0	PRJNA751877	7479	381	4.292208	16.35331248	Bursaphelenchus xylophilus	6326	Nematoda	Nematoda	174	1.99e-53	NR	CAD5208001.1	6326	g7357	i0	64.6	2	127	45	100	0	381	1	6	132	CAD5208001.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	762	174	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
24953045	24953045	PRJNA751877_P_NODE_30040_length_241_cov_0.916667_g29918_i0	PRJNA751877	30040	241	0.916667	2.20916747	Opisthokonta	33154	Nematoda	Nematoda	146	9.7e-41	NR	VBB34930.1	6277	g29918	i0	82.3	80.6514522821577	79	14	98.3	0	1	237	23	101	VBB34930.1 unnamed protein product, partial [Acanthocheilonema viteae]	diamond	19437	147	0.993197278911565	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
28032006	28032006	PRJNA751877_P_NODE_22445_length_251_cov_0.865169_g22323_i0	PRJNA751877	22445	251	0.865169	2.17157419	Acanthocheilonema viteae	6277	Nematoda	Nematoda	55.1	8.27e-7	NR	VBB27671.1	6277	g22323	i0	36.3	1.91235059760956	80	44	95.6	1	249	10	106	178	VBB27671.1 unnamed protein product [Acanthocheilonema viteae]	diamond	480	55.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Acanthocheilonema	Acanthocheilonema viteae
28041948	28041948	PRJNA751877_P_NODE_22665_length_251_cov_0.865169_g22543_i0	PRJNA751877	22665	251	0.865169	2.17157419	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.1	5.24e-4	NR	UMM11632.1	6238	g22543	i0	38.6	3.49003984063745	57	35	68.1	0	249	79	686	742	UMM11632.1 hypothetical protein L5515_000822 [Caenorhabditis briggsae]	diamond	876	48.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
28915718	28915718	PRJNA751877_P_NODE_2108_length_574_cov_1.485030_g1987_i0	PRJNA751877	2108	574	1.48503	8.5240722	Meloidogyne graminicola	189291	Nematoda	Nematoda	85.9	2.31e-16	NR	AVZ46778.1	189291	g1987	i0	54.7	0.496515679442509	95	40	49.1	2	570	289	156	248	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	285	85.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
29704906	29704906	PRJNA751877_P_NODE_27830_length_244_cov_0.900585_g27708_i0	PRJNA751877	27830	244	0.900585	2.1974274	Oesophagostomum dentatum	61180	Nematoda	Nematoda	90.9	4.36e-19	NR	KHJ90081.1	61180	g27708	i0	48.1	6.79918032786885	79	39	97.1	1	238	2	423	499	KHJ90081.1 NF-X1 type zinc finger, partial [Oesophagostomum dentatum]	diamond	1659	90.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Oesophagostomum	Oesophagostomum dentatum
31790985	31790985	PRJNA751877_P_NODE_20937_length_259_cov_1.403226_g20815_i0	PRJNA751877	20937	259	1.403226	3.63435534	Steinernema hermaphroditum	289476	Nematoda	Nematoda	45.1	0.00711	NR	KAK0425425.1	289476	g20815	i0	28.6	3.81081081081081	84	56	92.7	1	1	240	666	749	KAK0425425.1 hypothetical protein QR680_009193 [Steinernema hermaphroditum]	diamond	987	45.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema hermaphroditum
31980853	31980853	PRJNA751877_P_NODE_30478_length_226_cov_2.013072_g30356_i0	PRJNA751877	30478	226	2.013072	4.54954272	Necator americanus	51031	Nematoda	Nematoda	124	3.75e-33	NR	ETN81375.1	51031	g30356	i0	98.7	0.995575221238938	75	1	99.6	0	225	1	134	208	ETN81375.1 hypothetical protein NECAME_17904 [Necator americanus]	diamond	225	124	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus

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