metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA643700" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA643700" 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
1894303	1894303	PRJNA643700_P_NODE_227442_length_255_cov_4.199029_g225886_i0	PRJNA643700	227442	255	4.199029	10.70752395	Strongyloides ratti	34506	Nematoda	Nematoda	52.8	0.023	NTclustered	gi\|1376134401\|ref\|XM_024647160.1\|	34506	g225886	i0	100	0.109803921568627	28	0	11	0	221	248	141	168	Strongyloides ratti N-alpha-acetyltransferase 35, NatC auxiliary subunit (SRAE_1000033900), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
4445766	4445766	PRJNA643700_P_NODE_205224_length_274_cov_1.155556_g203668_i0	PRJNA643700	205224	274	1.155556	3.16622344	Caenorhabditis elegans	6239	Nematoda	Nematoda	52.8	0.025	NTclustered	gi\|687865582\|emb\|LK927621.1\|	6239	g203668	i0	100	0.204379562043796	28	0	10	0	15	42	136086	136059	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000084	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
15920883	15920883	PRJNA643700_P_NODE_111733_length_393_cov_2.485465_g110179_i0	PRJNA643700	111733	393	2.485465	9.76787745	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.038	NTclustered	gi\|690020008\|emb\|LM527523.1\|	174720	g110179	i0	100	0.0712468193384224	28	0	7	0	121	148	328	301	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000112	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
15920966	15920966	PRJNA643700_P_NODE_234053_length_251_cov_1.029703_g232497_i0	PRJNA643700	234053	251	1.029703	2.58455453	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.023	NTclustered	gi\|687022698\|emb\|LM525612.1\|	174720	g232497	i0	92.105	0.151394422310757	38	2	15	1	37	74	40236	40200	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000022	blastn	38	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
17196138	17196138	PRJNA643700_P_NODE_38234_length_660_cov_2.746318_g36885_i0	PRJNA643700	38234	660	2.746318	18.1256988	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.018	NTclustered	gi\|351061203\|emb\|FO081081.1\|	6239	g36885	i0	100	0.0878787878787879	29	0	4	0	203	231	36070	36042	Caenorhabditis elegans Cosmid F54D7, complete sequence	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
24844535	24844535	PRJNA643700_P_NODE_331940_length_194_cov_1.075862_g330384_i0	PRJNA643700	331940	194	1.075862	2.08717228	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.017	NTclustered	gi\|690018472\|emb\|LM525710.1\|	174720	g330384	i0	100	0.288659793814433	28	0	14	0	93	120	77094	77067	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000106	blastn	56	52.8	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);;