metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA915212" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA915212" 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
3803052	3803052	PRJNA915212_P_NODE_15183_length_155_cov_3.245283_g15145_i0	PRJNA915212	15183	155	3.245283	5.03018865	Metazoa	33208	Nematoda	Nematoda	67.6	4.55e-7	NTclustered	gi\|1734332180\|ref\|NM_001268834.2\|	6239	g15145	i0	90.566	2.63225806451613	53	1	33	3	54	104	68	18	Caenorhabditis elegans 60S ribosomal protein L29 (rpl-29), mRNA	blastn	408	67.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7273407	7273407	PRJNA915212_P_NODE_7346_length_216_cov_0.910180_g7308_i0	PRJNA915212	7346	216	0.91018	1.9659888	Caenorhabditis elegans	6239	Nematoda	Nematoda	158	3.93e-34	NTclustered	gi\|1972263330\|ref\|NM_065710.8\|	6239	g7308	i0	84.242	4.625	165	22	75	4	1	163	741	579	Caenorhabditis elegans ATP synthase subunit beta, mitochondrial (atp-2), mRNA	blastn	999	158	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
7629123	7629123	PRJNA915212_P_NODE_1506_length_543_cov_2.860324_g1471_i0	PRJNA915212	1506	543	2.860324	15.53155932	Opisthokonta	33154	Nematoda	Nematoda	348	6.08e-91	NTclustered	gi\|150984497\|gb\|EF634891.1\|	358044	g1471	i0	82.776	69.1915285451197	389	67	72	0	85	473	47	435	Koerneria sp. RS1982 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	37571	350	0.994285714285714	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Koerneria	Koerneria sp. RS1982
12374296	12374296	PRJNA915212_P_NODE_3290_length_347_cov_4.187919_g3253_i0	PRJNA915212	3290	347	4.187919	14.53207893	Pristionchus hoplostomus	1355913	Nematoda	Nematoda	161	5.23e-35	NTclustered	gi\|524845312\|gb\|KC819366.1\|	1355913	g3253	i0	80.717	30.5561959654179	223	29	62	11	65	280	264	49	Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds	blastn	10603	161	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus hoplostomus
13648703	13648703	PRJNA915212_P_NODE_10531_length_177_cov_1.710938_g10493_i0	PRJNA915212	10531	177	1.710938	3.02836026	Pristionchus sp. 13 RS5231	452807	Nematoda	Nematoda	121	4.039999999999999e-23	NTclustered	gi\|150981877\|gb\|EF634508.1\|	452807	g10493	i0	79.31	12.6497175141243	174	34	98	2	5	177	265	93	Pristionchus sp. 13 RS5231 large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds	blastn	2239	121	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 13 RS5231
18746704	18746704	PRJNA915212_P_NODE_15135_length_160_cov_2.297297_g15097_i0	PRJNA915212	15135	160	2.297297	3.6756752	Strongyloides ratti	34506	Nematoda	Nematoda	169	1.26e-37	NTclustered	gi\|1376151079\|ref\|XM_024644001.1\|	34506	g15097	i0	85.987	162.275	157	22	98	0	1	157	2	158	Strongyloides ratti Ubiquitin-60S ribosomal protein L40 (SRAE_2000504200), partial mRNA	blastn	25964	169	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
18746734	18746734	PRJNA915212_P_NODE_3315_length_346_cov_2.138047_g3278_i0	PRJNA915212	3315	346	2.138047	7.39764262	Levipalatum texanum	1486449	Nematoda	Nematoda	200	1.11e-46	NTclustered	gi\|610559467\|gb\|KJ395558.1\|	1486449	g3278	i0	82.158	3.03179190751445	241	35	68	6	56	292	384	148	Levipalatum texanum ribosomal protein (rpl-23) gene, partial cds	blastn	1049	200	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Levipalatum	Levipalatum texanum
22572171	22572171	PRJNA915212_P_NODE_10078_length_182_cov_1.533835_g10040_i0	PRJNA915212	10078	182	1.533835	2.7915797	Acrostichus sp. RS5083	669107	Nematoda	Nematoda	183	5.259999999999998e-42	NTclustered	gi\|256709251\|gb\|GQ422278.1\|	669107	g10040	i0	89.189	52.7252747252747	148	14	81	2	36	182	22	168	Acrostichus sp. RS5083 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	9596	183	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Acrostichus	Acrostichus sp. RS5083
22572219	22572219	PRJNA915212_P_NODE_3758_length_318_cov_1.736059_g3720_i0	PRJNA915212	3758	318	1.736059	5.52066762	Diplogastrellus gracilis	669117	Nematoda	Nematoda	187	7.83e-43	NTclustered	gi\|256709130\|gb\|GQ422217.1\|	669117	g3720	i0	80.816	70.374213836478	245	41	76	5	74	315	723	482	Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds	blastn	22379	187	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Diplogastrellus	Diplogastrellus gracilis

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