metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA195897" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA195897" 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
2916621	2916621	PRJNA195897_P_NODE_1263_length_472_cov_10.801418_g1231_i0	PRJNA195897	1263	472	10.801418	50.98269296	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.48e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g1231	i0	81.492	4.77966101694915	362	61	76	6	48	406	395	37	Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	2256	292	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pauli
4193055	4193055	PRJNA195897_P_NODE_1944_length_368_cov_2.639498_g1911_i0	PRJNA195897	1944	368	2.639498	9.71335264	Fictor sp. 2 VS-2014	1538695	Nematoda	Nematoda	182	4.27e-41	NTclustered	gi\|675118979\|gb\|KJ877369.1\|	1538695	g1911	i0	82.297	3.52445652173913	209	35	57	2	73	280	399	192	Fictor sp. 2 VS-2014 strain RS9002 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	1297	182	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Fictor	Fictor sp. 2 VS-2014
4193120	4193120	PRJNA195897_P_NODE_984_length_538_cov_10.449898_g953_i0	PRJNA195897	984	538	10.449898	56.22045124	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	167	1.81e-36	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g953	i0	81.166	24.7918215613383	223	28	40	11	75	290	49	264	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	13338	167	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
8019395	8019395	PRJNA195897_P_NODE_8847_length_169_cov_2.166667_g8814_i0	PRJNA195897	8847	169	2.166667	3.66166723	Pristionchus sp. 11 RS5228	452806	Nematoda	Nematoda	135	1.3600000000000002e-27	NTclustered	gi\|150984677\|gb\|EF635000.1\|	452806	g8814	i0	86.047	38.3195266272189	129	15	75	1	32	157	201	73	Pristionchus sp. 11 RS5228 small subunit ribosomal protein 28 (rps-28) mRNA, complete cds	blastn	6476	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 11 RS5228
9294055	9294055	PRJNA195897_P_NODE_2608_length_309_cov_2.011538_g2575_i0	PRJNA195897	2608	309	2.011538	6.21565242	Brugia malayi	6279	Nematoda	Nematoda	159	1.65e-34	NTclustered	gi\|2082273969\|ref\|XM_001902266.2\|	6279	g2575	i0	81.068	34.1229773462783	206	33	66	6	2	204	139	341	Brugia malayi ubiquitin-like protein, putative (Bma-ubq-2), partial mRNA	blastn	10544	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
13119754	13119754	PRJNA195897_P_NODE_2411_length_323_cov_7.704380_g2378_i0	PRJNA195897	2411	323	7.70438	24.8851474	Caenorhabditis remanei	31234	Nematoda	Nematoda	78.7	5e-10	NTclustered	gi\|2445352248\|ref\|XM_053723719.1\|	31234	g2378	i0	94.118	0.554179566563467	51	3	16	0	227	277	282	232	Caenorhabditis remanei uncharacterized protein (GCK72_002963), partial mRNA	blastn	179	78.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
14395103	14395103	PRJNA195897_P_NODE_9252_length_169_cov_0.866667_g9219_i0	PRJNA195897	9252	169	0.866667	1.46466723	Caenorhabditis briggsae	6238	Nematoda	Nematoda	104	3.84e-18	NTclustered	gi\|268534083\|ref\|XM_002632126.1\|	6238	g9219	i0	82.5	1.59763313609467	120	19	70	2	11	129	284	166	Caenorhabditis briggsae Protein CBG07031 (CBG07031), partial mRNA	blastn	270	104	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
15082844	15082844	PRJNA195897_P_NODE_7252_length_185_cov_1.529412_g7219_i0	PRJNA195897	7252	185	1.529412	2.8294122	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	54.7	0.004	NTclustered	gi\|1366767161\|gb\|AC277404.1\|	51029	g7219	i0	100	4.55135135135135	29	0	16	0	157	185	307	279	Heterodera glycines strain TN20 clone GNFT81-D04, complete sequence	blastn	842	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera glycines
18217699	18217699	PRJNA195897_P_NODE_6655_length_192_cov_1.090909_g6622_i0	PRJNA195897	6655	192	1.090909	2.09454528	Caenorhabditis remanei	31234	Nematoda	Nematoda	117	5.78e-22	NTclustered	gi\|2445362618\|ref\|XM_003094595.2\|	31234	g6622	i0	89.247	19.6979166666667	93	10	48	0	100	192	301	209	Caenorhabditis remanei uncharacterized protein (GCK72_008429), partial mRNA	blastn	3782	117	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
20767553	20767553	PRJNA195897_P_NODE_8357_length_174_cov_1.248000_g8324_i0	PRJNA195897	8357	174	1.248	2.17152	Bursaphelenchus xylophilus	6326	Nematoda	Nematoda	108	3.08e-19	NTclustered	gi\|268619113\|gb\|GU130140.1\|	6326	g8324	i0	78.916	2.35057471264368	166	29	94	3	3	165	167	5	Bursaphelenchus xylophilus 60S ribosomal protein L8 mRNA, complete cds	blastn	409	108	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Bursaphelenchus	Bursaphelenchus xylophilus
22042621	22042621	PRJNA195897_P_NODE_4698_length_221_cov_1.825581_g4665_i0	PRJNA195897	4698	221	1.825581	4.03453401	Pristionchus sp. 13 RS5231	452807	Nematoda	Nematoda	82.4	2.5e-11	NTclustered	gi\|150982219\|gb\|EF634698.1\|	452807	g4665	i0	87.324	1.78733031674208	71	9	32	0	116	186	71	1	Pristionchus sp. 13 RS5231 large subunit ribosomal protein 29 (rpl-29) mRNA, complete cds	blastn	395	82.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 13 RS5231

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