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

5 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
6503014	6503014	PRJEB58983_P_NODE_18746_length_298_cov_1.515556_g18331_i0	PRJEB58983	18746	298	1.515556	4.51635688	Soliformovum irregulare	435424	Evosea	other_Eukaryota	479	1.0699999999999999e-130	NTclustered	gi\|146448863\|gb\|EF513199.1\|	435424	g18331	i0	95.638	91.503355704698	298	13	100	0	1	298	1046	749	Soliformovum irregulare elongation factor 1A (EF1A) gene, partial cds	blastn	27268	479	1	Eukaryota	Amoebozoa	Evosea	Variosea	Fractovitellida	Soliformoviidae	Soliformovum	Soliformovum irregulare
12878668	12878668	PRJEB58983_P_NODE_30771_length_246_cov_0.872832_g30356_i0	PRJEB58983	30771	246	0.872832	2.14716672	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	148	2.75e-31	NTclustered	gi\|831766831\|ref\|XM_012896462.1\|	1410327	g30356	i0	89.076	4.52845528455285	119	13	48	0	123	241	1	119	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	1114	148	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
16701381	16701381	PRJEB58983_P_NODE_13294_length_347_cov_3.091241_g12879_i0	PRJEB58983	13294	347	3.091241	10.72660627	Acytostelium leptosomum	133408	Evosea	other_Eukaryota	263	1.39e-65	NTclustered	gi\|169930332\|gb\|EU360789.1\|	133408	g12879	i0	81.994	81.5706051873199	311	54	89	2	1	310	176	485	Acytostelium leptosomum elongation factor 1 alpha gene, partial cds	blastn	28305	263	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium leptosomum
21801594	21801594	PRJEB58983_P_NODE_22178_length_278_cov_2.282927_g21763_i0	PRJEB58983	22178	278	2.282927	6.34653706	Heterostelium pallidum	13642	Evosea	other_Eukaryota	291	4.98e-74	NTclustered	gi\|160688721\|gb\|EU275726.1\|	13642	g21763	i0	85.714	98.1151079136691	280	34	99	6	2	278	9499	9223	Polysphondylium pallidum strain PN500 mitochondrion, complete genome	blastn	27276	291	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium pallidum
23077177	23077177	PRJEB58983_P_NODE_4559_length_572_cov_66.875752_g4150_i0	PRJEB58983	4559	572	66.875752	382.52930144	uncultured Soliformovum	2510342	Evosea	other_Eukaryota	568	4.5299999999999986e-157	NTclustered	gi\|1564356923\|gb\|MK443523.1\|	2510342	g4150	i0	91.932	42.6223776223776	409	28	71	3	165	572	425	21	Uncultured Soliformovum clone OTUA345 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	24380	568	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae		uncultured Soliformovum

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