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

5 rows where analysis = "blastn", bioproject = "PRJNA699078" 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
7060903	7060903	PRJNA699078_S_NODE_49746_length_242_cov_13.393782_g48797_i0	PRJNA699078	49746	242	13.393782	32.41295244	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	150	7.509999999999998e-32	NTclustered	gi\|470392114\|ref\|XM_004334697.1\|	1257118	g48797	i0	94.792	31.0330578512397	96	5	40	0	30	125	1204	1299	Acanthamoeba castellanii str. Neff GTPase domain containing protein (ACA1_092650), partial mRNA	blastn	7510	150	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
9610173	9610173	PRJNA699078_S_NODE_106748_length_163_cov_0.912281_g105799_i0	PRJNA699078	106748	163	0.912281	1.48701803	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	145	2.18e-30	NTclustered	gi\|831754863\|ref\|XM_012892787.1\|	1410327	g105799	i0	83.125	31.6687116564417	160	25	98	2	4	162	396	238	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	5162	145	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
10885822	10885822	PRJNA699078_S_NODE_108469_length_162_cov_0.902655_g107520_i0	PRJNA699078	108469	162	0.902655	1.4623011	Mastigella eilhardi	1580584	Evosea	other_Eukaryota	165	1.66e-36	NTclustered	gi\|730326679\|gb\|KJ879560.1\|	1580584	g107520	i0	85.185	88.6666666666667	162	22	99	2	2	162	638	478	Mastigella eilhardi strain GO7 actin gene, partial cds	blastn	14364	165	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida		Mastigella	Mastigella eilhardi
12161322	12161322	PRJNA699078_S_NODE_37430_length_283_cov_1.538462_g36481_i0	PRJNA699078	37430	283	1.538462	4.35384746	Heterostelium album	2086695	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|1160573700\|ref\|XM_020577028.1\|	670386	g36481	i0	94.595	0.452296819787986	37	1	13	1	155	190	547	583	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	128	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
22359635	22359635	PRJNA699078_S_NODE_57418_length_224_cov_1.782857_g56469_i0	PRJNA699078	57418	224	1.782857	3.99359968	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	58.4	4.28e-4	NTclustered	gi\|330796093\|ref\|XM_003286056.1\|	5786	g56469	i0	94.737	0.169642857142857	38	1	17	1	79	115	405	368	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_150062), partial mRNA	blastn	38	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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