metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA274362" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA274362" 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
4197561	4197561	PRJNA274362_S_NODE_18604_length_212_cov_1.533742_g18484_i0	PRJNA274362	18604	212	1.533742	3.25153304	Levipalatum texanum	1486449	Nematoda	Nematoda	187	4.9e-43	NTclustered	gi\|610559467\|gb\|KJ395558.1\|	1486449	g18484	i0	82.87	4.83018867924528	216	29	100	6	1	212	384	173	Levipalatum texanum ribosomal protein (rpl-23) gene, partial cds	blastn	1024	187	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Levipalatum	Levipalatum texanum
6748284	6748284	PRJNA274362_S_NODE_24946_length_188_cov_2.215827_g24826_i0	PRJNA274362	24946	188	2.215827	4.16575476	Micoletzkya masseyi	1250333	Nematoda	Nematoda	126	9.36e-25	NTclustered	gi\|953064426\|gb\|KT188926.1\|	1250333	g24826	i0	79.33	75.0797872340426	179	37	95	0	9	187	266	88	Micoletzkya masseyi small subunit ribosomal protein 14 (rps-14) mRNA, partial cds	blastn	14115	126	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Diplogasteridae	Micoletzkya	Micoletzkya masseyi
6748497	6748497	PRJNA274362_S_NODE_34986_length_165_cov_0.896552_g34866_i0	PRJNA274362	34986	165	0.896552	1.4793108	Caenorhabditis remanei	31234	Nematoda	Nematoda	111	2.24e-20	NTclustered	gi\|2445365262\|ref\|XM_003113149.2\|	31234	g34866	i0	81.481	5.14545454545455	135	25	82	0	18	152	410	276	Caenorhabditis remanei uncharacterized protein (GCK72_009834), partial mRNA	blastn	849	111	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei
10574852	10574852	PRJNA274362_S_NODE_37969_length_159_cov_2.727273_g37849_i0	PRJNA274362	37969	159	2.727273	4.33636407	Caenorhabditis briggsae	6238	Nematoda	Nematoda	110	7.7e-20	NTclustered	gi\|268531565\|ref\|XM_002630863.1\|	6238	g37849	i0	82.171	3.73584905660377	129	21	81	2	30	157	275	148	Caenorhabditis briggsae Protein CBR-LGG-1 (Cbr-lgg-1), partial mRNA	blastn	594	110	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis briggsae
18222126	18222126	PRJNA274362_S_NODE_18015_length_215_cov_1.240964_g17895_i0	PRJNA274362	18015	215	1.240964	2.6680726	Pristionchus sp. 10 RS5133	452805	Nematoda	Nematoda	62.1	3.15e-5	NTclustered	gi\|150984447\|gb\|EF634866.1\|	452805	g17895	i0	85.965	0.265116279069767	57	8	27	0	3	59	541	597	Pristionchus sp. 10 RS5133 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds	blastn	57	62.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus sp. 10 RS5133
18222256	18222256	PRJNA274362_S_NODE_24055_length_191_cov_1.443662_g23935_i0	PRJNA274362	24055	191	1.443662	2.75739442	Pristionchus bucculentus	1317126	Nematoda	Nematoda	106	1.24e-18	NTclustered	gi\|479330840\|gb\|KC463841.1\|	1317126	g23935	i0	82.114	2.59162303664921	123	22	64	0	2	124	150	28	Pristionchus bucculentus strain RS5596 large subunit ribosomal protein 27a (rpl27a) gene, partial cds	blastn	495	106	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Neodiplogasteridae	Pristionchus	Pristionchus bucculentus
22046822	22046822	PRJNA274362_S_NODE_10958_length_265_cov_1.166667_g10838_i0	PRJNA274362	10958	265	1.166667	3.09166755	Caenorhabditis elegans	6239	Nematoda	Nematoda	228	3.7499999999999994e-55	NTclustered	gi\|687865697\|emb\|LK927572.1\|	6239	g10838	i0	82.197	195.803773584906	264	47	99	0	2	265	119817	120080	Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000039	blastn	51888	228	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans

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