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

5 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_clade = "Amoebozoa"

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
2825664	2825664	PRJNA1120203_P_NODE_49203_length_322_cov_30.959839_g48187_i0	PRJNA1120203	49203	322	30.959839	99.69068158	Mycamoeba gemmipara	1895019	Discosea	other_Eukaryota	562	1.1299999999999997e-155	NTclustered	gi\|2174898629\|emb\|LR995408.1\|	1895019	g48187	i0	99.674	87.4968944099379	307	1	95	0	2	308	30	336	Mycamoeba gemmipara partial 18S rRNA gene, isolate LW OTU513_S110, clone M01452:264:000000000-D5YNG:1:1101:26607:17862	blastn	28174	562	1	Eukaryota	Amoebozoa	Discosea	Flabellinia			Mycamoeba	Mycamoeba gemmipara
13028917	13028917	PRJNA1120203_P_NODE_65271_length_278_cov_37.829268_g64255_i0	PRJNA1120203	65271	278	37.829268	105.16536504	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	424	4.71e-114	NTclustered	gi\|766968275\|gb\|KP233876.1\|	5778	g64255	i0	95.802	94.1906474820144	262	11	94	0	3	264	37	298	Vermamoeba vermiformis strain BA/SWH4/IR 18S ribosomal RNA gene, complete sequence	blastn	26185	424	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
15577722	15577722	PRJNA1120203_P_NODE_41913_length_351_cov_1.658273_g40898_i0	PRJNA1120203	41913	351	1.658273	5.82053823	Diderma niveum	372584	Evosea	other_Eukaryota	263	1.41e-65	NTclustered	gi\|381140154\|emb\|HE655061.1\|	372584	g40898	i0	81.073	57.022792022792	354	46	99	17	1	348	3360	3022	Diderma niveum partial 28S rRNA gene, isolate Uk-K79	blastn	20015	263	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Diderma	Diderma niveum
15578019	15578019	PRJNA1120203_P_NODE_65273_length_278_cov_14.619512_g64257_i0	PRJNA1120203	65273	278	14.619512	40.64224336	uncultured Lobosea	282480	Tubulinea	other_Eukaryota	466	7.71e-127	NTclustered	gi\|60687334\|gb\|AY821961.1\|	282480	g64257	i0	98.485	66.636690647482	264	4	95	0	14	277	735	472	Uncultured Lobosea clone CV1_B1_92 small subunit ribosomal RNA gene, partial sequence	blastn	18525	466	1	Eukaryota	Amoebozoa	Tubulinea					uncultured Lobosea
18126868	18126868	PRJNA1120203_P_NODE_65275_length_278_cov_6.404878_g64259_i0	PRJNA1120203	65275	278	6.404878	17.80556084	uncultured Lobosea	282480	Tubulinea	other_Eukaryota	387	6.179999999999998e-103	NTclustered	gi\|60687334\|gb\|AY821961.1\|	282480	g64259	i0	93.208	63.636690647482	265	15	95	2	13	276	735	473	Uncultured Lobosea clone CV1_B1_92 small subunit ribosomal RNA gene, partial sequence	blastn	17691	387	1	Eukaryota	Amoebozoa	Tubulinea					uncultured Lobosea

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