metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA738523" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA738523" 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
3270888	3270888	PRJNA738523_P_NODE_3583_length_359_cov_1.874126_g3512_i0	PRJNA738523	3583	359	1.874126	6.72811234	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	135	3.28e-27	NTclustered	gi\|2006240371\|gb\|MW559986.1\|	667381	g3512	i0	79.602	30.058495821727	201	31	55	8	163	359	10033	10227	Brachionus manjavacas isolate AU chromosome I mitochondrion, complete sequence	blastn	10791	135	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
4548042	4548042	PRJNA738523_P_NODE_224_length_1145_cov_40.987873_g192_i0	PRJNA738523	224	1145	40.987873	469.31114585	Brachionus rubens	392764	Rotifera	other_Eukaryota	501	9.64e-137	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g192	i0	80.924	26.5379912663755	671	96	61	23	452	1106	10542	11196	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	30386	501	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
5025973	5025973	PRJNA738523_P_NODE_10344_length_252_cov_1.301676_g10273_i0	PRJNA738523	10344	252	1.301676	3.28022352	Macrotrachela	104787	Rotifera	other_Eukaryota	167	7.819999999999999e-37	NTclustered	gi\|830872225\|gb\|KR133456.1\|	104788	g10273	i0	85.535	7.17857142857143	159	23	63	0	2	160	9087	8929	Macrotrachela quadricornifera isolate hisB_MQ2 histone H4, histone H3, histone H2B, and osteopetrosis associated transmembrane protein genes, complete cds; and cleft lip and palate associated transmembrane protein gene, partial cds	blastn	1809	167	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
5823142	5823142	PRJNA738523_P_NODE_285_length_1045_cov_37.992798_g192_i1	PRJNA738523	285	1045	37.992798	397.0247391	Brachionus rubens	392764	Rotifera	other_Eukaryota	492	5.28e-134	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g192	i1	81.327	28.861244019138802	648	83	64	26	58	685	11824	11195	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	30160	492	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
7098264	7098264	PRJNA738523_P_NODE_6446_length_290_cov_1.064516_g6375_i0	PRJNA738523	6446	290	1.064516	3.0870964	Philodina roseola	96448	Rotifera	other_Eukaryota	204	7.01e-48	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g6375	i0	88.235	2.39310344827586	170	20	59	0	118	287	34465	34634	Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds	blastn	694	204	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
12198944	12198944	PRJNA738523_P_NODE_570_length_800_cov_2.698762_g512_i0	PRJNA738523	570	800	2.698762	21.590096	Brachionus rubens	392764	Rotifera	other_Eukaryota	544	1.09e-149	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g512	i0	80.525	60.55625	724	127	90	13	83	799	1044	328	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	48445	544	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
13473404	13473404	PRJNA738523_P_NODE_451_length_886_cov_2.758918_g399_i0	PRJNA738523	451	886	2.758918	24.44401348	Brachionus angularis	396692	Rotifera	other_Eukaryota	756	0	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g399	i0	83.001	64.489841986456	853	127	95	15	12	855	671	1514	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	57138	756	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
13473426	13473426	PRJNA738523_P_NODE_7371_length_280_cov_1.487923_g7300_i0	PRJNA738523	7371	280	1.487923	4.1661844	Brachionus rubens	392764	Rotifera	other_Eukaryota	274	5.059999999999998e-69	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g7300	i0	84.452	96.825	283	38	100	3	1	280	901	1180	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	27111	274	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
16022142	16022142	PRJNA738523_P_NODE_2173_length_440_cov_1.258856_g2102_i0	PRJNA738523	2173	440	1.258856	5.5389664	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	499	1.26e-136	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g2102	i0	87.244	58.1295454545455	439	54	99	2	3	440	905	468	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	25577	499	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
17297645	17297645	PRJNA738523_P_NODE_674_length_743_cov_3.701493_g611_i0	PRJNA738523	674	743	3.701493	27.50209299	Asplanchna brightwellii	2005548	Rotifera	other_Eukaryota	287	1.87e-72	NTclustered	gi\|2906176134\|gb\|PV021768.1\|	2005548	g611	i0	74.406	40.4104979811575	715	161	94	17	1	699	6550	7258	Asplanchna brightwellii chromosome II mitochondrion, complete sequence	blastn	30025	287	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna brightwellii
19846513	19846513	PRJNA738523_P_NODE_2696_length_401_cov_1.521341_g2625_i0	PRJNA738523	2696	401	1.521341	6.10057741	Philodina citrina	468664	Rotifera	other_Eukaryota	390	7.169999999999999e-104	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2625	i0	84.461	86.1571072319202	399	58	99	4	5	401	1370	974	Philodina citrina complete mitochondrial genome	blastn	34549	390	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
21122165	21122165	PRJNA738523_P_NODE_877_length_657_cov_2.085616_g808_i0	PRJNA738523	877	657	2.085616	13.70249712	Asplanchna brightwellii	2005548	Rotifera	other_Eukaryota	392	3.389999999999999e-104	NTclustered	gi\|2906176134\|gb\|PV021768.1\|	2005548	g808	i0	78.187	8.29071537290715	651	117	97	21	18	657	6216	5580	Asplanchna brightwellii chromosome II mitochondrion, complete sequence	blastn	5447	392	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna brightwellii
24946028	24946028	PRJNA738523_P_NODE_700_length_728_cov_7.876336_g637_i0	PRJNA738523	700	728	7.876336	57.33972608	Philodina citrina	468664	Rotifera	other_Eukaryota	636	1.58e-177	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g637	i0	82.81	18.5302197802198	733	105	99	19	1	726	1675	2393	Philodina citrina complete mitochondrial genome	blastn	13490	636	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
24946033	24946033	PRJNA738523_P_NODE_920_length_645_cov_2.534965_g851_i0	PRJNA738523	920	645	2.534965	16.35052425	Colurella adriatica	1926392	Rotifera	other_Eukaryota	623	1.08e-173	NTclustered	gi\|1114634416\|gb\|KX387633.1\|	1926392	g851	i0	84.689	96.1937984496124	627	92	97	4	21	645	1	625	Colurella adriatica isolate CLR1 cytochrome c oxidase subunit 1 gene, partial cds; mitochondrial	blastn	62045	623	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lepadellidae	Colurella	Colurella adriatica

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