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

5 rows where analysis = "blastn", bioproject = "PRJNA682370" 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
3215156	3215156	PRJNA682370_S_NODE_24103_length_151_cov_1.198276_g23491_i0	PRJNA682370	24103	151	1.198276	1.80939676	Nolandella sp. ATCC PRA-27	498006	Tubulinea	other_Eukaryota	99	1.56e-16	NTclustered	gi\|167859744\|gb\|EU273453.1\|	498006	g23491	i0	84.158	4.8476821192053	101	16	67	0	1	101	663	563	Nolandella sp. ATCC PRA-27 clone 2 actin gene, partial cds	blastn	732	99	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Nolandella	Nolandella sp. ATCC PRA-27
4492555	4492555	PRJNA682370_S_NODE_9684_length_236_cov_2.258706_g9072_i0	PRJNA682370	9684	236	2.258706	5.33054616	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	226	1.18e-54	NTclustered	gi\|470420395\|ref\|XM_004337241.1\|	1257118	g9072	i0	84.188	38.6228813559322	234	35	99	2	1	233	2390	2158	Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA	blastn	9115	226	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
10868290	10868290	PRJNA682370_S_NODE_19269_length_164_cov_1.976744_g18657_i0	PRJNA682370	19269	164	1.976744	3.24186016	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.004	NTclustered	gi\|111226590\|ref\|XM_636082.2\|	352472	g18657	i0	96.875	0.365853658536585	32	1	20	0	76	107	386	417	Dictyostelium discoideum AX4 Ras GTPase (DDB_G0280437) mRNA, complete cds	blastn	60	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
17242272	17242272	PRJNA682370_S_NODE_22234_length_155_cov_1.725000_g21622_i0	PRJNA682370	22234	155	1.725	2.67375	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	135	1.23e-27	NTclustered	gi\|831754058\|ref\|XM_012892546.1\|	1410327	g21622	i0	82.895	3.4258064516129	152	24	97	2	1	151	640	490	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	531	135	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
21066565	21066565	PRJNA682370_S_NODE_10597_length_224_cov_1.825397_g9985_i0	PRJNA682370	10597	224	1.825397	4.08888928	Heterostelium album	2086695	Evosea	other_Eukaryota	244	3.0599999999999997e-60	NTclustered	gi\|1160551744\|ref\|XM_020571206.1\|	670386	g9985	i0	86.667	92.5446428571429	225	24	99	6	3	224	1805	2026	Polysphondylium pallidum PN500 heat shock protein (hspB), partial mRNA	blastn	20730	244	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album

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