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

5 rows where analysis = "blastn", bioproject = "PRJNA737474" 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_class	tax_order	tax_family	tax_genus	tax_species
25982327	25982327	PRJNA737474d_S_NODE_43140_length_228_cov_4.232258_g42546_i0	PRJNA737474	43140	228	4.232258	9.64954824	Ripella decalvata	2047822	Discosea	other_Eukaryota	217	6.81e-52	NTclustered	gi\|1269228393\|gb\|MF683518.1\|	2047822	g42546	i0	85.782	92.6710526315789	211	23	92	5	19	228	360	564	Ripella decalvata clone 23.3.2 18S ribosomal RNA gene, partial sequence	blastn	21129	217	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella decalvata
25987828	25987828	PRJNA737474f_S_NODE_301620_length_235_cov_3.401235_g300942_i0	PRJNA737474	301620	235	3.401235	7.99290225	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	178	3.3299999999999993e-40	NTclustered	gi\|470514016\|ref\|XM_004352683.1\|	1257118	g300942	i0	86.792	11.5957446808511	159	21	68	0	22	180	181	339	Acanthamoeba castellanii str. Neff ribosomal protein S19, putative (ACA1_067910), partial mRNA	blastn	2725	178	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
26250325	26250325	PRJNA737474b_S_NODE_43126_length_249_cov_1.261364_g42087_i0	PRJNA737474	43126	249	1.261364	3.14079636	Ripella sp. PS2	1217116	Discosea	other_Eukaryota	163	9.980000000000001e-36	NTclustered	gi\|399764205\|gb\|JQ271716.1\|	1217116	g42087	i0	83.516	73.5180722891566	182	23	71	7	67	244	1371	1193	Ripella sp. PS2 18S ribosomal RNA gene, partial sequence	blastn	18306	163	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. PS2
26402707	26402707	PRJNA737474g_S_NODE_312303_length_251_cov_4.275281_g311009_i0	PRJNA737474	312303	251	4.275281	10.73095531	Cochliopodium spiniferum	313558	Discosea	other_Eukaryota	119	2.21e-22	NTclustered	gi\|330902897\|gb\|JF298273.1\|	313558	g311009	i0	86.792	16.9601593625498	106	14	42	0	124	229	863	758	Cochliopodium spiniferum clone 5102 actin gene, partial cds	blastn	4257	119	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium spiniferum
26442239	26442239	PRJNA737474b_S_NODE_26591_length_311_cov_2.100840_g25552_i0	PRJNA737474	26591	311	2.10084	6.5336124	Ripella	1217112	Discosea	other_Eukaryota	135	2.81e-27	NTclustered	gi\|1269228382\|gb\|MF683507.1\|	2047821	g25552	i0	86.4	22.9614147909968	125	15	40	2	6	130	1088	1210	Ripella platypodia clone 26.10.46 18S ribosomal RNA gene, partial sequence	blastn	7141	135	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella platypodia

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