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

9 rows where analysis = "blastn", bioproject = "PRJNA983848" 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
2246030	2246030	PRJNA983848_P_NODE_81402_length_342_cov_11.646840_g75519_i0	PRJNA983848	81402	342	11.64684	39.8321928	Neoentomelas asatoi	2839652	Nematoda	Nematoda	111	5.26e-20	NTclustered	gi\|2179478460\|dbj\|LC631516.1\|	2839652	g75519	i0	88.298	23.0497076023392	94	10	27	1	16	108	592	685	Neoentomelas asatoi 243_Pa551_KUZR70496 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence	blastn	7883	111	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabdiasidae	Neoentomelas	Neoentomelas asatoi
7345715	7345715	PRJNA983848_P_NODE_152726_length_245_cov_1.813953_g146843_i0	PRJNA983848	152726	245	1.813953	4.44418485	Trichinella spiralis	6334	Nematoda	Nematoda	58.4	4.75e-4	NTclustered	gi\|102140999\|gb\|AC186779.1\|	6334	g146843	i0	100	0.244897959183673	31	0	13	0	107	137	83189	83219	Trichinella spiralis chromosome UNK clone TS195-45H12, complete sequence	blastn	60	58.4	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella spiralis
7649537	7649537	PRJNA983848_P_NODE_147006_length_248_cov_1.554286_g141123_i0	PRJNA983848	147006	248	1.554286	3.85462928	Caenorhabditis	6237	Nematoda	Nematoda	459	1.13e-124	NTclustered	gi\|2460759835\|gb\|OQ645709.1\|	6239	g141123	i0	100	100.713709677419	248	0	100	0	1	248	259	12	Caenorhabditis elegans strain H60A small subunit ribosomal RNA gene, partial sequence	blastn	24977	459	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
11170888	11170888	PRJNA983848_P_NODE_138009_length_253_cov_0.866667_g132126_i0	PRJNA983848	138009	253	0.866667	2.19266751	Meloidogyne oryzae	325757	Nematoda	Nematoda	54.7	0.006	NTclustered	gi\|1732099038\|emb\|LR131837.1\|	325757	g132126	i0	100	0.114624505928854	29	0	11	0	179	207	5799	5771	Meloidogyne oryzae genomic DNA containing ACC6 region (Type IV) region, isolate Mo-M2	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne oryzae
11173806	11173806	PRJNA983848_P_NODE_71209_length_373_cov_16.126667_g65326_i0	PRJNA983848	71209	373	16.126667	60.15246791	Caenorhabditis elegans	6239	Nematoda	Nematoda	689	0	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g65326	i0	100	100.364611260054	373	0	100	0	1	373	28518	28146	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	37436	689	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
13719853	13719853	PRJNA983848_P_NODE_103411_length_297_cov_1.392857_g97528_i0	PRJNA983848	103411	297	1.392857	4.13678529	Caenorhabditis elegans	6239	Nematoda	Nematoda	547	2.8899999999999992e-151	NTclustered	gi\|27543272\|gb\|AY171147.1\|	6239	g97528	i0	100	99.6734006734007	296	0	99	0	1	296	957	1252	Caenorhabditis elegans isolate TR403 NADH dehydrogenase subunit 6 (ND6) gene, partial cds; NADH dehydrogenase subunit 4L (ND4L) gene, complete cds; tRNA-Trp and tRNA-Glu genes, complete sequence; 12S ribosomal RNA gene, complete sequence; tRNA-Ser, tRNA-Asn, and tRNA-Tyr genes, complete sequence; and NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial genes for mitochondrial products	blastn	29603	547	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
16574012	16574012	PRJNA983848_P_NODE_113013_length_282_cov_14.267943_g107130_i0	PRJNA983848	113013	282	14.267943	40.23559926	Caenorhabditis	6237	Nematoda	Nematoda	516	7.67e-142	NTclustered	gi\|256561710\|gb\|FJ589010.1\|	6239	g107130	i0	99.645	72.1631205673759	282	1	100	0	1	282	284	3	Caenorhabditis elegans isolate X5005 large subunit ribosomal RNA gene, partial sequence	blastn	20350	516	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
22644188	22644188	PRJNA983848_P_NODE_127178_length_264_cov_19.968586_g121295_i0	PRJNA983848	127178	264	19.968586	52.71706704	Caenorhabditis elegans	6239	Nematoda	Nematoda	488	1.5499999999999999e-133	NTclustered	gi\|413006566\|emb\|Z92784.2\|	6239	g121295	i0	100	95.8106060606061	264	0	100	0	1	264	28867	28604	Caenorhabditis elegans Cosmid F31C3, complete sequence	blastn	25294	488	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
25192688	25192688	PRJNA983848_P_NODE_110160_length_286_cov_3.967136_g104277_i0	PRJNA983848	110160	286	3.967136	11.34600896	Caenorhabditis elegans	6239	Nematoda	Nematoda	529	1e-145	NTclustered	gi\|28396069\|gb\|AY204194.1\|	6239	g104277	i0	100	100.097902097902	286	0	100	0	1	286	608	893	Caenorhabditis elegans clone yk805b2 nuclear receptor (NHR-108) pseudogene mRNA, complete sequence	blastn	28628	529	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);;