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

5 rows where analysis = "blastn", bioproject = "PRJNA1129273" and tax_phylum = "Evosea"

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
2307003	2307003	PRJNA1129273_P_NODE_11322_length_211_cov_4.536232_g11042_i0	PRJNA1129273	11322	211	4.536232	9.57144952	Flamella	490353	Evosea	other_Eukaryota	387	4.47e-103	NTclustered	gi\|163943978\|gb\|EU186022.1\|	490515	g11042	i0	100	101.056872037915	209	0	99	0	2	210	1499	1707	Flamella arnhemensis 18S ribosomal RNA gene, partial sequence	blastn	21323	387	1	Eukaryota	Amoebozoa	Evosea	Variosea		Flamellidae	Flamella	Flamella arnhemensis
6134488	6134488	PRJNA1129273_P_NODE_10885_length_235_cov_2.734568_g10605_i0	PRJNA1129273	10885	235	2.734568	6.4262348	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	291	4.1e-74	NTclustered	gi\|330841829\|ref\|XM_003292845.1\|	5786	g10605	i0	89.224	96.1702127659574	232	25	99	0	3	234	709	940	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_73394), mRNA	blastn	22600	291	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
7936260	7936260	PRJNA1129273_P_NODE_11087_length_228_cov_9.290323_g10807_i0	PRJNA1129273	11087	228	9.290323	21.18193644	Flamella arnhemensis	490515	Evosea	other_Eukaryota	420	4.84e-113	NTclustered	gi\|163943978\|gb\|EU186022.1\|	490515	g10807	i0	100	105.956140350877	227	0	99	0	2	228	124	350	Flamella arnhemensis 18S ribosomal RNA gene, partial sequence	blastn	24158	420	1	Eukaryota	Amoebozoa	Evosea	Variosea		Flamellidae	Flamella	Flamella arnhemensis
16334091	16334091	PRJNA1129273_P_NODE_7233_length_269_cov_1.178571_g6953_i0	PRJNA1129273	7233	269	1.178571	3.17035599	Dictyostelium	5782	Evosea	other_Eukaryota	178	3.9e-40	NTclustered	gi\|2367630\|gb\|AF016242.1\|AF016242	44689	g6953	i0	80.242	77.6245353159851	248	39	89	5	29	268	606	361	Dictyostelium discoideum protein synthesis elongation factor 1-alpha (tef2) gene, partial cds	blastn	20881	178	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
18135036	18135036	PRJNA1129273_P_NODE_7215_length_269_cov_1.561224_g6935_i0	PRJNA1129273	7215	269	1.561224	4.19969256	Polyschismium peyerimhoffii	2911783	Evosea	other_Eukaryota	211	3.84e-50	NTclustered	gi\|2161226355\|gb\|MZ313553.1\|	2911783	g6935	i0	83.621	1.24163568773234	232	31	85	6	41	269	3450	3677	Polyschismium peyerimhoffii 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	334	211	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Polyschismium	Polyschismium peyerimhoffii

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