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

8 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
10213752	10213752	PRJDB9741_P_NODE_33829_length_164_cov_0.886957_g33512_i0	PRJDB9741	33829	164	0.886957	1.45460948	Meloidogyne graminicola	189291	Nematoda	Nematoda	132	1.71e-26	NTclustered	gi\|2003945648\|gb\|MT259203.1\|	189291	g33512	i0	81.098	58.1768292682927	164	31	100	0	1	164	2161	2324	Meloidogyne graminicola voltage-dependent calcium channel non-L type alpha-1 mRNA, complete cds	blastn	9541	132	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
10213821	10213821	PRJDB9741_P_NODE_5789_length_261_cov_2.759434_g5473_i0	PRJDB9741	5789	261	2.759434	7.20212274	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	182	2.91e-41	NTclustered	gi\|150982023\|gb\|EF634600.1\|	452805	g5473	i0	90.511	12.6513409961686	137	13	52	0	124	260	392	256	Pristionchus sp. 10 RS5133 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	3302	182	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133
10213852	10213852	PRJDB9741_P_NODE_7889_length_224_cov_1.165714_g7572_i0	PRJDB9741	7889	224	1.165714	2.61119936	Neodiplogaster sp. WEM-2009	669148	Nematoda	Nematoda	154	5.3e-33	NTclustered	gi\|256709213\|gb\|GQ422259.1\|	669148	g7572	i0	88.06	36.9866071428571	134	11	58	4	32	161	135	3	Neodiplogaster sp. WEM-2009 small subunit ribosomal protein 28 (rps-28) mRNA, partial cds	blastn	8285	154	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Neodiplogaster	Neodiplogaster sp. WEM-2009
12764622	12764622	PRJDB9741_P_NODE_6691_length_242_cov_2.725389_g6374_i0	PRJDB9741	6691	242	2.725389	6.59544138	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	145	3.5e-30	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g6374	i0	80.203	26.4628099173554	197	35	81	3	1	195	135	329	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	6404	145	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
17862905	17862905	PRJDB9741_P_NODE_7675_length_227_cov_0.921348_g7358_i0	PRJDB9741	7675	227	0.921348	2.09145996	Pristionchus racemosae	1756234	Nematoda	Nematoda	80.5	9.27e-11	NTclustered	gi\|953064353\|gb\|KT188888.1\|	1756234	g7358	i0	85.897	10.352422907489	78	7	33	4	151	226	1923	1998	Pristionchus racemosae 28S ribosomal RNA gene, partial sequence	blastn	2350	80.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus racemosae
19136297	19136297	PRJDB9741_P_NODE_10656_length_202_cov_1.575163_g10339_i0	PRJDB9741	10656	202	1.575163	3.18182926	Caenorhabditis elegans	6239	Nematoda	Nematoda	230	7.569999999999998e-56	NTclustered	gi\|1972294218\|ref\|NM_001380754.2\|	6239	g10339	i0	89.944	86.2178217821782	179	17	89	1	24	202	1159	982	Caenorhabditis elegans Actin-3 (act-3), mRNA	blastn	17416	230	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
19136496	19136496	PRJDB9741_P_NODE_3556_length_357_cov_1.581169_g3240_i0	PRJDB9741	3556	357	1.581169	5.64477333	Caenorhabditis remanei	31234	Nematoda	Nematoda	213	1.47e-50	NTclustered	gi\|2445362687\|ref\|XM_053726842.1\|	31234	g3240	i0	78.551	53.781512605042	345	58	94	11	1	337	763	427	Caenorhabditis remanei uncharacterized protein (GCK72_008464), partial mRNA	blastn	19200	213	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
21687560	21687560	PRJDB9741_P_NODE_34278_length_164_cov_0.886957_g33961_i0	PRJDB9741	34278	164	0.886957	1.45460948	Pristionchus sp. 14 RS5230	452808	Nematoda	Nematoda	139	1.02e-28	NTclustered	gi\|150984418\|gb\|EF634851.1\|	452808	g33961	i0	86.508	20.5975609756098	126	17	77	0	2	127	134	9	Pristionchus sp. 14 RS5230 small subunit ribosomal protein 1 (rps-1) mRNA, partial cds	blastn	3378	139	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 14 RS5230

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