metadata: contig_metadata: 5 rows where bioproject = "PRJNA902848", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA902848", 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
7260328	7260328	PRJNA902848_P_NODE_9886_length_286_cov_1.464789_g9836_i0	PRJNA902848	9886	286	1.464789	4.18929654	Diplogasteroides magnus	560213	Nematoda	Nematoda	171	6.99e-38	NTclustered	gi\|256709124\|gb\|GQ422214.1\|	560213	g9836	i0	78.824	8.45804195804196	255	52	89	2	31	284	725	472	Diplogasteroides magnus large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	2419	171	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteroididae	Diplogasteroides	Diplogasteroides magnus
8534854	8534854	PRJNA902848_P_NODE_14587_length_251_cov_0.876404_g14537_i0	PRJNA902848	14587	251	0.876404	2.19977404	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	132	2.84e-26	NTclustered	gi\|256709336\|gb\|GQ422343.1\|	669147	g14537	i0	81.875	9.72908366533865	160	25	63	4	92	249	44	201	Tylopharynx sp. WEM-2009 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2442	132	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
11085709	11085709	PRJNA902848_P_NODE_2929_length_453_cov_1.023684_g2879_i0	PRJNA902848	2929	453	1.023684	4.63728852	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	131	2.48e-35	NR	KAL3080236.1	157864	g2879	i0	63.9	6.3046357615894	108	38	70.9	1	322	2	13	120	KAL3080236.1 hypothetical protein niasHT_035671 [Heterodera trifolii]	diamond	2856	131	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
26905346	26905346	PRJNA902848_P_NODE_2781_length_461_cov_2.780928_g2731_i0	PRJNA902848	2781	461	2.780928	12.82007808	Opisthokonta	33154	Nematoda	Nematoda	202	7.17e-64	NR	KHN76788.1	6265	g2731	i0	71	29.5054229934924	138	39	89.8	1	47	460	14	150	KHN76788.1 40S ribosomal protein S15 [Toxocara canis]	diamond	13602	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
31896685	31896685	PRJNA902848_P_NODE_6937_length_330_cov_1.167315_g6887_i0	PRJNA902848	6937	330	1.167315	3.8521395	Metazoa	33208	Nematoda	Nematoda	114	6.83e-30	NR	KAL3095348.1	97005	g6887	i0	50.5	2.86363636363636	105	50	95.5	1	328	14	41	143	KAL3095348.1 hypothetical protein niasHS_007447 [Heterodera schachtii]	diamond	945	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera schachtii

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