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

5 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
9215681	9215681	PRJNA1144090_P_NODE_70768_length_300_cov_4.022026_g70233_i0	PRJNA1144090	70768	300	4.022026	12.066078	Glaeseria mira	242547	Tubulinea	other_Eukaryota	324	5.36e-84	NTclustered	gi\|33946352\|gb\|AY294155.1\|	242547	g70233	i0	86.242	98.5333333333333	298	41	99	0	3	300	899	602	Glaeseria mira actin mRNA, partial cds	blastn	29560	324	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Glaeseria	Glaeseria mira
9215722	9215722	PRJNA1144090_P_NODE_76188_length_289_cov_1.925926_g75653_i0	PRJNA1144090	76188	289	1.925926	5.56592614	Arcella hemisphaerica	497998	Tubulinea	other_Eukaryota	303	6.6899999999999995e-78	NTclustered	gi\|304308793\|gb\|HM853729.1\|	497998	g75653	i0	85.764	101.193771626298	288	39	99	2	3	289	534	248	Arcella hemisphaerica strain red clone act42 actin gene, partial cds	blastn	29245	303	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella hemisphaerica
16864225	16864225	PRJNA1144090_P_NODE_23954_length_547_cov_20.360759_g23424_i0	PRJNA1144090	23954	547	20.360759	111.37335173	Ptolemeba noxubium	1525730	Tubulinea	other_Eukaryota	1005	0	NTclustered	gi\|667752760\|gb\|KJ542109.1\|	1525730	g23424	i0	99.817	78.0749542961609	547	1	100	0	1	547	1079	533	Ptolemeba noxubium isolate Nx13-1a 18S ribosomal RNA gene, partial sequence	blastn	42707	1005	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Ptolemeba	Ptolemeba noxubium
21963853	21963853	PRJNA1144090_P_NODE_22578_length_567_cov_3.038462_g22051_i0	PRJNA1144090	22578	567	3.038462	17.22807954	Copromyxa protea	931554	Tubulinea	other_Eukaryota	730	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g22051	i0	90.357	4.75661375661376	560	48	98	5	1	557	1345	789	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	2697	730	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
24512908	24512908	PRJNA1144090_P_NODE_13180_length_771_cov_2.133238_g12717_i0	PRJNA1144090	13180	771	2.133238	16.44726498	Copromyxa protea	931554	Tubulinea	other_Eukaryota	804	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g12717	i0	88.537	27.5940337224384	663	76	86	0	108	770	672	10	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	21275	804	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea

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