metadata: contig_metadata: 5 rows where bioproject = "PRJNA1005695" and tax

5 rows where bioproject = "PRJNA1005695" 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
1428232	1428232	PRJNA1005695_P_NODE_24362_length_304_cov_1.705628_g23510_i0	PRJNA1005695	24362	304	1.705628	5.18510912	Arcella hemisphaerica	497998	Tubulinea	other_Eukaryota	254	7.24e-63	NTclustered	gi\|304308758\|gb\|HM853710.1\|	497998	g23510	i0	82.237	57.3519736842105	304	44	98	10	4	302	351	53	Arcella hemisphaerica strain blue&red clone act23 actin gene, partial cds	blastn	17435	254	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella hemisphaerica
2703590	2703590	PRJNA1005695_P_NODE_11243_length_462_cov_66.709512_g10391_i0	PRJNA1005695	11243	462	66.709512	308.19794544	Amoeba proteus	5775	Tubulinea	other_Eukaryota	191	9.11e-44	NTclustered	gi\|173717\|gb\|M19222.1\|AMPRRM	5775	g10391	i0	81.78	35.95670995671	236	36	50	6	106	338	417	186	A.proteus 28S large subunit rRNA, 5' end	blastn	16612	191	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
5256379	5256379	PRJNA1005695_P_NODE_20325_length_334_cov_9.160920_g19473_i0	PRJNA1005695	20325	334	9.16092	30.5974728	Amoeba leningradensis	160820	Tubulinea	other_Eukaryota	294	4.74e-75	NTclustered	gi\|17897590\|emb\|AJ314605.1\|	160820	g19473	i0	88.259	3.01796407185629	247	28	74	1	86	331	812	1058	Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6	blastn	1008	294	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba leningradensis
9081049	9081049	PRJNA1005695_P_NODE_33148_length_259_cov_1.059140_g32296_i0	PRJNA1005695	33148	259	1.05914	2.7431726	Pyxidicula operculata	1078852	Tubulinea	other_Eukaryota	243	1.3e-59	NTclustered	gi\|345452598\|gb\|JF694317.1\|	1078852	g32296	i0	86.425	83.4864864864865	221	30	85	0	37	257	633	413	Pyxidicula operculata clone 2 actin gene, partial cds	blastn	21623	243	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida		Pyxidicula	Pyxidicula operculata
32311034	32311034	PRJNA1005695_P_NODE_33799_length_256_cov_1.497268_g32947_i0	PRJNA1005695	33799	256	1.497268	3.83300608	Copromyxa protea	931554	Tubulinea	other_Eukaryota	142	2.79e-38	NR	BAN33737.1	931554	g32947	i0	80	0.99609375	85	17	99.6	0	256	2	244	328	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	255	142	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);;