metadata: contig_metadata: 10 rows where bioproject = "PRJEB673", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJEB673", tax_clade = "Opisthokonta" 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
1409526	1409526	PRJEB673_P_NODE_7622_length_311_cov_1.862319_g7273_i0	PRJEB673	7622	311	1.862319	5.79181209	Aphelenchoides besseyi	269767	Nematoda	Nematoda	63.9	5.07e-10	NR	KAI6186280.1	269767	g7273	i0	87.5	11.9710610932476	40	5	38.6	0	123	4	88	127	KAI6186280.1 Ubiquitin-40S ribosomal protein S27a [Aphelenchoides besseyi]	diamond	3723	63.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides besseyi
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
14163309	14163309	PRJEB673_P_NODE_4572_length_438_cov_1.560794_g4225_i0	PRJEB673	4572	438	1.560794	6.83627772	Metazoa	33208	Nematoda	Nematoda	217	5.83e-68	NR	KHJ48313.1	68888	g4225	i0	69	29.7945205479452	145	45	99.3	0	435	1	31	175	KHJ48313.1 ribosomal protein S2 [Trichuris suis]	diamond	13050	217	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris suis
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
26590621	26590621	PRJEB673_P_NODE_8261_length_290_cov_1.090196_g7912_i0	PRJEB673	8261	290	1.090196	3.1615684	Caenorhabditis auriculariae	2777116	Nematoda	Nematoda	53.9	6.67e-6	NR	CAD6196104.1	2777116	g7912	i0	61.4	1.82068965517241	44	17	45.5	0	289	158	246	289	CAD6196104.1 unnamed protein product [Caenorhabditis auriculariae]	diamond	528	53.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis auriculariae
27950218	27950218	PRJEB673_P_NODE_10525_length_172_cov_1.751825_g10176_i0	PRJEB673	10525	172	1.751825	3.013139	Heterodera trifolii	157864	Nematoda	Nematoda	86.3	4.9e-20	NR	KAL3119136.1	157864	g10176	i0	75.5	1.84883720930233	53	12	90.7	1	158	3	1	53	KAL3119136.1 hypothetical protein niasHT_003919 [Heterodera trifolii]	diamond	318	86.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Heteroderidae	Heterodera	Heterodera trifolii
30128597	30128597	PRJEB673_P_NODE_12612_length_152_cov_2.017094_g12263_i0	PRJEB673	12612	152	2.017094	3.06598288	Pristionchus pacificus	54126	Nematoda	Nematoda	51.2	1.09e-5	NR	KAF8358291.1	54126	g12263	i0	44	0.986842105263158	50	27	98.7	1	1	150	85	133	KAF8358291.1 pitp-1 [Pristionchus pacificus]	diamond	150	51.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus pacificus

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