metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA376117" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA376117" 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
3624560	3624560	PRJNA376117_P_NODE_8123_length_470_cov_2.481108_g7822_i0	PRJNA376117	8123	470	2.481108	11.6612076	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	431	5.0199999999999983e-116	NTclustered	gi\|1376144465\|ref\|XM_024652690.1\|	34506	g7822	i0	83.405	96.7617021276596	464	77	99	0	7	470	987	524	Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_2000170700), partial mRNA	blastn	45478	431	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
6777507	6777507	PRJNA376117_P_NODE_26486_length_278_cov_1.126829_g26184_i0	PRJNA376117	26486	278	1.126829	3.13258462	Pristionchus sp. 15 RS5229	452809	Nematoda	Nematoda	305	1.78e-78	NTclustered	gi\|150984495\|gb\|EF634890.1\|	452809	g26184	i0	87.266	96.0071942446043	267	34	96	0	10	276	393	127	Pristionchus sp. 15 RS5229 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	26690	305	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 15 RS5229
9327969	9327969	PRJNA376117_P_NODE_27428_length_274_cov_1.532338_g27126_i0	PRJNA376117	27428	274	1.532338	4.19860612	Strongyloides papillosus	174720	Nematoda	Nematoda	265	2.97e-66	NTclustered	gi\|687022643\|emb\|LM525557.1\|	174720	g27126	i0	90.863	71.6423357664234	197	18	72	0	73	269	634366	634170	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000003	blastn	19630	265	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
14428904	14428904	PRJNA376117_P_NODE_7212_length_499_cov_7.223005_g6911_i0	PRJNA376117	7212	499	7.223005	36.04279495	Caenorhabditis elegans	6239	Nematoda	Nematoda	54.7	0.014	NTclustered	gi\|1831517864\|ref\|NM_001136422.4\|	6239	g6911	i0	100	0.232464929859719	29	0	6	0	54	82	8	36	Caenorhabditis elegans FIP (Fungus-Induced Protein) Related (fipr-2), partial mRNA	blastn	116	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
20801213	20801213	PRJNA376117_P_NODE_19557_length_312_cov_2.167364_g19255_i0	PRJNA376117	19557	312	2.167364	6.76217568	Strongyloides ratti	34506	Nematoda	Nematoda	233	9.71e-57	NTclustered	gi\|1376156759\|ref\|XM_024645793.1\|	34506	g19255	i0	81.884	49.4839743589744	276	50	88	0	6	281	276	1	Strongyloides ratti Ras-like protein 3 (SRAE_X000250800), partial mRNA	blastn	15439	233	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
24626000	24626000	PRJNA376117_P_NODE_20100_length_308_cov_1.902128_g19798_i0	PRJNA376117	20100	308	1.902128	5.85855424	Caenorhabditis briggsae	6238	Nematoda	Nematoda	137	7.7199999999999995e-28	NTclustered	gi\|268530073\|ref\|XM_002630117.1\|	6238	g19798	i0	85.606	4.87662337662338	132	17	43	2	42	172	124	254	Caenorhabditis briggsae Protein CBR-IFF-2 (Cbr-iff-2), partial mRNA	blastn	1502	137	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);;