metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
9106025	9106025	PRJNA1061474_P_NODE_34568_length_310_cov_1.544304_g34322_i0	PRJNA1061474	34568	310	1.544304	4.7873424	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	525	1.42e-144	NTclustered	gi\|300078496\|gb\|GU001158.1\|	5778	g34322	i0	99.652	56.4774193548387	287	1	93	0	23	309	3650	3364	Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	17508	525	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
9939791	9939791	PRJNA1061474_P_NODE_27668_length_357_cov_2.158451_g27422_i0	PRJNA1061474	27668	357	2.158451	7.70567007	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	566	9.759999999999997e-157	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g27422	i0	98.447	35.4985994397759	322	4	90	1	36	357	3880	3560	Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	12673	566	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
12490573	12490573	PRJNA1061474_P_NODE_38650_length_287_cov_1.242991_g38404_i0	PRJNA1061474	38650	287	1.242991	3.56738417	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.027	NTclustered	gi\|66802431\|ref\|XM_629996.1\|	352472	g38404	i0	100	0.195121951219512	28	0	10	0	215	242	791	764	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0291768) mRNA, complete cds	blastn	56	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
15480883	15480883	PRJNA1061474_P_NODE_22413_length_409_cov_1.431548_g22167_i0	PRJNA1061474	22413	409	1.431548	5.85503132	Entamoeba invadens	33085	Evosea	other_Eukaryota	62.1	6.53e-5	NTclustered	gi\|511091352\|dbj\|AK423018.1\|	33085	g22167	i0	78.723	8.29095354523227	94	18	23	2	202	294	857	765	Entamoeba invadens cDNA clone: Xei-008C04, hypothetical protein, complete cds, strain: IP1	blastn	3391	62.1	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens

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