metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA407886" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA407886" 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
1692290	1692290	PRJNA407886_P_NODE_43622_length_329_cov_1.742188_g41928_i0	PRJNA407886	43622	329	1.742188	5.73179852	Necator americanus	51031	Nematoda	Nematoda	56.5	0.002	NTclustered	gi\|2707563449\|ref\|XM_064188705.1\|	51031	g41928	i0	96.97	0.100303951367781	33	1	10	0	258	290	419	451	Necator americanus uncharacterized protein (RB195_020420), partial mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ancylostomatidae	Necator	Necator americanus
2357229	2357229	PRJNA407886_P_NODE_12002_length_859_cov_3.796438_g10581_i0	PRJNA407886	12002	859	3.796438	32.61140242	Mansonella	42230	Nematoda	Nematoda	252	7.95e-62	NTclustered	gi\|1757078395\|gb\|MN432520.1\|	42231	g10581	i0	76.108	39.4062863795111	519	102	58	17	106	605	4183	4698	Mansonella perstans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	33850	254	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Mansonella	Mansonella perstans
8070288	8070288	PRJNA407886_P_NODE_22867_length_513_cov_1.538636_g21177_i0	PRJNA407886	22867	513	1.538636	7.89320268	Caenorhabditis briggsae	6238	Nematoda	Nematoda	335	4.45e-87	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g21177	i0	83.242	69.9395711500975	364	61	71	0	84	447	418	55	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	35879	335	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
8070890	8070890	PRJNA407886_P_NODE_51327_length_299_cov_3.721239_g49633_i0	PRJNA407886	51327	299	3.721239	11.12650461	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	80.5	1.28e-10	NTclustered	gi\|256709166\|gb\|GQ422235.1\|	669147	g49633	i0	76.101	0.531772575250836	159	34	53	4	38	194	1	157	Tylopharynx sp. WEM-2009 large subunit ribosomal protein 29 (rpl-29) pseudogene mRNA, complete sequence	blastn	159	80.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
13170825	13170825	PRJNA407886_P_NODE_25011_length_479_cov_1.423645_g23320_i0	PRJNA407886	25011	479	1.423645	6.81925955	Caenorhabditis briggsae	6238	Nematoda	Nematoda	350	1.4800000000000002e-91	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g23320	i0	85.337	72.0584551148226	341	46	71	4	141	479	1307	969	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	34516	350	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
13171042	13171042	PRJNA407886_P_NODE_35651_length_372_cov_4.792642_g33957_i0	PRJNA407886	35651	372	4.792642	17.82862824	Pristionchus pauli	376545	Nematoda	Nematoda	217	1.19e-51	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g33957	i0	79.739	4.40860215053763	306	56	81	6	1	303	339	37	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	1640	217	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
13171481	13171481	PRJNA407886_P_NODE_59151_length_276_cov_2.704433_g57457_i0	PRJNA407886	59151	276	2.704433	7.46423508	Pristionchus bucculentus	1317126	Nematoda	Nematoda	219	2.3599999999999993e-52	NTclustered	gi\|479330856\|gb\|KC463849.1\|	1317126	g57457	i0	88.043	29.5072463768116	184	22	67	0	10	193	206	23	Pristionchus bucculentus strain RS5596 small subunit ribosomal protein 14 (rps14) gene, partial cds	blastn	8144	219	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus bucculentus
13171596	13171596	PRJNA407886_P_NODE_64431_length_263_cov_1.278947_g62737_i0	PRJNA407886	64431	263	1.278947	3.36363061	Caenorhabditis remanei	31234	Nematoda	Nematoda	159	1.38e-34	NTclustered	gi\|2445373096\|ref\|XM_003088415.2\|	31234	g62737	i0	78.277	64.0114068441065	267	44	99	11	2	261	359	100	Caenorhabditis remanei uncharacterized protein (GCK72_013918), partial mRNA	blastn	16835	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
15720705	15720705	PRJNA407886_P_NODE_71973_length_249_cov_0.875000_g70279_i0	PRJNA407886	71973	249	0.875	2.17875	Levipalatum texanum	1486449	Nematoda	Nematoda	119	2.19e-22	NTclustered	gi\|610559467\|gb\|KJ395558.1\|	1486449	g70279	i0	79.532	42.2048192771084	171	31	68	4	1	169	205	37	Levipalatum texanum ribosomal protein (rpl-23) gene, partial cds	blastn	10509	119	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Levipalatum	Levipalatum texanum
15720915	15720915	PRJNA407886_P_NODE_83153_length_232_cov_2.817610_g81459_i0	PRJNA407886	83153	232	2.81761	6.5368552	Caenorhabditis briggsae	6238	Nematoda	Nematoda	100	7.3e-17	NTclustered	gi\|268574577\|ref\|XM_002642222.1\|	6238	g81459	i0	91.667	11.7887931034483	72	6	31	0	2	73	1057	1128	Caenorhabditis briggsae Protein CBR-ACT-5 (Cbr-act-5), partial mRNA	blastn	2735	100	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
16995045	16995045	PRJNA407886_P_NODE_48774_length_309_cov_1.127119_g47080_i0	PRJNA407886	48774	309	1.127119	3.48279771	Meloidogyne hapla	6305	Nematoda	Nematoda	100	1.02e-16	NTclustered	gi\|766695936\|gb\|KM887149.1\|	6305	g47080	i0	81.395	24.2038834951456	129	18	41	6	12	137	450	325	Meloidogyne hapla isolate HO1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	7479	100	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne hapla
16995085	16995085	PRJNA407886_P_NODE_51034_length_300_cov_3.017621_g49340_i0	PRJNA407886	51034	300	3.017621	9.052863	Caenorhabditis remanei	31234	Nematoda	Nematoda	115	3.51e-21	NTclustered	gi\|71835908\|gb\|DQ115333.1\|	31234	g49340	i0	76.606	9.57666666666667	218	45	71	5	69	282	478	263	Caenorhabditis remanei ubiquitin protein 1 (ubq-1) mRNA, partial cds	blastn	2873	115	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
18269364	18269364	PRJNA407886_P_NODE_59475_length_275_cov_5.074257_g57781_i0	PRJNA407886	59475	275	5.074257	13.95420675	Diplogastrellus gracilis	669117	Nematoda	Nematoda	183	8.59e-42	NTclustered	gi\|256709130\|gb\|GQ422217.1\|	669117	g57781	i0	83.333	12.3672727272727	204	28	73	5	71	271	465	665	Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	3401	183	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus gracilis

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