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

5 rows where analysis = "blastn", bioproject = "PRJNA752572" 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
728577	728577	PRJNA752572_P_NODE_195941_length_190_cov_1.851613_g195434_i0	PRJNA752572	195941	190	1.851613	3.5180647	Heterostelium album	2086695	Evosea	other_Eukaryota	80.5	7.49e-11	NTclustered	gi\|1160558536\|ref\|XM_020576101.1\|	670386	g195434	i0	86.076	1.57894736842105	79	5	40	4	20	95	372	297	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	300	80.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
5029670	5029670	PRJNA752572_P_NODE_284444_length_154_cov_2.184874_g283937_i0	PRJNA752572	284444	154	2.184874	3.36470596	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	2.72e-4	NTclustered	gi\|167387250\|ref\|XM_001738030.1\|	370354	g283937	i0	94.737	1.7012987012987	38	1	24	1	103	139	1878	1915	Entamoeba dispar SAW760 GCN20-type ATP-binding cassette protein GCN3, putative (EDI_172490), partial mRNA	blastn	262	58.4	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
17306739	17306739	PRJNA752572_P_NODE_52854_length_376_cov_2.190616_g52348_i0	PRJNA752572	52854	376	2.190616	8.23671616	Copromyxa protea	931554	Tubulinea	other_Eukaryota	545	1.35e-150	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g52348	i0	93.029	32.8404255319149	373	26	99	0	4	376	82	454	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	12348	545	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
21131126	21131126	PRJNA752572_P_NODE_101537_length_268_cov_1.751073_g101030_i0	PRJNA752572	101537	268	1.751073	4.69287564	Physarum polycephalum	5791	Evosea	other_Eukaryota	285	2.22e-72	NTclustered	gi\|161207\|gb\|M21500.1\|SLMACT35	5791	g101030	i0	86.312	94.4626865671642	263	34	98	2	1	262	902	1163	P.polycephalum actin (Ppa35) mRNA, complete cds	blastn	25316	285	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
25428030	25428030	PRJNA752572_P_NODE_8020_length_891_cov_2.943925_g7722_i0	PRJNA752572	8020	891	2.943925	26.23037175	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	152	8.62e-32	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g7722	i0	89.344	12.9708193041526	122	12	14	1	727	847	2295	2174	Vannella septentrionalis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	11557	152	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis

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