metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA454503" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA454503" 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
3644957	3644957	PRJNA454503_P_NODE_76703_length_204_cov_1.818182_g76374_i0	PRJNA454503	76703	204	1.818182	3.70909128	Physariida	5789	Evosea	other_Eukaryota	237	4.5800000000000006e-58	NTclustered	gi\|3221\|emb\|V01159.1\|	5791	g76374	i0	90.608	9.49019607843137	181	14	88	2	4	182	2072	2251	Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA	blastn	1936	237	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
5545897	5545897	PRJNA454503_P_NODE_25605_length_248_cov_1.368984_g25276_i0	PRJNA454503	25605	248	1.368984	3.39508032	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	52.8	0.022	NTclustered	gi\|330795794\|ref\|XM_003285908.1\|	5786	g25276	i0	100	0.112903225806452	28	0	11	0	69	96	2574	2601	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_149887), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
6820034	6820034	PRJNA454503_P_NODE_35986_length_232_cov_1.040936_g35657_i0	PRJNA454503	35986	232	1.040936	2.41497152	Fuligo septica	159720	Evosea	other_Eukaryota	429	8.2e-116	NTclustered	gi\|381139265\|emb\|HE655082.1\|	159720	g35657	i0	100	33.7068965517241	232	0	100	0	1	232	1741	1972	Fuligo septica partial 28S rRNA gene, isolate IW-1	blastn	7820	429	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Fuligo	Fuligo septica
10646306	10646306	PRJNA454503_P_NODE_41769_length_225_cov_1.189024_g41440_i0	PRJNA454503	41769	225	1.189024	2.675304	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	65.8	2.57e-6	NTclustered	gi\|330798866\|ref\|XM_003287423.1\|	5786	g41440	i0	83.824	0.302222222222222	68	11	30	0	50	117	2327	2394	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_78323), partial mRNA	blastn	68	65.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
13847450	13847450	PRJNA454503_P_NODE_66451_length_208_cov_0.863946_g66122_i0	PRJNA454503	66451	208	0.863946	1.79700768	root	1	Root_unresolved	Root_unresolved	62.1	3.03e-5	NTclustered	gi\|66800206\|ref\|XM_629027.1\|	352472	g66122	i0	97.222	2.64903846153846	36	1	17	0	11	46	3409	3444	Dictyostelium discoideum AX4 NF-X1-type zinc finger-containing protein (DDB_G0293590) mRNA, complete cds	blastn	551	62.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
24669053	24669053	PRJNA454503_P_NODE_81120_length_203_cov_0.915493_g80791_i0	PRJNA454503	81120	203	0.915493	1.85845079	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	73.1	1.36e-8	NTclustered	gi\|66828188\|ref\|XM_642357.1\|	352472	g80791	i0	95.556	0.694581280788177	45	2	22	0	22	66	396	352	Dictyostelium discoideum AX4 hypothetical protein (tsuA) mRNA, complete cds	blastn	141	73.1	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);;