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

5 rows where analysis = "blastn", bioproject = "PRJNA235310" 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
10571467	10571467	PRJNA235310_P_NODE_669_length_474_cov_12.367059_g643_i0	PRJNA235310	669	474	12.367059	58.61985966	Pristionchus pauli	376545	Nematoda	Nematoda	292	2.5e-74	NTclustered	gi\|150982019\|gb\|EF634598.1\|	376545	g643	i0	81.492	4.75949367088608	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
11259841	11259841	PRJNA235310_P_NODE_1969_length_281_cov_1.655172_g1943_i0	PRJNA235310	1969	281	1.655172	4.65103332	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	158	5.34e-34	NTclustered	gi\|687866031\|emb\|LK927873.1\|	6239	g1943	i0	87.5	136.355871886121	136	17	48	0	1	136	46183	46318	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000295	blastn	38316	159	0.993710691823899	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
13810054	13810054	PRJNA235310_P_NODE_3791_length_194_cov_1.075862_g3765_i0	PRJNA235310	3791	194	1.075862	2.08717228	Opisthokonta	33154	Nematoda	Nematoda	183	5.69e-42	NTclustered	gi\|675118991\|gb\|KJ877375.1\|	1538693	g3765	i0	85.393	54.288659793814404	178	24	91	2	18	194	408	232	Diplogastrellus sp. VS-2014 strain RS5608 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	10532	183	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus sp. VS-2014
17634245	17634245	PRJNA235310_P_NODE_474_length_540_cov_16.926680_g450_i0	PRJNA235310	474	540	16.92668	91.404072	Metazoa	33208	Nematoda	Nematoda	324	1.02e-83	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g450	i0	82.692	66.6333333333333	364	63	67	0	65	428	55	418	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	35982	327	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
20768910	20768910	PRJNA235310_P_NODE_477_length_539_cov_6.659184_g453_i0	PRJNA235310	477	539	6.659184	35.89300176	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	167	1.81e-36	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g453	i0	81.166	24.7458256029685	223	28	40	11	249	464	264	49	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

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