metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA631119" 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
2427240	2427240	PRJNA631119_P_NODE_9142_length_396_cov_3.411765_g9024_i0	PRJNA631119	9142	396	3.411765	13.5105894	Opisthokonta	33154	Nematoda	Nematoda	335	3.359999999999999e-87	NTclustered	gi\|256709243\|gb\|GQ422274.1\|	669148	g9024	i0	83.425	78.9646464646465	362	58	91	2	36	396	1	361	Neodiplogaster sp. WEM-2009 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	31270	335	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Neodiplogaster	Neodiplogaster sp. WEM-2009
3154017	3154017	PRJNA631119_P_NODE_12663_length_350_cov_3.725632_g12545_i0	PRJNA631119	12663	350	3.725632	13.039712	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.009	NTclustered	gi\|1831517864\|ref\|NM_001136422.4\|	6239	g12545	i0	100	0.331428571428571	29	0	8	0	268	296	36	8	Caenorhabditis elegans FIP (Fungus-Induced Protein) Related (fipr-2), partial mRNA	blastn	116	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
4980187	4980187	PRJNA631119_P_NODE_8284_length_412_cov_4.135693_g8166_i0	PRJNA631119	8284	412	4.135693	17.03905516	Pristionchus	54125	Nematoda	Nematoda	252	3.64e-62	NTclustered	gi\|150982247\|gb\|EF634712.1\|	376545	g8166	i0	81.529	38.2888349514563	314	50	75	6	84	393	310	1	Pristionchus pauli large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	15775	252	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
8256399	8256399	PRJNA631119_P_NODE_3067_length_621_cov_15.333942_g2956_i0	PRJNA631119	3067	621	15.333942	95.22377982	Caenorhabditis briggsae	6238	Nematoda	Nematoda	326	3.29e-84	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g2956	i0	86.986	48.4959742351047	292	34	47	4	12	301	1018	1307	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	30116	326	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
12082709	12082709	PRJNA631119_P_NODE_33810_length_247_cov_1.971264_g33692_i0	PRJNA631119	33810	247	1.971264	4.86902208	Strongyloides papillosus	174720	Nematoda	Nematoda	75	4.76e-9	NTclustered	gi\|687022641\|emb\|LM525555.1\|	174720	g33692	i0	89.655	1.34817813765182	58	6	23	0	147	204	601610	601553	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000001	blastn	333	75	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
14632230	14632230	PRJNA631119_P_NODE_40432_length_231_cov_2.481013_g40314_i0	PRJNA631119	40432	231	2.481013	5.73114003	Caenorhabditis briggsae	6238	Nematoda	Nematoda	135	1.99e-27	NTclustered	gi\|268579656\|ref\|XM_002644765.1\|	6238	g40314	i0	78.475	48.8658008658009	223	37	96	8	8	229	1320	1108	Caenorhabditis briggsae Protein CBR-HSP-3 (Cbr-hsp-3), partial mRNA	blastn	11288	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
17181299	17181299	PRJNA631119_P_NODE_4234_length_541_cov_3.756410_g4119_i0	PRJNA631119	4234	541	3.75641	20.3221781	Pristionchus bucculentus	1317126	Nematoda	Nematoda	320	1.32e-82	NTclustered	gi\|479330856\|gb\|KC463849.1\|	1317126	g4119	i0	81.818	67.6987060998152	385	64	71	6	88	469	34	415	Pristionchus bucculentus strain RS5596 small subunit ribosomal protein 14 (rps14) gene, partial cds	blastn	36625	320	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus bucculentus
19729780	19729780	PRJNA631119_P_NODE_16456_length_319_cov_0.918699_g16338_i0	PRJNA631119	16456	319	0.918699	2.93064981	Caenorhabditis remanei	31234	Nematoda	Nematoda	86.1	2.95e-12	NTclustered	gi\|2445381243\|ref\|XM_003114222.2\|	31234	g16338	i0	85.366	0.636363636363636	82	12	26	0	238	319	1525	1444	Caenorhabditis remanei uncharacterized protein (GCK72_018221), partial mRNA	blastn	203	86.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
19729794	19729794	PRJNA631119_P_NODE_19456_length_300_cov_1.356828_g19338_i0	PRJNA631119	19456	300	1.356828	4.070484	Caenorhabditis remanei	31234	Nematoda	Nematoda	115	3.51e-21	NTclustered	gi\|2445357861\|ref\|XM_003109015.2\|	31234	g19338	i0	84.483	29.38	116	18	39	0	82	197	241	356	Caenorhabditis remanei uncharacterized protein (GCK72_005938), partial mRNA	blastn	8814	115	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
20278429	20278429	PRJNA631119_P_NODE_6916_length_442_cov_6.037940_g6798_i0	PRJNA631119	6916	442	6.03794	26.6876948	Caenorhabditis	6237	Nematoda	Nematoda	342	2.2699999999999993e-89	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g6798	i0	86.164	70.9185520361991	318	43	72	1	49	366	375	59	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	31346	342	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae

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