metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA689790" 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
3219560	3219560	PRJNA689790_S_NODE_12163_length_171_cov_1.559701_g12048_i0	PRJNA689790	12163	171	1.559701	2.66708871	Strongyloides papillosus	174720	Nematoda	Nematoda	93.5	8.44e-15	NTclustered	gi\|687022643\|emb\|LM525557.1\|	174720	g12048	i0	90.141	4.87719298245614	71	7	42	0	7	77	633166	633096	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000003	blastn	834	93.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
7556075	7556075	PRJNA689790_S_NODE_726_length_801_cov_5.972513_g656_i0	PRJNA689790	726	801	5.972513	47.83982913	Metazoa	33208	Nematoda	Nematoda	525	3.939999999999999e-144	NTclustered	gi\|1376146183\|ref\|XM_024653652.1\|	34506	g656	i0	81.335	68.9550561797753	659	111	82	12	149	801	1542	890	Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA	blastn	55233	525	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
8321867	8321867	PRJNA689790_S_NODE_2527_length_403_cov_2.489071_g2412_i0	PRJNA689790	2527	403	2.489071	10.03095613	Strongyloides ratti	34506	Nematoda	Nematoda	263	1.64e-65	NTclustered	gi\|1376144539\|ref\|XM_024652732.1\|	34506	g2412	i0	80.398	43.9875930521092	352	63	87	6	3	351	102	450	Strongyloides ratti 40S ribosomal protein S14 (SRAE_2000174400), partial mRNA	blastn	17727	263	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
17246644	17246644	PRJNA689790_S_NODE_5434_length_257_cov_4.054545_g5319_i0	PRJNA689790	5434	257	4.054545	10.42018065	Plectus acuminatus	70689	Nematoda	Nematoda	259	1.28e-64	NTclustered	gi\|3860543\|emb\|AJ012665.1\|	70689	g5319	i0	85.714	92.8832684824903	245	35	95	0	1	245	302	58	Plectus acuminatus mRNA for actin	blastn	23871	259	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Plectida	Plectidae	Plectus	Plectus acuminatus
21071190	21071190	PRJNA689790_S_NODE_7877_length_210_cov_3.167630_g7762_i0	PRJNA689790	7877	210	3.16763	6.652023	Strongyloides papillosus	174720	Nematoda	Nematoda	150	6.35e-32	NTclustered	gi\|687022666\|emb\|LM525580.1\|	174720	g7762	i0	81.026	8.2952380952381	195	32	91	5	9	200	237138	237330	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000007	blastn	1742	150	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus

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