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

5 rows where analysis = "blastn", bioproject = "PRJNA235310" 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
4194461	4194461	PRJNA235310_P_NODE_3784_length_194_cov_1.351724_g3758_i0	PRJNA235310	3784	194	1.351724	2.62234456	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	130	7.52e-26	NTclustered	gi\|831786008\|ref\|XM_012902515.1\|	1410327	g3758	i0	83.824	0.701030927835051	136	22	70	0	1	136	678	543	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	136	130	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
4194493	4194493	PRJNA235310_P_NODE_6104_length_163_cov_0.912281_g6078_i0	PRJNA235310	6104	163	0.912281	1.48701803	Arcyria denudata	283669	Evosea	other_Eukaryota	143	7.839999999999999e-30	NTclustered	gi\|2772191475\|gb\|PQ014915.1\|	283669	g6078	i0	83.125	98.079754601227	160	23	97	3	6	163	489	332	Arcyria denudata voucher TUF132227 translation elongation factor 1-alpha (EF1a) gene, partial cds	blastn	15987	143	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria denudata
8020757	8020757	PRJNA235310_P_NODE_287_length_647_cov_1.812709_g265_i0	PRJNA235310	287	647	1.812709	11.72822723	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	281	7.54e-71	NTclustered	gi\|831792076\|ref\|XM_012904471.1\|	1410327	g265	i0	79.147	27.8562596599691	422	76	64	10	232	647	1643	1228	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	18023	281	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
16944638	16944638	PRJNA235310_P_NODE_2734_length_231_cov_1.142857_g2708_i0	PRJNA235310	2734	231	1.142857	2.63999967	Mastigamoeba balamuthi	108607	Evosea	other_Eukaryota	152	1.98e-32	NTclustered	gi\|27357016\|gb\|AY149910.1\|	108607	g2708	i0	88.889	0.545454545454545	126	10	54	4	94	217	1778	1655	Mastigamoeba balamuthi malic enzyme gene, complete cds	blastn	126	152	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba balamuthi
18219085	18219085	PRJNA235310_P_NODE_6255_length_162_cov_1.380531_g6229_i0	PRJNA235310	6255	162	1.380531	2.23646022	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	176	7.67e-40	NTclustered	gi\|831757457\|ref\|XM_012893582.1\|	1410327	g6229	i0	86.709	18.9259259259259	158	21	98	0	4	161	848	691	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	3066	176	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);;