metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA195897" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA195897" 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
2330591	2330591	PRJNA195897_P_NODE_7242_length_185_cov_1.529412_g7209_i0	PRJNA195897	7242	185	1.529412	2.8294122	Entamoeba	5758	Evosea	other_Eukaryota	143	9.11e-30	NTclustered	gi\|511087040\|dbj\|AK420788.1\|	5759	g7209	i0	86.719	38.9405405405405	128	17	69	0	58	185	431	304	Entamoeba histolytica cDNA clone: Xeh-010F17, histone H3, putative, complete cds, strain: HM-1:IMSS	blastn	7204	143	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
4193076	4193076	PRJNA195897_P_NODE_4304_length_230_cov_1.580110_g4271_i0	PRJNA195897	4304	230	1.58011	3.634253	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	65.8	2.64e-6	NTclustered	gi\|831784599\|ref\|XM_012902064.1\|	1410327	g4271	i0	97.368	1.23478260869565	38	1	17	0	51	88	1245	1208	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	284	65.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
14395105	14395105	PRJNA195897_P_NODE_9492_length_168_cov_0.873950_g9459_i0	PRJNA195897	9492	168	0.87395	1.468236	Rostrostelium ellipticum	361140	Evosea	other_Eukaryota	100	4.97e-17	NTclustered	gi\|1057487844\|gb\|KX539482.1\|	361140	g9459	i0	84.112	3.50595238095238	107	13	63	3	59	163	3139	3035	Rostrostelium ellipticum strain AE2 glutamate dehydrogenase 2 (glud2) gene, complete cds	blastn	589	100	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Rostrostelium	Rostrostelium ellipticum
16943302	16943302	PRJNA195897_P_NODE_734_length_636_cov_1.427598_g704_i0	PRJNA195897	734	636	1.427598	9.07952328	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	204	1.6499999999999998e-47	NTclustered	gi\|831786008\|ref\|XM_012902515.1\|	1410327	g704	i0	79	1.33647798742138	300	61	47	2	1	299	710	412	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	850	204	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
19492005	19492005	PRJNA195897_P_NODE_6036_length_199_cov_1.933333_g6003_i0	PRJNA195897	6036	199	1.933333	3.84733267	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	143	9.96e-30	NTclustered	gi\|831769224\|ref\|XM_012897186.1\|	1410327	g6003	i0	82.609	17.7437185929648	161	28	81	0	39	199	687	527	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	3531	143	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
23318060	23318060	PRJNA195897_P_NODE_12439_length_162_cov_0.920354_g12406_i0	PRJNA195897	12439	162	0.920354	1.49097348	Mastigamoeba balamuthi	108607	Evosea	other_Eukaryota	84.2	4.78e-12	NTclustered	gi\|148536468\|gb\|EF410004.1\|	108607	g12406	i0	77.027	1.12962962962963	148	32	91	2	6	152	1638	1492	Mastigamoeba balamuthi chaperonin 60 (Cpn60) mRNA, complete cds	blastn	183	84.2	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba balamuthi
23318074	23318074	PRJNA195897_P_NODE_2359_length_328_cov_1.537634_g2326_i0	PRJNA195897	2359	328	1.537634	5.04343952	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	217	1.03e-51	NTclustered	gi\|831758194\|ref\|XM_012893815.1\|	1410327	g2326	i0	82.329	3.24085365853659	249	44	76	0	80	328	1077	829	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	1063	217	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);;