metadata: contig_metadata: 9 rows where bioproject = "PRJNA1132896" and tax

9 rows where bioproject = "PRJNA1132896" 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
283652	283652	PRJNA1132896_P_NODE_6141_length_258_cov_2.497297_g6050_i0	PRJNA1132896	6141	258	2.497297	6.44302626	Strongyloides ratti	34506	Nematoda	Nematoda	191	4.77e-44	NTclustered	gi\|1376154927\|ref\|XM_024651418.1\|	34506	g6050	i0	82.222	184.267441860465	225	36	86	4	2	224	13	235	Strongyloides ratti Histone H3 (SRAE_X000165500), partial mRNA	blastn	47541	191	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
4110630	4110630	PRJNA1132896_P_NODE_1884_length_392_cov_2.398119_g1793_i0	PRJNA1132896	1884	392	2.398119	9.40062648	Caenorhabditis briggsae	6238	Nematoda	Nematoda	220	9.71e-53	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g1793	i0	81.25	15.4464285714286	272	51	69	0	120	391	106	377	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	6055	220	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
6661472	6661472	PRJNA1132896_P_NODE_2226_length_365_cov_1.907534_g2135_i0	PRJNA1132896	2226	365	1.907534	6.9624991	Rhabditoides inermis	96661	Nematoda	Nematoda	276	1.89e-69	NTclustered	gi\|256709332\|gb\|GQ422341.1\|	96661	g2135	i0	81.02	21.4630136986301	353	61	96	6	1	350	384	35	Rhabditoides inermis large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	7834	276	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Rhabditoides	Rhabditoides inermis
10487181	10487181	PRJNA1132896_P_NODE_809_length_572_cov_1.737475_g719_i0	PRJNA1132896	809	572	1.737475	9.938357	Rhabditida	6236	Nematoda	Nematoda	266	2.1800000000000002e-86	NR	VDM46117.1	6265	g719	i0	73.7	3.90734265734266	186	45	97.6	2	14	571	1	182	VDM46117.1 unnamed protein product [Toxocara canis]	diamond	2235	267	0.99625468164794	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Toxocaridae	Toxocara	Toxocara canis
11235107	11235107	PRJNA1132896_P_NODE_1689_length_410_cov_2.474777_g1598_i0	PRJNA1132896	1689	410	2.474777	10.1465857	Metazoa	33208	Nematoda	Nematoda	292	2.13e-74	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g1598	i0	83.125	77.3365853658537	320	54	78	0	25	344	374	55	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	31708	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
13037327	13037327	PRJNA1132896_P_NODE_3691_length_296_cov_1.381166_g3600_i0	PRJNA1132896	3691	296	1.381166	4.08825136	Campydora demonstrans	211217	Nematoda	Nematoda	257	5.43e-64	NTclustered	gi\|2623950732\|gb\|OR852751.1\|	211217	g3600	i0	82.712	58.5067567567568	295	46	99	2	2	296	5292	5003	Campydora demonstrans isolate OVN-2022 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	17318	257	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Enoplida	Campydoridae	Campydora	Campydora demonstrans
15586511	15586511	PRJNA1132896_P_NODE_1233_length_469_cov_1.830808_g1142_i0	PRJNA1132896	1233	469	1.830808	8.58648952	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	187	1.2e-42	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g1142	i0	77.532	22.9402985074627	316	67	67	3	114	427	329	16	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	10759	187	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
31291610	31291610	PRJNA1132896_P_NODE_5015_length_274_cov_2.651741_g4924_i0	PRJNA1132896	5015	274	2.651741	7.26577034	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	3.3799999999999995e-32	NR	XP_024506305.1	34506	g4924	i0	62.1	6.7007299270073	87	33	95.3	0	13	273	168	254	XP_024506305.1 Cyclin-dependent kinase 1 [Strongyloides ratti]	diamond	1836	125	0.992	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
32536650	32536650	PRJNA1132896_P_NODE_2019_length_380_cov_2.003257_g1928_i0	PRJNA1132896	2019	380	2.003257	7.6123766	Aphelenchoides avenae	70226	Nematoda	Nematoda	86.3	9.92e-17	NR	KAH7725399.1	70226	g1928	i0	38.5	1.86315789473684	117	68	92.4	1	359	9	250	362	KAH7725399.1 V-ATPase subunit C family protein [Aphelenchoides avenae]	diamond	708	86.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae

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