metadata: contig_metadata: 7 rows where bioproject = "PRJNA1148190" and tax

7 rows where bioproject = "PRJNA1148190" 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
2844493	2844493	PRJNA1148190_P_NODE_292263_length_323_cov_1.240000_g281090_i0	PRJNA1148190	292263	323	1.24	4.0052	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	409	1.56e-109	NTclustered	gi\|62910949\|gb\|AY925001.1\|	5778	g281090	i0	95.669	0.91640866873065	254	11	79	0	1	254	254	1	Hartmannella vermiformis Rpl7A mRNA, partial cds	blastn	296	409	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
6677965	6677965	PRJNA1148190_P_NODE_778146_length_241_cov_0.916667_g766973_i0	PRJNA1148190	778146	241	0.916667	2.20916747	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	368	1.9e-97	NTclustered	gi\|421976335\|gb\|JQ519484.1\|	5778	g766973	i0	94.191	58.4439834024896	241	14	100	0	1	241	468	228	Vermamoeba vermiformis clone JGHverm1 beta-tubulin gene, partial cds	blastn	14085	368	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
10504098	10504098	PRJNA1148190_P_NODE_795049_length_237_cov_2.542683_g783876_i0	PRJNA1148190	795049	237	2.542683	6.02615871	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	399	6.589999999999999e-107	NTclustered	gi\|423292048\|gb\|JQ519470.1\|	5778	g783876	i0	97.046	91.2784810126582	237	7	100	0	1	237	651	415	Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds	blastn	21633	399	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
20162373	20162373	PRJNA1148190_P_NODE_67436_length_684_cov_1.355155_g56372_i0	PRJNA1148190	67436	684	1.355155	9.2692602	root	1	Root_unresolved	Root_unresolved	246	8.96e-74	NR	AKT93973.1	5778	g56372	i0	56.5	2.81578947368421	216	87	93.9	3	8	649	47	257	AKT93973.1 NADH dehydrogenase subunit 11 [Vermamoeba vermiformis]	diamond	1926	246	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
23250938	23250938	PRJNA1148190_P_NODE_663699_length_247_cov_0.885057_g652526_i0	PRJNA1148190	663699	247	0.885057	2.18609079	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	412	8.89e-111	NTclustered	gi\|62910949\|gb\|AY925001.1\|	5778	g652526	i0	96.761	2.27935222672065	247	8	100	0	1	247	498	744	Hartmannella vermiformis Rpl7A mRNA, partial cds	blastn	563	412	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
29218863	29218863	PRJNA1148190_P_NODE_498869_length_267_cov_1.190722_g487696_i0	PRJNA1148190	498869	267	1.190722	3.17922774	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	111	6.61e-27	NR	AKT93936.1	5778	g487696	i0	62.5	2.97752808988764	88	33	98.9	0	3	266	161	248	AKT93936.1 translation elongation factor Tu [Vermamoeba vermiformis]	diamond	795	111	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
30513744	30513744	PRJNA1148190_P_NODE_583013_length_251_cov_1.207865_g571840_i0	PRJNA1148190	583013	251	1.207865	3.03174115	Amoeba proteus	5775	Tubulinea	other_Eukaryota	77	3.44e-14	NR	AKN09695.1	5775	g571840	i0	48.8	0.9800796812749	82	27	96.8	2	2	244	152	219	AKN09695.1 Mmm1, partial [Amoeba proteus]	diamond	246	77	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus

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