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

5 rows where analysis = "blastn", bioproject = "PRJEB673" 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
995308	995308	PRJEB673_P_NODE_6841_length_331_cov_2.219595_g6492_i0	PRJEB673	6841	331	2.219595	7.34685945	Opisthokonta	33154	Nematoda	Nematoda	202	2.92e-47	NTclustered	gi\|256709130\|gb\|GQ422217.1\|	669117	g6492	i0	78.248	16.7069486404834	331	60	98	10	1	325	643	319	Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	5530	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus gracilis
11198601	11198601	PRJEB673_P_NODE_10129_length_180_cov_1.379310_g9780_i0	PRJEB673	10129	180	1.37931	2.482758	Metazoa	33208	Nematoda	Nematoda	134	5.3e-27	NTclustered	gi\|2445349451\|ref\|XM_053722956.1\|	31234	g9780	i0	87.395	35.9777777777778	119	11	65	4	40	156	2259	2143	Caenorhabditis remanei uncharacterized protein (GCK72_001419), partial mRNA	blastn	6476	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
11613357	11613357	PRJEB673_P_NODE_10730_length_169_cov_2.000000_g10381_i0	PRJEB673	10730	169	2	3.38	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	113	6.3800000000000005e-21	NTclustered	gi\|150984457\|gb\|EF634871.1\|	452809	g10381	i0	89.011	23.6804733727811	91	10	54	0	1	91	239	329	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	4002	113	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
15437439	15437439	PRJEB673_P_NODE_7193_length_322_cov_1.979094_g6844_i0	PRJEB673	7193	322	1.979094	6.37268268	Caenorhabditis briggsae	6238	Nematoda	Nematoda	267	9.91e-67	NTclustered	gi\|268537031\|ref\|XM_002633606.1\|	6238	g6844	i0	85.944	73.8385093167702	249	35	77	0	11	259	303	55	Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA	blastn	23776	267	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
20535835	20535835	PRJEB673_P_NODE_4797_length_420_cov_2.407792_g4449_i0	PRJEB673	4797	420	2.407792	10.1127264	Rhabditoides inermis	96661	Nematoda	Nematoda	270	1.03e-67	NTclustered	gi\|256709332\|gb\|GQ422341.1\|	96661	g4449	i0	80.737	17.8666666666667	353	62	83	6	61	410	35	384	Rhabditoides inermis large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds	blastn	7504	270	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Rhabditoides	Rhabditoides inermis

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