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

6 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax_clade = "Amoebozoa"

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
9437	9437	PRJDB4470_P_NODE_33541_length_389_cov_3.502941_g32392_i0	PRJDB4470	33541	389	3.502941	13.62644049	Coremiostelium polycephalum	142831	Evosea	other_Eukaryota	93.5	2.19e-14	NTclustered	gi\|85062629\|gb\|DQ340387.1\|	142831	g32392	i0	88.312	20.853470437018	77	9	20	0	31	107	12524	12448	Dictyostelium polycephalum 17S ribosomal RNA, 5.8S ribosomal RNA, and 26S ribosomal RNA genes, complete sequence	blastn	8112	93.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales		Coremiostelium	Coremiostelium polycephalum
1284196	1284196	PRJDB4470_P_NODE_91742_length_180_cov_1.938931_g90587_i0	PRJDB4470	91742	180	1.938931	3.4900758	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	52.8	0.015	NTclustered	gi\|831786596\|ref\|XM_012902707.1\|	1410327	g90587	i0	100	0.155555555555556	28	0	16	0	29	56	2881	2908	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
2559268	2559268	PRJDB4470_P_NODE_32763_length_395_cov_16.485549_g31615_i0	PRJDB4470	32763	395	16.485549	65.11791855	Paramoeba pemaquidensis	180228	Discosea	other_Eukaryota	97.1	1.72e-15	NTclustered	gi\|145386790\|gb\|EF216915.1\|	180228	g31615	i0	84.158	15.6	101	15	26	1	1	101	351	252	Paramoeba pemaquidensis strain PA027 28S large subunit ribosomal RNA gene, partial sequence	blastn	6162	97.1	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba pemaquidensis
3835307	3835307	PRJDB4470_P_NODE_119304_length_163_cov_0.894737_g118149_i0	PRJDB4470	119304	163	0.894737	1.45842131	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	231	1.63e-56	NTclustered	gi\|470522915\|ref\|XM_004354431.1\|	1257118	g118149	i0	92.593	0.993865030674847	162	11	99	1	1	162	933	773	Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_026850), partial mRNA	blastn	162	231	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
17861402	17861402	PRJDB4470_P_NODE_51475_length_283_cov_1.777778_g50321_i0	PRJDB4470	51475	283	1.777778	5.03111174	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	412	1.0399999999999998e-110	NTclustered	gi\|470509685\|ref\|XM_004351027.1\|	1257118	g50321	i0	92.933	1	283	20	100	0	1	283	625	343	Acanthamoeba castellanii str. Neff Syntaxin7A, putative (ACA1_080580), partial mRNA	blastn	283	412	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
22960960	22960960	PRJDB4470_P_NODE_102339_length_168_cov_0.873950_g101184_i0	PRJDB4470	102339	168	0.87395	1.468236	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	52.8	0.014	NTclustered	gi\|66825574\|ref\|XM_641050.1\|	352472	g101184	i0	100	0.166666666666667	28	0	17	0	61	88	384	411	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0269646) mRNA, complete cds	blastn	28	52.8	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);;