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

9 rows where analysis = "blastn", bioproject = "PRJNA893346" 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
2144001	2144001	PRJNA893346_P_NODE_7642_length_577_cov_1.865079_g7166_i0	PRJNA893346	7642	577	1.865079	10.76150583	Pseudocapillaria tomentosa	1904821	Nematoda	Nematoda	1038	0	NTclustered	gi\|2095998828\|gb\|MZ708958.1\|	1904821	g7166	i0	99.133	61.3067590987868	577	5	100	0	1	577	6230	5654	Pseudocapillaria tomentosa mitochondrion, complete genome	blastn	35374	1038	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Capillariidae	Pseudocapillaria	Pseudocapillaria tomentosa
9796158	9796158	PRJNA893346_P_NODE_29068_length_277_cov_1.892157_g28578_i0	PRJNA893346	29068	277	1.892157	5.24127489	Caenorhabditis elegans	6239	Nematoda	Nematoda	180	1.1199999999999999e-40	NTclustered	gi\|1972235517\|ref\|NM_001026355.6\|	6239	g28578	i0	78.598	14.086642599278001	271	58	98	0	7	277	842	572	Caenorhabditis elegans ATP synthase subunit alpha, mitochondrial (atp-1), mRNA	blastn	3902	180	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
13622390	13622390	PRJNA893346_P_NODE_9991_length_498_cov_6.016471_g9507_i0	PRJNA893346	9991	498	6.016471	29.96202558	Pseudocapillaria tomentosa	1904821	Nematoda	Nematoda	909	0	NTclustered	gi\|2095998828\|gb\|MZ708958.1\|	1904821	g9507	i0	99.598	43.2349397590361	498	2	100	0	1	498	2555	3052	Pseudocapillaria tomentosa mitochondrion, complete genome	blastn	21531	909	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Capillariidae	Pseudocapillaria	Pseudocapillaria tomentosa
16170467	16170467	PRJNA893346_P_NODE_10653_length_482_cov_1.493888_g10169_i0	PRJNA893346	10653	482	1.493888	7.20054016	Pseudocapillaria tomentosa	1904821	Nematoda	Nematoda	872	0	NTclustered	gi\|2095998828\|gb\|MZ708958.1\|	1904821	g10169	i0	99.376	55.155601659751	481	3	99	0	1	481	6635	7115	Pseudocapillaria tomentosa mitochondrion, complete genome	blastn	26585	872	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Capillariidae	Pseudocapillaria	Pseudocapillaria tomentosa
21270270	21270270	PRJNA893346_P_NODE_34977_length_248_cov_1.925714_g34487_i0	PRJNA893346	34977	248	1.925714	4.77577072	Pseudocapillaria tomentosa	1904821	Nematoda	Nematoda	453	5.2600000000000005e-123	NTclustered	gi\|2095998828\|gb\|MZ708958.1\|	1904821	g34487	i0	99.597	87.0725806451613	248	1	100	0	1	248	6337	6584	Pseudocapillaria tomentosa mitochondrion, complete genome	blastn	21594	453	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Capillariidae	Pseudocapillaria	Pseudocapillaria tomentosa
21645431	21645431	PRJNA893346_P_NODE_24377_length_309_cov_0.978814_g23887_i0	PRJNA893346	24377	309	0.978814	3.02453526	root	1	Root_unresolved	Root_unresolved	54.7	0.008	NTclustered	gi\|6787\|emb\|X08066.1\|	6239	g23887	i0	100	0.478964401294498	29	0	9	0	163	191	4205	4233	Caenorhabditis elegans myo-2 gene for myosin heavy chain 2 (MHC-C)	blastn	148	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
23820532	23820532	PRJNA893346_P_NODE_32519_length_255_cov_1.549451_g32029_i0	PRJNA893346	32519	255	1.549451	3.95110005	Tylopharynx sp. WEM-2009	669147	Nematoda	Nematoda	135	2.24e-27	NTclustered	gi\|256709231\|gb\|GQ422268.1\|	669147	g32029	i0	80.769	2.92941176470588	182	28	69	5	38	214	189	10	Tylopharynx sp. WEM-2009 small subunit ribosomal protein 28 (rps-28) mRNA, partial cds	blastn	747	135	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Tylopharyngidae	Tylopharynx	Tylopharynx sp. WEM-2009
25093913	25093913	PRJNA893346_P_NODE_15120_length_400_cov_1.262997_g14632_i0	PRJNA893346	15120	400	1.262997	5.051988	Pristionchus bucculentus	1317126	Nematoda	Nematoda	300	1.24e-76	NTclustered	gi\|479330856\|gb\|KC463849.1\|	1317126	g14632	i0	83.03	69.3825	330	54	82	2	2	330	371	43	Pristionchus bucculentus strain RS5596 small subunit ribosomal protein 14 (rps14) gene, partial cds	blastn	27753	300	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus bucculentus
25094093	25094093	PRJNA893346_P_NODE_21700_length_330_cov_1.198444_g21211_i0	PRJNA893346	21700	330	1.198444	3.9548652	Strongyloides papillosus	174720	Nematoda	Nematoda	202	2.91e-47	NTclustered	gi\|690022274\|emb\|LM530102.1\|	174720	g21211	i0	86.813	72.2212121212121	182	22	55	2	1	181	36	216	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0004347	blastn	23833	202	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus

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