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

5 rows where analysis = "blastn", bioproject = "PRJNA283169" 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
1646617	1646617	PRJNA283169_S_NODE_1062_length_258_cov_1.368421_g1048_i0	PRJNA283169	1062	258	1.368421	3.53052618	Ripella decalvata	2047822	Discosea	other_Eukaryota	409	1.21e-109	NTclustered	gi\|1269228436\|gb\|MF683561.1\|	2047822	g1048	i0	95.703	99.8100775193798	256	7	99	4	3	258	144	395	Ripella decalvata clone 26.2.18 18S ribosomal RNA gene, partial sequence	blastn	25751	409	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella decalvata
6749521	6749521	PRJNA283169_S_NODE_906_length_276_cov_0.118943_g892_i0	PRJNA283169	906	276	0.118943	0.32828268	Protostelium mycophagum	472931	Evosea	other_Eukaryota	453	5.9500000000000005e-123	NTclustered	gi\|262262901\|gb\|FJ766444.1\|	472931	g892	i0	99.597	36.9673913043478	248	1	100	0	1	248	335	88	Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence	blastn	10203	453	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae	Protostelium	Protostelium mycophagum
9299897	9299897	PRJNA283169_S_NODE_2168_length_193_cov_0.875000_g2154_i0	PRJNA283169	2168	193	0.875	1.68875	Ripella sp. 805	1217113	Discosea	other_Eukaryota	296	6.96e-76	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g2154	i0	94.359	104.813471502591	195	8	100	3	1	193	745	552	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	20229	296	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
14400823	14400823	PRJNA283169_S_NODE_572_length_334_cov_1.119298_g558_i0	PRJNA283169	572	334	1.119298	3.73845532	Cochliopodium minutoidum	703020	Discosea	other_Eukaryota	503	7.23e-138	NTclustered	gi\|1914009734\|gb\|MT975632.1\|	703020	g558	i0	93.976	98.434131736527	332	20	99	0	3	334	1	332	Cochliopodium minutoidum clone 2 actin gene, partial cds	blastn	32877	503	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minutoidum
22048272	22048272	PRJNA283169_P_NODE_5478_length_183_cov_1.089552_g5415_i0	PRJNA283169	5478	183	1.089552	1.99388016	Protostelium mycophagum	472931	Evosea	other_Eukaryota	339	1.07e-88	NTclustered	gi\|262262901\|gb\|FJ766444.1\|	472931	g5415	i0	100	9.58469945355191	183	0	100	0	1	183	791	609	Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence	blastn	1754	339	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae	Protostelium	Protostelium mycophagum

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