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

5 rows where analysis = "blastn", bioproject = "PRJNA1240805" 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
16352952	16352952	PRJNA1240805_P_NODE_4153_length_225_cov_5.448864_g4104_i0	PRJNA1240805	4153	225	5.448864	12.259944	Brachionidae	10193	Rotifera	other_Eukaryota	342	1.0599999999999999e-89	NTclustered	gi\|2177087\|gb\|U49911.1\|BPU49911	10195	g4104	i0	97.044	90.2044444444444	203	6	90	0	1	203	1640	1438	Brachionus plicatilis 18S rRNA gene, complete sequence	blastn	20296	342	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
19475462	19475462	PRJNA1240805_P_NODE_2276_length_315_cov_17.575188_g2227_i0	PRJNA1240805	2276	315	17.575188	55.3618422	Platyias quadricornis	360688	Rotifera	other_Eukaryota	309	1.58e-79	NTclustered	gi\|308156994\|gb\|GQ890459.1\|	360688	g2227	i0	86.254	41.4793650793651	291	33	92	3	1	291	633	350	Platyias quadricornis isolate DNA197 large subunit ribosomal RNA gene, partial sequence	blastn	13066	309	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Platyias	Platyias quadricornis
19475487	19475487	PRJNA1240805_P_NODE_4176_length_224_cov_8.657143_g4127_i0	PRJNA1240805	4176	224	8.657143	19.39200032	Proales similis	360698	Rotifera	other_Eukaryota	189	1.4499999999999999e-43	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g4127	i0	94.309	6.07142857142857	123	7	55	0	47	169	12362	12484	Proales similis mitochondrion, complete genome	blastn	1360	189	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
20176675	20176675	PRJNA1240805_P_NODE_2076_length_334_cov_34.764912_g2027_i0	PRJNA1240805	2076	334	34.764912	116.11480608	Lecane	96445	Rotifera	other_Eukaryota	420	7.49e-113	NTclustered	gi\|61200802\|gb\|AY829083.1\|	96446	g2027	i0	91.586	53.9311377245509	309	18	91	6	11	313	2091	1785	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	18013	420	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
24575779	24575779	PRJNA1240805_P_NODE_5560_length_193_cov_6.312500_g5511_i0	PRJNA1240805	5560	193	6.3125	12.183125	Brachionus rubens	392764	Rotifera	other_Eukaryota	147	7.419999999999999e-31	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g5511	i0	82.738	35.6735751295337	168	25	87	3	22	189	11235	11398	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	6885	147	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens

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