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

9 rows where analysis = "blastn", bioproject = "PRJNA270367" 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
370117	370117	PRJNA270367_P_NODE_37821_length_174_cov_1.096000_g37616_i0	PRJNA270367	37821	174	1.096	1.90704	Brugia malayi	6279	Nematoda	Nematoda	69.4	1.45e-7	NTclustered	gi\|2082284822\|ref\|XM_043080429.1\|	6279	g37616	i0	88.136	8.95402298850575	59	5	33	2	115	172	236	179	Brugia malayi Uncharacterized protein (Bma-rab-10), partial mRNA	blastn	1558	69.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
370164	370164	PRJNA270367_P_NODE_42501_length_166_cov_0.888889_g42296_i0	PRJNA270367	42501	166	0.888889	1.47555574	Pristionchus boliviae	1317127	Nematoda	Nematoda	141	2.88e-29	NTclustered	gi\|478486924\|gb\|KC491641.1\|	1317127	g42296	i0	90.566	78.2469879518072	106	10	64	0	1	106	137	32	Pristionchus boliviae strain RS5262 large subunit ribosomal protein 27a (rpl27a) gene, partial cds	blastn	12989	141	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus boliviae
2920501	2920501	PRJNA270367_P_NODE_10883_length_401_cov_7.471591_g10681_i0	PRJNA270367	10883	401	7.471591	29.96107991	Pristionchus sp. 13 RS5231	452807	Nematoda	Nematoda	82.4	4.9e-11	NTclustered	gi\|150982219\|gb\|EF634698.1\|	452807	g10681	i0	87.324	0.99501246882793	71	9	18	0	28	98	1	71	Pristionchus sp. 13 RS5231 large subunit ribosomal protein 29 (rpl-29) mRNA, complete cds	blastn	399	82.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 13 RS5231
13811656	13811656	PRJNA270367_P_NODE_38451_length_172_cov_1.154472_g38246_i0	PRJNA270367	38451	172	1.154472	1.98569184	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	167	4.939999999999999e-37	NTclustered	gi\|687865697\|emb\|LK927572.1\|	6239	g38246	i0	85.987	111.674418604651	157	20	91	2	1	156	120158	120003	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000039	blastn	19208	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
16947218	16947218	PRJNA270367_P_NODE_12354_length_374_cov_2.135385_g12152_i0	PRJNA270367	12354	374	2.135385	7.9863399	Strongyloides papillosus	174720	Nematoda	Nematoda	263	1.51e-65	NTclustered	gi\|690018634\|emb\|LM525872.1\|	174720	g12152	i0	82.508	73.3181818181818	303	49	80	4	69	369	4841	5141	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000249	blastn	27421	263	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
16947346	16947346	PRJNA270367_P_NODE_24654_length_232_cov_1.579235_g24449_i0	PRJNA270367	24654	232	1.579235	3.6638252	Strongyloides papillosus	174720	Nematoda	Nematoda	176	1.18e-39	NTclustered	gi\|690018450\|emb\|LM525688.1\|	174720	g24449	i0	80.702	88.3103448275862	228	42	98	2	4	230	81985	81759	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000085	blastn	20488	176	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
19496079	19496079	PRJNA270367_P_NODE_40316_length_168_cov_1.310924_g40111_i0	PRJNA270367	40316	168	1.310924	2.20235232	Strongyloides ratti	34506	Nematoda	Nematoda	130	6.34e-26	NTclustered	gi\|1376137879\|ref\|XM_024649115.1\|	34506	g40111	i0	81.818	11.2678571428571	165	21	96	9	1	161	1013	1172	Strongyloides ratti Pyruvate kinase (SRAE_1000208200), partial mRNA	blastn	1893	130	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
22046392	22046392	PRJNA270367_P_NODE_10938_length_400_cov_2.444444_g10736_i0	PRJNA270367	10938	400	2.444444	9.777776	Caenorhabditis briggsae	6238	Nematoda	Nematoda	315	4.43e-81	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g10736	i0	87.143	71.5225	280	32	70	4	122	399	1307	1030	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	28609	315	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
23322008	23322008	PRJNA270367_P_NODE_24919_length_230_cov_2.287293_g24714_i0	PRJNA270367	24919	230	2.287293	5.2607739	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	154	5.47e-33	NTclustered	gi\|256709336\|gb\|GQ422343.1\|	669147	g24714	i0	84.868	5.48695652173913	152	23	66	0	45	196	250	401	Tylopharynx sp. WEM-2009 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	1262	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009

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