metadata: contig_metadata: 5 rows where bioproject = "PRJNA999747" and tax

5 rows where bioproject = "PRJNA999747" 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
3531240	3531240	PRJNA999747_S_NODE_623_length_348_cov_5.835962_g591_i0	PRJNA999747	623	348	5.835962	20.30914776	Strongyloides papillosus	174720	Nematoda	Nematoda	239	2.3600000000000003e-58	NTclustered	gi\|374718480\|gb\|JF326458.1\|	174720	g591	i0	81.597	77.0258620689655	288	53	83	0	1	288	288	1	Strongyloides papillosus eukaryotic translation elongation factor a alpha mRNA, complete cds	blastn	26805	239	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
6083768	6083768	PRJNA999747_S_NODE_1785_length_226_cov_2.164103_g1753_i0	PRJNA999747	1785	226	2.164103	4.89087278	Strongyloides ratti	34506	Nematoda	Nematoda	178	3.1799999999999998e-40	NTclustered	gi\|1376142587\|ref\|XM_024651615.1\|	34506	g1753	i0	84.153	21.6946902654867	183	29	81	0	4	186	190	372	Strongyloides ratti Peptidyl-prolyl cis-trans isomerase D (SRAE_2000074500), partial mRNA	blastn	4903	178	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
16283326	16283326	PRJNA999747_S_NODE_233_length_494_cov_7.485961_g206_i0	PRJNA999747	233	494	7.485961	36.98064734	Laimaphelenchus sp. KW_b3	2184103	Nematoda	Nematoda	108	1.01e-18	NTclustered	gi\|1624773620\|dbj\|LC382060.1\|	2184103	g206	i0	85.577	9.60931174089069	104	14	21	1	129	231	334	231	Laimaphelenchus sp. KW_b3 gene for 18S ribosomal RNA, partial sequence	blastn	4747	108	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Laimaphelenchus	Laimaphelenchus sp. KW_b3
20107125	20107125	PRJNA999747_S_NODE_1536_length_244_cov_4.197183_g1504_i0	PRJNA999747	1536	244	4.197183	10.24112652	Protorhabditis sp. DF5055	96771	Nematoda	Nematoda	93.5	1.3e-14	NTclustered	gi\|48869071\|gb\|AY602168.1\|	96771	g1504	i0	84	19.1434426229508	100	13	41	3	21	119	2373	2470	Protorhabditis sp. DF5055 28S large subunit ribosomal RNA gene, partial sequence	blastn	4671	93.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Protorhabditis	Protorhabditis sp. DF5055
26773365	26773365	PRJNA999747_S_NODE_1141_length_279_cov_2.536290_g1109_i0	PRJNA999747	1141	279	2.53629	7.0762491	Pristionchus mayeri	1317129	Nematoda	Nematoda	77.8	1.05e-14	NR	GMR57945.1	1317129	g1109	i0	72.7	0.946236559139785	88	24	94.6	0	8	271	142	229	GMR57945.1 hypothetical protein PMAYCL1PPCAC_28140, partial [Pristionchus mayeri]	diamond	264	77.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus mayeri

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