metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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
321489	321489	PRJNA1195374_P_NODE_35201_length_379_cov_6.496732_g34857_i0	PRJNA1195374	35201	379	6.496732	24.62261428	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	167	1.24e-36	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g34857	i0	81.166	35.1926121372032	223	28	57	11	76	291	49	264	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	13338	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
2871857	2871857	PRJNA1195374_P_NODE_14803_length_586_cov_2.600390_g14463_i0	PRJNA1195374	14803	586	2.60039	15.2382854	Strongyloides papillosus	174720	Nematoda	Nematoda	333	1.85e-86	NTclustered	gi\|687022650\|emb\|LM525564.1\|	174720	g14463	i0	80.698	68.7098976109215	430	82	73	1	26	455	18031	17603	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000009	blastn	40264	333	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
11800528	11800528	PRJNA1195374_P_NODE_61950_length_275_cov_1.009901_g61606_i0	PRJNA1195374	61950	275	1.009901	2.77722775	Strongyloides papillosus	174720	Nematoda	Nematoda	54.7	0.007	NTclustered	gi\|687022781\|emb\|LM525893.1\|	174720	g61606	i0	100	0.210909090909091	29	0	11	0	221	249	26361	26333	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000267	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
13075225	13075225	PRJNA1195374_P_NODE_43651_length_336_cov_1.463878_g43307_i0	PRJNA1195374	43651	336	1.463878	4.91863008	Strongyloides ratti	34506	Nematoda	Nematoda	259	1.74e-64	NTclustered	gi\|1376142591\|ref\|XM_024651617.1\|	34506	g43307	i0	81.587	4.33333333333333	315	56	93	2	22	335	450	137	Strongyloides ratti Peptidyl-prolyl cis-trans isomerase D (SRAE_2000074700), partial mRNA	blastn	1456	259	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
14350484	14350484	PRJNA1195374_P_NODE_32132_length_398_cov_2.030769_g31788_i0	PRJNA1195374	32132	398	2.030769	8.08246062	Caenorhabditis briggsae	6238	Nematoda	Nematoda	307	7.37e-79	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g31788	i0	87.179	70.1909547738694	273	31	68	4	1	271	1037	1307	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	27936	307	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
15624107	15624107	PRJNA1195374_P_NODE_28373_length_426_cov_0.872521_g28029_i0	PRJNA1195374	28373	426	0.872521	3.71693946	Strongyloides ratti	34506	Nematoda	Nematoda	477	5.719999999999998e-130	NTclustered	gi\|1376136641\|ref\|XM_024648415.1\|	34506	g28029	i0	86.854	97.3802816901408	426	56	100	0	1	426	577	1002	Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_1000145800), partial mRNA	blastn	41484	477	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
20169056	20169056	PRJNA1195374_P_NODE_52336_length_302_cov_1.681223_g51992_i0	PRJNA1195374	52336	302	1.681223	5.07729346	Pristionchus	54125	Nematoda	Nematoda	250	9.29e-62	NTclustered	gi\|150982247\|gb\|EF634712.1\|	376545	g51992	i0	82.253	53.5629139072848	293	48	96	3	5	295	303	13	Pristionchus pauli large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	16176	250	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
20722568	20722568	PRJNA1195374_P_NODE_21757_length_486_cov_11.297821_g21414_i0	PRJNA1195374	21757	486	11.297821	54.90741006	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.56e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g21414	i0	81.492	4.64197530864198	362	61	74	6	59	417	395	37	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2256	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
20723145	20723145	PRJNA1195374_P_NODE_50357_length_310_cov_0.970464_g50013_i0	PRJNA1195374	50357	310	0.970464	3.0084384	Pristionchus arcanus	1195655	Nematoda	Nematoda	180	1.27e-40	NTclustered	gi\|390135504\|gb\|JQ399949.1\|	1195655	g50013	i0	78.246	11.1354838709677	285	58	91	4	14	296	333	51	Pristionchus arcanus small subunit ribosomal protein 8 (rps-8) gene, partial cds	blastn	3452	180	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus arcanus

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