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

4 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax_phylum = "Rotifera"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6776783	6776783	PRJNA358490_P_NODE_906_length_1347_cov_8.377676_g828_i0	PRJNA358490	906	1347	8.377676	112.84729572	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	1541	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g828	i0	87.689	42.9903489235338	1324	161	98	2	22	1344	208	1530	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	57908	1541	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
8052223	8052223	PRJNA358490_P_NODE_14047_length_198_cov_1.792453_g13703_i0	PRJNA358490	14047	198	1.792453	3.54905694	Adineta vaga	104782	Rotifera	other_Eukaryota	348	1.95e-91	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g13703	i0	98.477	14.8434343434343	197	3	99	0	1	197	2585	2389	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	2939	348	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13152805	13152805	PRJNA358490_P_NODE_4591_length_652_cov_13.311582_g4326_i0	PRJNA358490	4591	652	13.311582	86.79151464	Philodina citrina	468664	Rotifera	other_Eukaryota	667	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g4326	i0	87.65	31.6871165644172	583	61	88	10	77	652	1828	2406	Philodina citrina complete mitochondrial genome	blastn	20660	667	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
24625359	24625359	PRJNA358490_P_NODE_8920_length_391_cov_3.224432_g8579_i0	PRJNA358490	8920	391	3.224432	12.60752912	Adineta vaga	104782	Rotifera	other_Eukaryota	350	1.18e-91	NTclustered	gi\|402761723\|gb\|JX183993.1\|	104782	g8579	i0	83.646	0.953964194373402	373	59	95	1	1	371	620	248	Adineta vaga ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial	blastn	373	350	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga

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