metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA724011" 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
1986958	1986958	PRJNA724011_P_NODE_89642_length_258_cov_1.664865_g88619_i0	PRJNA724011	89642	258	1.664865	4.2953517	Strongyloides ratti	34506	Nematoda	Nematoda	65.8	3.02e-6	NTclustered	gi\|1376148657\|ref\|XM_024655047.1\|	34506	g88619	i0	87.719	0.484496124031008	57	6	22	1	192	248	73	128	Strongyloides ratti DnaJ homolog subfamily C member 17 (SRAE_2000380900), partial mRNA	blastn	125	65.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
4538875	4538875	PRJNA724011_P_NODE_21384_length_627_cov_14.716606_g20372_i0	PRJNA724011	21384	627	14.716606	92.27311962	Caenorhabditis briggsae	6238	Nematoda	Nematoda	121	1.68e-22	NTclustered	gi\|268558427\|ref\|XM_002637158.1\|	6238	g20372	i0	81.944	1.28708133971292	144	24	23	2	338	480	200	58	Caenorhabditis briggsae Protein CBR-EMO-1 (Cbr-emo-1), partial mRNA	blastn	807	121	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
5022136	5022136	PRJNA724011_P_NODE_36604_length_446_cov_2.045576_g35581_i0	PRJNA724011	36604	446	2.045576	9.12326896	root	1	Root_unresolved	Root_unresolved	56.5	0.003	NTclustered	gi\|2445389595\|ref\|XM_003106809.2\|	31234	g35581	i0	94.595	2.02914798206278	37	0	8	2	83	119	917	883	Caenorhabditis remanei uncharacterized protein (GCK72_022175), partial mRNA	blastn	905	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
5814210	5814210	PRJNA724011_P_NODE_4085_length_1526_cov_6.565726_g3623_i0	PRJNA724011	4085	1526	6.565726	100.19297876	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.044	NTclustered	gi\|1831505693\|ref\|NM_001356817.3\|	6239	g3623	i0	100	0.13302752293578	29	0	2	0	350	378	467	495	Caenorhabditis elegans Calponin-homology (CH) domain-containing protein (anc-1), partial mRNA	blastn	203	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7089663	7089663	PRJNA724011_P_NODE_82486_length_272_cov_1.542714_g81463_i0	PRJNA724011	82486	272	1.542714	4.19618208	Caenorhabditis briggsae	6238	Nematoda	Nematoda	52.8	0.025	NTclustered	gi\|268561769\|ref\|XM_002646478.1\|	6238	g81463	i0	96.875	0.117647058823529	32	0	11	1	44	74	363	332	Caenorhabditis briggsae Protein CBR-SNR-2 (Cbr-snr-2), partial mRNA	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
8364061	8364061	PRJNA724011_P_NODE_63047_length_320_cov_1.246964_g62024_i0	PRJNA724011	63047	320	1.246964	3.9902848	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	159	1.7199999999999999e-34	NTclustered	gi\|524845304\|gb\|KC819362.1\|	1355913	g62024	i0	79.556	5.4625	225	44	70	2	11	234	260	37	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 35 (rpl-35) mRNA, partial cds	blastn	1748	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
8364304	8364304	PRJNA724011_P_NODE_97967_length_248_cov_1.548571_g96944_i0	PRJNA724011	97967	248	1.548571	3.84045608	Trichinella pseudospiralis	6337	Nematoda	Nematoda	76.8	1.33e-9	NTclustered	gi\|18265390\|gb\|AF323993.1\|AF323993	6337	g96944	i0	91.071	0.225806451612903	56	5	23	0	1	56	498	553	Trichinella pseudospiralis histone H3.3 mRNA, complete cds	blastn	56	76.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella pseudospiralis
16013529	16013529	PRJNA724011_P_NODE_95993_length_250_cov_0.870056_g94970_i0	PRJNA724011	95993	250	0.870056	2.17514	Pristionchus bucculentus	1317126	Nematoda	Nematoda	235	2.09e-57	NTclustered	gi\|479330856\|gb\|KC463849.1\|	1317126	g94970	i0	85.65	74.496	223	32	89	0	7	229	245	23	Pristionchus bucculentus strain RS5596 small subunit ribosomal protein 14 (rps14) gene, partial cds	blastn	18624	235	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus bucculentus
18562352	18562352	PRJNA724011_P_NODE_33075_length_475_cov_14.136816_g32056_i0	PRJNA724011	33075	475	14.136816	67.149876	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.5e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g32056	i0	81.492	5.46947368421053	362	61	76	6	68	426	37	395	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2598	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
18562513	18562513	PRJNA724011_P_NODE_6015_length_1282_cov_16.191894_g5430_i0	PRJNA724011	6015	1282	16.191894	207.58008108	Loa loa	7209	Nematoda	Nematoda	58.4	0.003	NTclustered	gi\|1158601015\|ref\|XM_020450937.1\|	7209	g5430	i0	100	0.0241809672386895	31	0	2	0	236	266	505	475	Loa loa hypothetical protein partial mRNA	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Loa	Loa loa
19837815	19837815	PRJNA724011_P_NODE_80276_length_277_cov_1.132353_g79253_i0	PRJNA724011	80276	277	1.132353	3.13661781	Parapristionchus giblindavisi	1187980	Nematoda	Nematoda	178	4.029999999999999e-40	NTclustered	gi\|387600364\|gb\|JQ677914.1\|	1187980	g79253	i0	81.364	23.2202166064982	220	39	79	2	1	219	251	33	Diplogastridae gen. sp. EJR-2012 large ribosomal protein 2 mRNA, partial cds	blastn	6432	178	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Parapristionchus	Parapristionchus giblindavisi
24937443	24937443	PRJNA724011_P_NODE_87360_length_262_cov_4.074074_g86337_i0	PRJNA724011	87360	262	4.074074	10.67407388	Crustorhabditis transita	479153	Nematoda	Nematoda	154	6.37e-33	NTclustered	gi\|158821931\|gb\|EU195995.1\|	479153	g86337	i0	94.059	40.0763358778626	101	6	39	0	162	262	1770	1870	Crustorhabditis transita strain SB125 28S ribosomal RNA gene, partial sequence	blastn	10500	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Crustorhabditis	Crustorhabditis transita
25420394	25420394	PRJNA724011_P_NODE_31420_length_491_cov_1.653110_g30401_i0	PRJNA724011	31420	491	1.65311	8.1167701	Caenorhabditis	6237	Nematoda	Nematoda	268	4.37e-67	NTclustered	gi\|268553132\|ref\|XM_002634504.1\|	6238	g30401	i0	80.337	69.8920570264766	356	68	72	2	96	450	83	437	Caenorhabditis briggsae Protein CBR-RPS-14 (Cbr-rps-14), partial mRNA	blastn	34317	268	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
25420426	25420426	PRJNA724011_P_NODE_42920_length_403_cov_0.933333_g41897_i0	PRJNA724011	42920	403	0.933333	3.76133199	Rhabditida	6236	Nematoda	Nematoda	147	1.72e-30	NTclustered	gi\|2437461996\|gb\|ON496988.1\|	31243	g41897	i0	88.281	29.1116625310174	128	7	31	6	25	148	5014	4891	Globodera rostochiensis isolate Ro1-5 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	11732	147	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Globodera	Globodera rostochiensis

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