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

5 rows where analysis = "blastn", bioproject = "PRJNA846486" 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
1231409	1231409	PRJNA846486_P_NODE_33901_length_230_cov_1.149171_g33805_i0	PRJNA846486	33901	230	1.149171	2.6430933	Propanagrolaimus	1510670	Nematoda	Nematoda	113	9.29e-21	NTclustered	gi\|662563250\|gb\|KJ434174.1\|	1519088	g33805	i0	84.034	33.9086956521739	119	17	52	2	112	230	1341	1225	Propanagrolaimus sp. LC91 28S ribosomal RNA gene, partial sequence	blastn	7799	113	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Propanagrolaimus	Propanagrolaimus sp. LC91
2108664	2108664	PRJNA846486_P_NODE_23182_length_269_cov_1.322727_g23086_i0	PRJNA846486	23182	269	1.322727	3.55813563	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	196	1.08e-45	NTclustered	gi\|150982261\|gb\|EF634719.1\|	452809	g23086	i0	82.805	8.6728624535316	221	34	81	4	2	220	248	30	Pristionchus sp. 15 RS5229 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds	blastn	2333	196	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
9761356	9761356	PRJNA846486_P_NODE_69348_length_175_cov_1.238095_g69252_i0	PRJNA846486	69348	175	1.238095	2.16666625	Caenorhabditis elegans	6239	Nematoda	Nematoda	309	7.920000000000001e-80	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g69252	i0	99.412	25.8514285714286	170	1	97	0	1	170	28779	28610	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	4524	309	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
13985223	13985223	PRJNA846486_P_NODE_44991_length_206_cov_1.242038_g44895_i0	PRJNA846486	44991	206	1.242038	2.55859828	Panagrolaimus	55784	Nematoda	Nematoda	182	2.2e-41	NTclustered	gi\|221327484\|gb\|FJ591015.1\|	310956	g44895	i0	82.857	3.05825242718447	210	29	100	6	1	206	346	140	Panagrolaimus detritophagus 28S ribosomal RNA gene, partial sequence	blastn	630	182	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Panagrolaimidae	Panagrolaimus	Panagrolaimus detritophagus
19959613	19959613	PRJNA846486_P_NODE_18876_length_293_cov_1.647541_g18780_i0	PRJNA846486	18876	293	1.647541	4.82729513	Caenorhabditis briggsae	6238	Nematoda	Nematoda	300	8.790000000000001e-77	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g18780	i0	87.938	90.8634812286689	257	27	87	4	36	290	1307	1053	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	26623	300	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae

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