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

5 rows where analysis = "blastn", bioproject = "PRJNA438572" 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
2985734	2985734	PRJNA438572_P_NODE_23303_length_243_cov_1.405882_g23184_i0	PRJNA438572	23303	243	1.405882	3.41629326	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	110	1.28e-19	NTclustered	gi\|470249444\|ref\|XM_004366897.1\|	261658	g23184	i0	85.185	1.12757201646091	108	14	44	2	63	169	140	34	Cavenderia fasciculata SNF2-related domain-containing protein (DFA_07082), partial mRNA	blastn	274	110	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
4262116	4262116	PRJNA438572_P_NODE_24604_length_242_cov_0.917160_g24485_i0	PRJNA438572	24604	242	0.91716	2.2195272	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	189	1.5899999999999996e-43	NTclustered	gi\|470267654\|ref\|XM_004362067.1\|	261658	g24485	i0	81.545	24.1074380165289	233	39	95	4	12	242	447	217	Cavenderia fasciculata P-type ATPase (DFA_06423), partial mRNA	blastn	5834	189	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
5538910	5538910	PRJNA438572_P_NODE_8165_length_356_cov_1.102473_g8046_i0	PRJNA438572	8165	356	1.102473	3.92480388	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	169	3.2099999999999997e-37	NTclustered	gi\|330791695\|ref\|XM_003283880.1\|	5786	g8046	i0	78.049	0.955056179775281	287	50	79	12	61	342	329	607	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_45137), mRNA	blastn	340	169	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
15737801	15737801	PRJNA438572_P_NODE_493_length_1212_cov_6.670764_g447_i0	PRJNA438572	493	1212	6.670764	80.84965968	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	828	0	NTclustered	gi\|831784126\|ref\|XM_012901914.1\|	1410327	g447	i0	80.341	76.8333333333333	1114	202	91	12	7	1107	181	1290	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	93122	828	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
18942397	18942397	PRJNA438572_P_NODE_11235_length_307_cov_1.000000_g11116_i0	PRJNA438572	11235	307	1	3.07	Entamoeba	5758	Evosea	other_Eukaryota	60.2	1.71e-4	NTclustered	gi\|13537430\|dbj\|AB054579.1\|	5759	g11116	i0	94.737	3.71986970684039	38	2	12	0	44	81	178	215	Entamoeba histolytica EhRabC1 mRNA for small GTPase RabC1, complete cds	blastn	1142	60.2	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica

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