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

6 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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
278566	278566	PRJNA1123309_P_NODE_54441_length_249_cov_0.886364_g54061_i0	PRJNA1123309	54441	249	0.886364	2.20704636	Caenorhabditis elegans	6239	Nematoda	Nematoda	448	2.46e-121	NTclustered	gi\|351058790\|emb\|FO080768.1\|	6239	g54061	i0	99.592	2.92771084337349	245	1	98	0	4	248	38619	38375	Caenorhabditis elegans Cosmid C33H5, complete sequence	blastn	729	448	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
278690	278690	PRJNA1123309_P_NODE_66601_length_242_cov_0.923077_g66221_i0	PRJNA1123309	66601	242	0.923077	2.23384634	Caenorhabditis elegans	6239	Nematoda	Nematoda	396	8.739999999999996e-106	NTclustered	gi\|1972262903\|ref\|NM_065577.9\|	6239	g66221	i0	99.539	4.50413223140496	217	1	90	0	1	217	217	1	Caenorhabditis elegans Small ribosomal subunit protein uS2 (rpsa-1), mRNA	blastn	1090	396	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
14307527	14307527	PRJNA1123309_P_NODE_65752_length_242_cov_0.923077_g65372_i0	PRJNA1123309	65752	242	0.923077	2.23384634	Caenorhabditis elegans	6239	Nematoda	Nematoda	429	8.619999999999998e-116	NTclustered	gi\|1972266897\|ref\|NM_001028103.4\|	6239	g65372	i0	100	5.79338842975207	232	0	96	0	1	232	4872	4641	Caenorhabditis elegans Vitellogenin-6 (vit-6), mRNA	blastn	1402	429	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
20679871	20679871	PRJNA1123309_P_NODE_46217_length_254_cov_2.580110_g45837_i0	PRJNA1123309	46217	254	2.58011	6.5534794	Strongyloides papillosus	174720	Nematoda	Nematoda	75	4.92e-9	NTclustered	gi\|687022641\|emb\|LM525555.1\|	174720	g45837	i0	89.655	1.31102362204724	58	6	23	0	173	230	601610	601553	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000001	blastn	333	75	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
20680031	20680031	PRJNA1123309_P_NODE_62657_length_244_cov_0.912281_g62277_i0	PRJNA1123309	62657	244	0.912281	2.22596564	Caenorhabditis elegans	6239	Nematoda	Nematoda	405	1.47e-108	NTclustered	gi\|1734330052\|ref\|NM_068920.4\|	6239	g62277	i0	99.55	3.22950819672131	222	1	91	0	1	222	253	32	Caenorhabditis elegans UPF0642 protein YBL028C (C49H3.3), mRNA	blastn	788	405	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
25255436	25255436	PRJNA1123309_P_NODE_8240_length_522_cov_17.436526_g7871_i0	PRJNA1123309	8240	522	17.436526	91.01866572	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	375	2.6699999999999997e-99	NTclustered	gi\|268559799\|ref\|XM_002646027.1\|	6238	g7871	i0	85.135	72.1034482758621	370	51	70	4	6	373	940	1307	Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA	blastn	37638	375	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);;