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

5 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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
290173	290173	PRJNA1146029_P_NODE_3061_length_488_cov_2.498795_g2784_i0	PRJNA1146029	3061	488	2.498795	12.1941196	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	331	5.46e-86	NTclustered	gi\|66805998\|ref\|XM_631629.1\|	352472	g2784	i0	81.146	8.53688524590164	419	73	85	4	61	476	1745	1330	Dictyostelium discoideum AX4 elongation factor 2 (efbA) mRNA, complete cds	blastn	4166	331	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
290228	290228	PRJNA1146029_P_NODE_6381_length_350_cov_1.111913_g6103_i0	PRJNA1146029	6381	350	1.111913	3.8916955	Phalansterium filosum	857046	Evosea	other_Eukaryota	285	2.99e-72	NTclustered	gi\|300078501\|gb\|GU001163.1\|	857046	g6103	i0	82.249	95.6828571428571	338	53	96	7	13	347	1923	2256	Phalansterium sp. EEG-2010/THA 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	33489	285	1	Eukaryota	Amoebozoa	Evosea	Variosea			Phalansterium	Phalansterium filosum
10493849	10493849	PRJNA1146029_P_NODE_2709_length_519_cov_2.331839_g2432_i0	PRJNA1146029	2709	519	2.331839	12.10224441	Phalansterium filosum	857046	Evosea	other_Eukaryota	257	1e-63	NTclustered	gi\|300078501\|gb\|GU001163.1\|	857046	g2432	i0	80.851	36.6435452793834	329	62	63	1	174	502	2890	2563	Phalansterium sp. EEG-2010/THA 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	19018	257	1	Eukaryota	Amoebozoa	Evosea	Variosea			Phalansterium	Phalansterium filosum
20691526	20691526	PRJNA1146029_P_NODE_13837_length_266_cov_1.253886_g13556_i0	PRJNA1146029	13837	266	1.253886	3.33533676	Perichaena dictyonema	2951132	Evosea	other_Eukaryota	448	2.6599999999999996e-121	NTclustered	gi\|2250222210\|gb\|ON713340.1\|	2951132	g13556	i0	97.004	93.9097744360902	267	6	100	2	1	266	813	1078	Perichaena dictyonema voucher MA59057 small subunit ribosomal RNA gene, partial sequence	blastn	24980	448	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Perichaena	Perichaena dictyonema
22710548	22710548	PRJNA1146029_P_NODE_338_length_1447_cov_4.878457_g224_i0	PRJNA1146029	338	1447	4.878457	70.59127279	Dictyostelium	5782	Evosea	other_Eukaryota	736	0	NTclustered	gi\|7276\|emb\|X55972.1\|	44689	g224	i0	77.419	57.3255010366275	1271	264	87	20	20	1274	16	1279	D. discoideum EF1-II gene for elongation factor 1 alpha	blastn	82950	736	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum

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