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

6 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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
1488101	1488101	PRJNA1108487_P_NODE_3782_length_354_cov_1.882562_g3716_i0	PRJNA1108487	3782	354	1.882562	6.66426948	Didymium quitense	2059305	Evosea	other_Eukaryota	222	2.41e-53	NTclustered	gi\|2329703132\|gb\|MW239927.1\|	2059305	g3716	i0	79.141	80.9604519774011	326	64	92	4	16	339	214	537	Didymium quitense strain MA-Fungi 88326 alpha tubulin (aTUB) gene, partial cds	blastn	28660	222	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium quitense
4040240	4040240	PRJNA1108487_P_NODE_8504_length_252_cov_1.743017_g8438_i0	PRJNA1108487	8504	252	1.743017	4.39240284	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	89.8	1.74e-13	NTclustered	gi\|187764061\|ref\|NC_010653.1\|	261658	g8438	i0	98.039	0.428571428571429	51	1	20	0	122	172	21177	21227	Dictyostelium fasciculatum mitochondrion, complete genome	blastn	108	89.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
6591520	6591520	PRJNA1108487_P_NODE_3846_length_352_cov_0.992832_g3780_i0	PRJNA1108487	3846	352	0.992832	3.49476864	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	276	1.81e-69	NTclustered	gi\|66818754\|ref\|XM_637945.1\|	352472	g3780	i0	81.02	1.00284090909091	353	61	99	6	2	351	223	572	Dictyostelium discoideum AX4 tyrosine-tRNA ligase (tyrS) mRNA, complete cds	blastn	353	276	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
7866159	7866159	PRJNA1108487_P_NODE_1907_length_491_cov_2.468900_g1841_i0	PRJNA1108487	1907	491	2.4689	12.122299	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	154	1.28e-32	NTclustered	gi\|831753332\|ref\|XM_012892328.1\|	1410327	g1841	i0	80.184	0.883910386965377	217	33	43	7	262	473	782	571	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	434	154	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
7866167	7866167	PRJNA1108487_P_NODE_2427_length_435_cov_2.560773_g2361_i0	PRJNA1108487	2427	435	2.560773	11.13936255	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	165	5.17e-36	NTclustered	gi\|831770213\|ref\|XM_012897483.1\|	1410327	g2361	i0	74.163	16.1770114942529	418	98	95	10	21	432	181	594	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	7037	165	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
10416872	10416872	PRJNA1108487_P_NODE_5969_length_292_cov_1.424658_g5903_i0	PRJNA1108487	5969	292	1.424658	4.16000136	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	115	3.4e-21	NTclustered	gi\|831792201\|ref\|XM_012904512.1\|	1410327	g5903	i0	79.412	21.7945205479452	170	29	57	6	48	214	1166	1000	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	6364	115	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum

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