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

7 rows where analysis = "blastn", bioproject = "PRJEB81463" 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
997294	997294	PRJEB81463_P_NODE_12341_length_291_cov_2.779817_g12069_i0	PRJEB81463	12341	291	2.779817	8.08926747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	207	5.44e-49	NTclustered	gi\|330790587\|ref\|XM_003283330.1\|	5786	g12069	i0	83.945	101.168384879725	218	33	75	2	75	291	995	779	Dictyostelium purpureum ubiquitin (DICPUDRAFT_44796), mRNA	blastn	29440	207	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
11200722	11200722	PRJEB81463_P_NODE_9069_length_334_cov_2.291188_g8797_i0	PRJEB81463	9069	334	2.291188	7.65256792	Dictyostelium	5782	Evosea	other_Eukaryota	243	1.7400000000000004e-59	NTclustered	gi\|167938\|gb\|M23749.1\|DDIUBIQB	44689	g8797	i0	80.615	104.455089820359	325	54	96	7	13	334	36	354	D.discoideum ubiquitin mRNA, complete cds, clone DCUBV45	blastn	34888	243	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
17992229	17992229	PRJEB81463_P_NODE_7735_length_361_cov_2.211806_g7463_i0	PRJEB81463	7735	361	2.211806	7.98461966	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	250	1.13e-61	NTclustered	gi\|330818907\|ref\|XM_003291484.1\|	5786	g7463	i0	79.83	15.8310249307479	352	63	97	6	1	349	356	10	Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA	blastn	5715	250	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
20541644	20541644	PRJEB81463_P_NODE_6697_length_386_cov_3.239617_g6425_i0	PRJEB81463	6697	386	3.239617	12.50492162	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	176	2.1e-39	NTclustered	gi\|66826022\|ref\|XM_641274.1\|	352472	g6425	i0	86.709	4.44818652849741	158	21	41	0	189	346	200	43	Dictyostelium discoideum AX4 S60 ribosomal protein L36a (rpl36a) mRNA, complete cds	blastn	1717	176	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
23092684	23092684	PRJEB81463_P_NODE_9899_length_321_cov_0.963710_g9627_i0	PRJEB81463	9899	321	0.96371	3.0935091	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	252	2.77e-62	NTclustered	gi\|330797960\|ref\|XM_003286977.1\|	5786	g9627	i0	84.585	135.11214953271	253	39	79	0	69	321	535	283	Dictyostelium purpureum ubiquitin (DICPUDRAFT_94309), mRNA	blastn	43371	252	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
24366475	24366475	PRJEB81463_P_NODE_5920_length_411_cov_1.976331_g5648_i0	PRJEB81463	5920	411	1.976331	8.12272041	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	326	2.11e-84	NTclustered	gi\|330822609\|ref\|XM_003291694.1\|	5786	g5648	i0	81.297	5.67639902676399	401	75	98	0	11	411	145	545	Dictyostelium purpureum uncharacterized protein (rasG), mRNA	blastn	2333	326	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
25223455	25223455	PRJEB81463_P_NODE_11240_length_303_cov_1.760870_g10968_i0	PRJEB81463	11240	303	1.76087	5.3354361	Acytosteliales	2058181	Evosea	other_Eukaryota	230	1.2099999999999995e-55	NTclustered	gi\|470263923\|ref\|XM_004360999.1\|	261658	g10968	i0	81.818	23.1815181518152	286	40	92	8	23	302	679	958	Cavenderia fasciculata vacuolar H+-ATPase A subunit (vatA), partial mRNA	blastn	7024	230	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata

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