metadata: contig_metadata: 9 rows where bioproject = "PRJNA399711", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA399711", tax_kingdom = "Metazoa" 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
25562825	25562825	PRJNA399711_S_NODE_26905_length_248_cov_5.203791_g26763_i0	PRJNA399711	26905	248	5.203791	12.90540168	Rhabditida	6236	Nematoda	Nematoda	118	5.82e-29	NR	AAM81354.1	52066	g26763	i0	91.7	45	60	5	72.6	0	1	180	455	514	AAM81354.1 aldehyde dehydrogenase [Steinernema feltiae]	diamond	11160	118	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Steinernematidae	Steinernema	Steinernema feltiae
25836697	25836697	PRJNA399711_S_NODE_68979_length_177_cov_3.114286_g68837_i0	PRJNA399711	68979	177	3.114286	5.51228622	Necator americanus	51031	Nematoda	Nematoda	122	1.1199999999999999e-23	NTclustered	gi\|2707621710\|ref\|XM_013453918.2\|	51031	g68837	i0	91.111	7.31073446327684	90	8	51	0	3	92	1042	1131	Necator americanus uncharacterized protein (RB195_025756), partial mRNA	blastn	1294	122	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
25896636	25896636	PRJNA399711_S_NODE_39091_length_217_cov_12.738889_g38949_i0	PRJNA399711	39091	217	12.738889	27.64338913	Onchocercidae	6296	Nematoda	Nematoda	65.8	2.46e-6	NTclustered	gi\|100913230\|gb\|DQ516388.1\|	6279	g38949	i0	83.784	1.23963133640553	74	6	33	4	36	106	679	609	Brugia malayi acidic ribosomal protein 0 (rpa0) and translationally controlled tumor protein-like protein (tct1) genes, partial cds	blastn	269	65.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
25973669	25973669	PRJNA399711_S_NODE_90628_length_160_cov_5.739837_g90486_i0	PRJNA399711	90628	160	5.739837	9.1837392	Metazoa	33208	Nematoda	Nematoda	62	1.94e-9	NR	KAK5967852.1	6319	g90486	i0	90	13.5375	30	3	56.3	0	43	132	799	828	KAK5967852.1 Elongator complex protein 3 [Trichostrongylus colubriformis]	diamond	2166	62	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Trichostrongylidae	Trichostrongylus	Trichostrongylus colubriformis
32934813	32934813	PRJNA399711_S_NODE_46737_length_204_cov_2.724551_g46595_i0	PRJNA399711	46737	204	2.724551	5.55808404	Ancylostoma ceylanicum	53326	Nematoda	Nematoda	42	0.0405	NR	EYC00257.1	53326	g46595	i0	35.4	0.955882352941177	65	37	92.6	2	5	193	79	140	EYC00257.1 hypothetical protein Y032_0117g699 [Ancylostoma ceylanicum]	diamond	195	42	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Ancylostoma	Ancylostoma ceylanicum
32986004	32986004	PRJNA399711_S_NODE_19043_length_280_cov_5.102881_g18901_i0	PRJNA399711	19043	280	5.102881	14.2880668	Aphelenchoides avenae	70226	Nematoda	Nematoda	68.6	4.83e-11	NR	KAH7705498.1	70226	g18901	i0	47	1.77857142857143	83	42	88.9	1	27	275	618	698	KAH7705498.1 putative reverse transcriptase - house mosquito [Aphelenchoides avenae]	diamond	498	68.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae
32992616	32992616	PRJNA399711_S_NODE_73355_length_173_cov_3.580882_g73213_i0	PRJNA399711	73355	173	3.580882	6.19492586	Bursaphelenchus	6324	Nematoda	Nematoda	56.6	1.83e-7	NR	CAD5227577.1	6326	g73213	i0	64.3	2.25433526011561	42	15	72.8	0	158	33	484	525	CAD5227577.1 unnamed protein product [Bursaphelenchus xylophilus]	diamond	390	57	0.992982456140351	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
33071302	33071302	PRJNA399711_S_NODE_43869_length_209_cov_1.906977_g43727_i0	PRJNA399711	43869	209	1.906977	3.98558193	Nippostrongylus brasiliensis	27835	Nematoda	Nematoda	46.2	0.00115	NR	WKY10318.1	27835	g43727	i0	47.6	2.41148325358852	42	22	60.3	0	129	4	92	133	WKY10318.1 hypothetical protein Q1695_002566 [Nippostrongylus brasiliensis]	diamond	504	46.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heligmosomidae	Nippostrongylus	Nippostrongylus brasiliensis
33094934	33094934	PRJNA399711_S_NODE_48254_length_201_cov_10.542683_g48112_i0	PRJNA399711	48254	201	10.542683	21.19079283	Opisthokonta	33154	Nematoda	Nematoda	48.9	3.46e-5	NR	ETN70565.1	51031	g48112	i0	61.8	3.29850746268657	34	13	50.7	0	199	98	84	117	ETN70565.1 hypothetical protein NECAME_14681, partial [Necator americanus]	diamond	663	49.3	0.991886409736308	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);;