metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax

4 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax_phylum = "Tubulinea"

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
1295312	1295312	PRJEB14664_P_NODE_10602_length_232_cov_1.218274_g10472_i0	PRJEB14664	10602	232	1.218274	2.82639568	Spumochlamys perforata	675831	Tubulinea	other_Eukaryota	63.9	9.58e-6	NTclustered	gi\|259595675\|gb\|FJ705339.1\|	675831	g10472	i0	97.297	13.875	37	1	16	0	133	169	861	897	Spumochlamys perforata clone 2504 18S ribosomal RNA gene, partial sequence	blastn	3219	63.9	1	Eukaryota	Amoebozoa	Tubulinea	Corycida		Microchlamyiidae	Spumochlamys	Spumochlamys perforata
10223996	10223996	PRJEB14664_P_NODE_5069_length_377_cov_1.859649_g4939_i0	PRJEB14664	5069	377	1.859649	7.01087673	Copromyxa protea	931554	Tubulinea	other_Eukaryota	281	4.21e-71	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g4939	i0	83.498	0.803713527851459	303	48	80	2	68	369	1389	1088	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	303	281	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
12774862	12774862	PRJEB14664_P_NODE_711_length_1066_cov_2.824442_g648_i0	PRJEB14664	711	1066	2.824442	30.10855172	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1123	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g648	i0	86.351	15.6810506566604	1055	114	97	21	36	1066	1389	341	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	16716	1123	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
16597960	16597960	PRJEB14664_P_NODE_11274_length_223_cov_1.175532_g11144_i0	PRJEB14664	11274	223	1.175532	2.62143636	Arcella hemisphaerica	497998	Tubulinea	other_Eukaryota	219	1.8399999999999994e-52	NTclustered	gi\|304308781\|gb\|HM853722.1\|	497998	g11144	i0	84.375	79.2242152466368	224	33	100	2	1	223	748	526	Arcella hemisphaerica strain blue&red clone act35 actin gene, partial cds	blastn	17667	219	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella hemisphaerica

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