metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1010780" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1010780" 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
2705423	2705423	PRJNA1010780_S_NODE_40003_length_207_cov_1.656977_g38714_i0	PRJNA1010780	40003	207	1.656977	3.42994239	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.018	NTclustered	gi\|687022751\|emb\|LM525665.1\|	174720	g38714	i0	100	0.135265700483092	28	0	14	0	176	203	29685	29658	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000045	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
9082756	9082756	PRJNA1010780_S_NODE_62368_length_151_cov_3.043103_g61079_i0	PRJNA1010780	62368	151	3.043103	4.59508553	Strongyloides ratti	34506	Nematoda	Nematoda	150	4.2499999999999996e-32	NTclustered	gi\|1376153239\|ref\|XM_024645220.1\|	34506	g61079	i0	87.597	22.8543046357616	129	16	85	0	1	129	1028	900	Strongyloides ratti ATPase, F1/V1/A1 complex, alpha/beta subunit, nucleotide-binding domain and ATPase, F1/V1/A1 complex, alpha/beta subunit, C-terminal domain and ATPase, F1 complex alpha/beta subunit, N-terminal domain and ATPase, V1 complex, subunit A family and V-type ATP synthase catalytic alpha chain family and ATPase, F1 complex beta subunit/V1 complex, C-terminal domain and P-loop containing nucleoside triphosphate hydrolase domain-containing protein (SRAE_X000082900), partial mRNA	blastn	3451	150	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
11633751	11633751	PRJNA1010780_S_NODE_36730_length_221_cov_40.064516_g35441_i0	PRJNA1010780	36730	221	40.064516	88.54258036	Caenorhabditis briggsae	6238	Nematoda	Nematoda	84.2	6.95e-12	NTclustered	gi\|268564774\|ref\|XM_002639178.1\|	6238	g35441	i0	96.078	15.9366515837104	51	2	23	0	101	151	401	351	Caenorhabditis briggsae Protein CBG03775 (CBG03775), partial mRNA	blastn	3522	84.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
16732047	16732047	PRJNA1010780_S_NODE_39834_length_207_cov_9.412791_g38545_i0	PRJNA1010780	39834	207	9.412791	19.48447737	Strongyloides ratti	34506	Nematoda	Nematoda	73.1	1.39e-8	NTclustered	gi\|1376144067\|ref\|XM_024652464.1\|	34506	g38545	i0	89.474	1.06280193236715	57	6	28	0	5	61	319	375	Strongyloides ratti Histone H3 (SRAE_2000150400), partial mRNA	blastn	220	73.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
16732133	16732133	PRJNA1010780_S_NODE_62634_length_151_cov_1.793103_g61345_i0	PRJNA1010780	62634	151	1.793103	2.70758553	Strongyloides ratti	34506	Nematoda	Nematoda	139	9.19e-29	NTclustered	gi\|1376146183\|ref\|XM_024653652.1\|	34506	g61345	i0	84	26.8211920529801	150	18	97	6	3	149	873	727	Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA	blastn	4050	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
21403628	21403628	PRJNA1010780_S_NODE_40997_length_203_cov_1.755952_g39708_i0	PRJNA1010780	40997	203	1.755952	3.56458256	Caenorhabditis	6237	Nematoda	Nematoda	193	9.99e-45	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g39708	i0	84	20.871921182266	200	32	99	0	4	203	377	178	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	4237	193	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
21831884	21831884	PRJNA1010780_S_NODE_27978_length_283_cov_2.947581_g26689_i0	PRJNA1010780	27978	283	2.947581	8.34165423	Strongyloides papillosus	174720	Nematoda	Nematoda	93.5	1.54e-14	NTclustered	gi\|374718486\|gb\|JF326461.1\|	174720	g26689	i0	94.915	3.55123674911661	59	3	21	0	19	77	421	479	Strongyloides papillosus glyceraldehyde-3-phosphate dehydrogenase mRNA, partial cds	blastn	1005	93.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
24381104	24381104	PRJNA1010780_S_NODE_17940_length_452_cov_2.822542_g16665_i0	PRJNA1010780	17940	452	2.822542	12.75788984	Loa loa	7209	Nematoda	Nematoda	204	1.14e-47	NTclustered	gi\|1158591300\|ref\|XM_003136814.2\|	7209	g16665	i0	88.235	6.70132743362832	170	20	38	0	20	189	759	928	Loa loa CK1/CK1/CK1-A protein kinase mRNA	blastn	3029	204	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Loa	Loa loa

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