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

5 rows where analysis = "blastn", bioproject = "PRJNA541476" and tax_phylum = "Discosea"

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_phylum	tax_order	tax_family	tax_genus	tax_species
3060137	3060137	PRJNA541476_P_NODE_4723_length_524_cov_1.860310_g4524_i0	PRJNA541476	4723	524	1.86031	9.7480244	Balamuthia sp.	3395499	Discosea	other_Eukaryota	119	4.99e-22	NTclustered	gi\|2895086748\|gb\|PV023377.1\|	3395499	g4524	i0	75.269	11.631679389313	279	53	51	14	1	269	455	183	Balamuthia sp. isolate XJP24 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	6095	119	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Balamuthiidae	Balamuthia	Balamuthia sp.
5612248	5612248	PRJNA541476_P_NODE_14525_length_313_cov_1.300000_g14319_i0	PRJNA541476	14525	313	1.3	4.069	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	60.2	1.75e-4	NTclustered	gi\|470373777\|ref\|XM_004332999.1\|	1257118	g14319	i0	90.909	9.64856230031949	44	4	14	0	66	109	1255	1298	Acanthamoeba castellanii str. Neff adipose-regulatory protein (Seipin) protein (ACA1_048240), partial mRNA	blastn	3020	60.2	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
14537205	14537205	PRJNA541476_P_NODE_13132_length_325_cov_1.198413_g12926_i0	PRJNA541476	13132	325	1.198413	3.89484225	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	568	2.4499999999999992e-157	NTclustered	gi\|659103845\|gb\|KJ569729.1\|	1512276	g12926	i0	98.154	86.0276923076923	325	6	100	0	1	325	8	332	Cochliopodium kieliense isolate 2 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	27959	568	1	Eukaryota	Amoebozoa	Discosea	Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
19635420	19635420	PRJNA541476_P_NODE_9476_length_369_cov_3.111486_g9270_i0	PRJNA541476	9476	369	3.111486	11.48138334	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	556	6.1e-154	NTclustered	gi\|659103926\|gb\|KJ569726.1\|	1512276	g9270	i0	95.714	38.3739837398374	350	7	93	8	26	369	4	351	Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence	blastn	14160	556	1	Eukaryota	Amoebozoa	Discosea	Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
22185633	22185633	PRJNA541476_P_NODE_30218_length_250_cov_21.209040_g30012_i0	PRJNA541476	30218	250	21.20904	53.0226	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	331	2.6e-86	NTclustered	gi\|659103923\|gb\|KJ569725.1\|	1512276	g30012	i0	91.736	23.38	242	15	96	5	11	250	878	640	Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence	blastn	5845	331	1	Eukaryota	Amoebozoa	Discosea	Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense

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