metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1011833" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1011833" 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
155456	155456	PRJNA1011833_S_NODE_37341_length_191_cov_0.972973_g36921_i0	PRJNA1011833	37341	191	0.972973	1.85837843	Pratylenchus vulnus	45931	Nematoda	Nematoda	54.7	0.005	NTclustered	gi\|1557394408\|emb\|LR031564.1\|	45931	g36921	i0	96.97	0.172774869109948	33	0	17	1	1	32	24	56	Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Pratylenchidae	Pratylenchus	Pratylenchus vulnus
6533719	6533719	PRJNA1011833_S_NODE_8186_length_398_cov_2.760563_g7769_i0	PRJNA1011833	8186	398	2.760563	10.98704074	Strongyloides papillosus	174720	Nematoda	Nematoda	52.8	0.038	NTclustered	gi\|690020125\|emb\|LM527640.1\|	174720	g7769	i0	100	0.14070351758794	28	0	7	0	24	51	288	315	Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0001973	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides papillosus
10358429	10358429	PRJNA1011833_S_NODE_17849_length_286_cov_14.086420_g17429_i0	PRJNA1011833	17849	286	14.08642	40.2871612	Pratylenchus vulnus	45931	Nematoda	Nematoda	52.8	0.026	NTclustered	gi\|1557394408\|emb\|LR031564.1\|	45931	g17429	i0	100	0.0979020979020979	28	0	10	0	1	28	23	50	Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Pratylenchidae	Pratylenchus	Pratylenchus vulnus
16732292	16732292	PRJNA1011833_S_NODE_27934_length_224_cov_1.325967_g27514_i0	PRJNA1011833	27934	224	1.325967	2.97016608	Brugia malayi	6279	Nematoda	Nematoda	159	1.14e-34	NTclustered	gi\|2082281358\|ref\|XM_001900763.2\|	6279	g27514	i0	79.556	6.20535714285714	225	44	100	2	1	224	559	782	Brugia malayi 26S proteasome subunit P45 family protein (Bma-rpt-3), partial mRNA	blastn	1390	159	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Onchocercidae	Brugia	Brugia malayi
23107857	23107857	PRJNA1011833_S_NODE_56159_length_153_cov_3.290909_g55739_i0	PRJNA1011833	56159	153	3.290909	5.03509077	Caenorhabditis remanei	31234	Nematoda	Nematoda	93.5	7.38e-15	NTclustered	gi\|2445368820\|ref\|XM_053728631.1\|	31234	g55739	i0	91.176	0.751633986928105	68	6	44	0	71	138	911	844	Caenorhabditis remanei uncharacterized protein (GCK72_011702), partial mRNA	blastn	115	93.5	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei

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