metadata: contig_metadata: 10 rows where bioproject = "PRJNA577226", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA577226", tax_clade = "Opisthokonta" 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
5665994	5665994	PRJNA577226_S_NODE_5525_length_593_cov_13.206835_g4614_i0	PRJNA577226	5525	593	13.206835	78.31653155	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	398	6.539999999999997e-106	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g4614	i0	80.175	32.4907251264755	570	82	95	25	11	571	1860	2407	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	19267	398	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
10766967	10766967	PRJNA577226_S_NODE_70309_length_151_cov_2.263158_g69370_i0	PRJNA577226	70309	151	2.263158	3.41736858	Keratella cochlearis	204738	Rotifera	other_Eukaryota	124	2.5699999999999997e-24	NTclustered	gi\|1020308490\|gb\|KT986313.1\|	204738	g69370	i0	81.699	4.6158940397351	153	24	100	4	1	151	421	571	Keratella cochlearis clone 19.5Montig cytochrome oxidase subunit I (CO1) gene, partial cds; mitochondrial	blastn	697	124	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Keratella	Keratella cochlearis
13316403	13316403	PRJNA577226_S_NODE_57271_length_165_cov_2.859375_g56332_i0	PRJNA577226	57271	165	2.859375	4.71796875	Asplanchna brightwellii	2005548	Rotifera	other_Eukaryota	161	2.2e-35	NTclustered	gi\|2906176134\|gb\|PV021768.1\|	2005548	g56332	i0	84.431	85.2545454545455	167	22	100	4	1	165	1267	1103	Asplanchna brightwellii chromosome II mitochondrion, complete sequence	blastn	14067	161	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna brightwellii
19689084	19689084	PRJNA577226_S_NODE_68936_length_153_cov_1.008621_g67997_i0	PRJNA577226	68936	153	1.008621	1.54319013	Brachionus angularis	396692	Rotifera	other_Eukaryota	198	1.5199999999999999e-46	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g67997	i0	91.096	95.281045751634	146	13	95	0	3	148	749	604	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	14578	198	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
23514373	23514373	PRJNA577226_S_NODE_43099_length_189_cov_2.848684_g42160_i0	PRJNA577226	43099	189	2.848684	5.38401276	Brachionus rotundiformis	96890	Rotifera	other_Eukaryota	150	5.59e-32	NTclustered	gi\|1066800230\|gb\|KX364937.1\|	96890	g42160	i0	81.421	67.6931216931217	183	34	97	0	1	183	1250	1432	Brachionus rotundiformis chromosome II mitochondrion, complete sequence	blastn	12794	150	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
27364433	27364433	PRJNA577226_S_NODE_65323_length_156_cov_1.638655_g64384_i0	PRJNA577226	65323	156	1.638655	2.5563018	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	72.8	1.39e-13	NR	CAF0792993.1	104777	g64384	i0	82.9	0.788461538461538	41	7	78.8	0	1	123	241	281	CAF0792993.1 unnamed protein product [Brachionus calyciflorus]	diamond	123	72.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
27756770	27756770	PRJNA577226_S_NODE_33324_length_216_cov_1.525140_g32385_i0	PRJNA577226	33324	216	1.52514	3.2943024	Rotaria	231623	Rotifera	other_Eukaryota	48.9	1.76e-4	NR	CAF4011093.1	392030	g32385	i0	36.5	5.05555555555556	52	33	72.2	0	212	57	1074	1125	CAF4011093.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	1092	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
29303612	29303612	PRJNA577226_S_NODE_67069_length_154_cov_2.333333_g66130_i0	PRJNA577226	67069	154	2.333333	3.59333282	Metazoa	33208	Rotifera	other_Eukaryota	47.4	2.61e-4	NR	YP_001739865.1	10195	g66130	i0	45.2	1.77272727272727	42	23	81.8	0	1	126	473	514	YP_001739865.1 cytochrome c oxidase subunit I [Brachionus plicatilis]	diamond	273	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
31501940	31501940	PRJNA577226_S_NODE_71476_length_150_cov_2.070796_g70537_i0	PRJNA577226	71476	150	2.070796	3.106194	Brachionus angularis	396692	Rotifera	other_Eukaryota	41.6	0.0102	NR	QST18670.1	396692	g70537	i0	80	0.5	25	5	50	0	75	149	18	42	QST18670.1 NADH dehydrogenase subunit 3 [Brachionus angularis]	diamond	75	41.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
32274726	32274726	PRJNA577226_S_NODE_47938_length_180_cov_1.636364_g46999_i0	PRJNA577226	47938	180	1.636364	2.9454552	Metazoa	33208	Rotifera	other_Eukaryota	61.6	3.29e-9	NR	QKV49097.1	360698	g46999	i0	61.4	1.43333333333333	44	17	73.3	0	179	48	321	364	QKV49097.1 cytochrome b [Proales similis]	diamond	258	62	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis

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