metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA356682" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA356682" 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
2347911	2347911	PRJNA356682_P_NODE_6502_length_552_cov_2.695198_g5817_i0	PRJNA356682	6502	552	2.695198	14.87749296	Lecane	96445	Rotifera	other_Eukaryota	431	5.969999999999998e-116	NTclustered	gi\|2713411621\|gb\|PP594094.1\|	96446	g5817	i0	81.783	88.4673913043478	516	92	93	2	23	537	1	515	Lecane bulla isolate L.bullaPC030 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	48834	431	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
4224570	4224570	PRJNA356682_P_NODE_19544_length_326_cov_1.213439_g18853_i0	PRJNA356682	19544	326	1.213439	3.95581114	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	291	5.97e-74	NTclustered	gi\|260063821\|dbj\|AB492236.1\|	10195	g18853	i0	82.769	76.3220858895706	325	56	99	0	1	325	686	1010	Brachionus plicatilis GAPDH mRNA for glyceraldehyde-3-phosphate dehydrogenase, complete cds	blastn	24881	291	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
6774842	6774842	PRJNA356682_P_NODE_13986_length_378_cov_2.229508_g13296_i0	PRJNA356682	13986	378	2.229508	8.42754024	Brachionus rubens	392764	Rotifera	other_Eukaryota	361	5.269999999999999e-95	NTclustered	gi\|1802791203\|gb\|MN256532.1\|	392764	g13296	i0	85.227	74.2830687830688	352	50	93	2	28	378	575	925	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	28079	361	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
6774932	6774932	PRJNA356682_P_NODE_1806_length_1138_cov_34.722066_g1296_i0	PRJNA356682	1806	1138	34.722066	395.13711108	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	433	3.54e-116	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g1296	i0	75.556	14.4894551845343	1035	170	87	72	23	1017	2406	1415	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	16489	433	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
8050942	8050942	PRJNA356682_P_NODE_33287_length_259_cov_1.962366_g32596_i0	PRJNA356682	33287	259	1.962366	5.08252794	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	172	1.7399999999999999e-38	NTclustered	gi\|218117251\|emb\|AM980954.1\|	10195	g32596	i0	85.455	0.637065637065637	165	24	64	0	38	202	165	1	Brachionus plicatilis partial mRNA for 60S ribosomal protein L37a, (RPL37a gene)	blastn	165	172	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
8051291	8051291	PRJNA356682_P_NODE_6247_length_564_cov_2.329939_g5563_i0	PRJNA356682	6247	564	2.329939	13.14085596	Brachionus koreanus	1199090	Rotifera	other_Eukaryota	339	3.81e-88	NTclustered	gi\|477541870\|gb\|KC603851.1\|	1199090	g5563	i0	77.699	26.2056737588652	565	118	99	8	4	564	18	578	Brachionus sp. 'koreanus' chromosome I mitochondrion, complete sequence	blastn	14780	339	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus koreanus
8051293	8051293	PRJNA356682_P_NODE_6367_length_558_cov_2.769072_g5682_i0	PRJNA356682	6367	558	2.769072	15.45142176	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	370	1.34e-97	NTclustered	gi\|2105975276\|gb\|MZ706949.1\|	104777	g5682	i0	80.24	57.0698924731183	501	91	89	7	61	557	27244	26748	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	31845	370	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
9326140	9326140	PRJNA356682_P_NODE_8468_length_480_cov_57.063882_g7779_i0	PRJNA356682	8468	480	57.063882	273.9066336	Lepadella patella	231622	Rotifera	other_Eukaryota	649	0	NTclustered	gi\|83285192\|gb\|DQ297739.1\|	231622	g7779	i0	92.358	77.0958333333333	458	31	95	4	1	455	294	750	Lepadella patella 28S ribosomal RNA gene, partial sequence	blastn	37006	649	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lepadellidae	Lepadella	Lepadella patella
10601692	10601692	PRJNA356682_P_NODE_4569_length_664_cov_4.497462_g3902_i0	PRJNA356682	4569	664	4.497462	29.86314768	Brachionus angularis	396692	Rotifera	other_Eukaryota	97.1	3.01e-15	NTclustered	gi\|1999716433\|gb\|MT875425.1\|	396692	g3902	i0	71.322	2.69427710843373	537	109	79	37	138	659	6069	6575	Brachionus angularis chromosome I mitochondrion, complete sequence	blastn	1789	97.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
11876638	11876638	PRJNA356682_P_NODE_47650_length_200_cov_4.370079_g46959_i0	PRJNA356682	47650	200	4.370079	8.740158	Notholca acuminata	231618	Rotifera	other_Eukaryota	294	2.61e-75	NTclustered	gi\|37788189\|gb\|AY218142.1\|	231618	g46959	i0	93.467	99.325	199	11	99	2	2	200	201	5	Notholca acuminata 28S ribosomal RNA gene, partial sequence	blastn	19865	294	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Notholca	Notholca acuminata
13825640	13825640	PRJNA356682_P_NODE_2471_length_953_cov_6.902273_g1898_i0	PRJNA356682	2471	953	6.902273	65.77866169	Brachionus	10194	Rotifera	other_Eukaryota	385	8.37e-102	NTclustered	gi\|170016231\|ref\|NC_010472.1\|	10195	g1898	i0	80.755	41.0577124868835	530	70	54	28	34	551	10900	10391	Brachionus plicatilis mitochondrion part I, complete genome	blastn	39128	387	0.994832041343669	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
14426355	14426355	PRJNA356682_P_NODE_28712_length_276_cov_3.236453_g28021_i0	PRJNA356682	28712	276	3.236453	8.93261028	Proales similis	360698	Rotifera	other_Eukaryota	97.1	1.16e-15	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g28021	i0	89.61	0.278985507246377	77	7	28	1	135	211	11599	11524	Proales similis mitochondrion, complete genome	blastn	77	97.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
21473945	21473945	PRJNA356682_P_NODE_25297_length_291_cov_14.220183_g24606_i0	PRJNA356682	25297	291	14.220183	41.38073253	Ploima	84394	Rotifera	other_Eukaryota	464	2.9199999999999998e-126	NTclustered	gi\|61200802\|gb\|AY829083.1\|	96446	g24606	i0	95.533	100.969072164948	291	12	100	1	1	291	1726	1437	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	29382	464	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
21474158	21474158	PRJNA356682_P_NODE_4437_length_675_cov_34.468439_g3777_i0	PRJNA356682	4437	675	34.468439	232.66196325	Brachionus	10194	Rotifera	other_Eukaryota	119	6.54e-22	NTclustered	gi\|950655830\|gb\|KT151641.1\|	183142	g3777	i0	76.208	4.28296296296296	269	39	38	23	266	523	293	547	Brachionus quadridentatus 12S ribosomal RNA gene, partial sequence; mitochondrial	blastn	2891	119	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus quadridentatus
24623415	24623415	PRJNA356682_P_NODE_13100_length_389_cov_2.167722_g12410_i0	PRJNA356682	13100	389	2.167722	8.43243858	Lepadella patella	231622	Rotifera	other_Eukaryota	457	6.7399999999999996e-124	NTclustered	gi\|166014123\|gb\|EU252112.1\|	497825	g12410	i0	88.325	51.4061696658098	394	27	98	15	1	382	80	466	Lepadella patella oblonga internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence	blastn	19997	457	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lepadellidae	Lepadella	Lepadella patella

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