metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJEB673" and tax

25 rows where analysis = "blastn", bioproject = "PRJEB673" 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
1409456	1409456	PRJEB673_P_NODE_1482_length_781_cov_35.266756_g1256_i0	PRJEB673	1482	781	35.266756	275.43336436	Philodina citrina	468664	Rotifera	other_Eukaryota	804	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1256	i0	86.189	25.8233034571063	753	93	96	7	10	758	1654	2399	Philodina citrina complete mitochondrial genome	blastn	20168	804	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
1409466	1409466	PRJEB673_P_NODE_2162_length_664_cov_4.542130_g1889_i0	PRJEB673	2162	664	4.54213	30.1597432	Philodina citrina	468664	Rotifera	other_Eukaryota	545	2.49e-150	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1889	i0	81.504	2.03012048192771	665	113	99	4	2	664	10381	11037	Philodina citrina complete mitochondrial genome	blastn	1348	545	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
2684949	2684949	PRJEB673_P_NODE_10583_length_171_cov_2.257353_g10234_i0	PRJEB673	10583	171	2.257353	3.86007363	Brachionus rubens	392764	Rotifera	other_Eukaryota	180	6.3e-41	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g10234	i0	88.966	70.6081871345029	145	16	85	0	1	145	731	875	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	12074	180	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
5237437	5237437	PRJEB673_P_NODE_2525_length_619_cov_5.303082_g2231_i0	PRJEB673	2525	619	5.303082	32.82607758	Philodina citrina	468664	Rotifera	other_Eukaryota	649	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2231	i0	85.761	18.9983844911147	618	82	99	6	4	618	10302	9688	Philodina citrina complete mitochondrial genome	blastn	11760	649	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
6513028	6513028	PRJEB673_P_NODE_4306_length_463_cov_2.184579_g3963_i0	PRJEB673	4306	463	2.184579	10.11460077	Philodina citrina	468664	Rotifera	other_Eukaryota	292	2.43e-74	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g3963	i0	80.556	0.855291576673866	396	64	84	12	2	390	11160	11549	Philodina citrina complete mitochondrial genome	blastn	396	292	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
7787253	7787253	PRJEB673_P_NODE_1447_length_788_cov_3.023904_g1226_i0	PRJEB673	1447	788	3.023904	23.82836352	Brachionus rubens	392764	Rotifera	other_Eukaryota	612	2.89e-170	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g1226	i0	83.308	50.4060913705584	665	110	84	1	1	665	739	1402	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	39720	612	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
7787308	7787308	PRJEB673_P_NODE_5207_length_394_cov_3.097493_g4858_i0	PRJEB673	5207	394	3.097493	12.20412242	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	213	1.63e-50	NTclustered	gi\|1800329609\|gb\|MN417951.1\|	104777	g4858	i0	80.505	6.06345177664975	277	54	70	0	49	325	10111	9835	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	2389	213	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
7787314	7787314	PRJEB673_P_NODE_5847_length_364_cov_2.167173_g5498_i0	PRJEB673	5847	364	2.167173	7.88850972	Brachionus rubens	392764	Rotifera	other_Eukaryota	298	4.02e-76	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g5498	i0	82.647	38.2884615384615	340	55	93	4	24	361	458	121	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	13937	298	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
7787330	7787330	PRJEB673_P_NODE_8687_length_246_cov_1.620853_g8338_i0	PRJEB673	8687	246	1.620853	3.98729838	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	231	2.6599999999999996e-56	NTclustered	gi\|1800329609\|gb\|MN417951.1\|	104777	g8338	i0	84.1	94.7764227642276	239	38	97	0	5	243	27080	27318	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	23315	231	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
9062186	9062186	PRJEB673_P_NODE_3208_length_556_cov_2.303263_g2892_i0	PRJEB673	3208	556	2.303263	12.80614228	Philodina citrina	468664	Rotifera	other_Eukaryota	592	2.6099999999999993e-164	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2892	i0	86.022	1.06294964028777	558	70	99	6	1	554	3739	3186	Philodina citrina complete mitochondrial genome	blastn	591	592	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
11613352	11613352	PRJEB673_P_NODE_10410_length_174_cov_2.589928_g10061_i0	PRJEB673	10410	174	2.589928	4.50647472	Lecane inermis	1471631	Rotifera	other_Eukaryota	228	2.2699999999999997e-55	NTclustered	gi\|1886078471\|gb\|MT852959.1\|	1471631	g10061	i0	92.949	92.9885057471264	156	11	90	0	18	173	650	495	Lecane inermis isolate Poland_culture cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	16180	228	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane inermis
11613378	11613378	PRJEB673_P_NODE_1230_length_849_cov_2.186732_g1021_i0	PRJEB673	1230	849	2.186732	18.56535468	Philodina citrina	468664	Rotifera	other_Eukaryota	708	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1021	i0	86.119	39.6383981154299	670	77	77	15	3	658	5002	5669	Philodina citrina complete mitochondrial genome	blastn	33653	708	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
14163277	14163277	PRJEB673_P_NODE_1632_length_748_cov_64.058906_g1392_i0	PRJEB673	1632	748	64.058906	479.16061688	Philodina citrina	468664	Rotifera	other_Eukaryota	891	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1392	i0	88.919	22.6751336898396	731	69	97	10	1	725	1675	2399	Philodina citrina complete mitochondrial genome	blastn	16961	891	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
15437377	15437377	PRJEB673_P_NODE_1673_length_740_cov_3.568794_g1430_i0	PRJEB673	1673	740	3.568794	26.4090756	Philodina citrina	468664	Rotifera	other_Eukaryota	869	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1430	i0	87.838	11.6675675675676	740	90	100	0	1	740	4864	5603	Philodina citrina complete mitochondrial genome	blastn	8634	869	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
16711543	16711543	PRJEB673_P_NODE_11774_length_158_cov_1.951220_g11425_i0	PRJEB673	11774	158	1.95122	3.0829276	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	167	4.47e-37	NTclustered	gi\|402761809\|gb\|JX184036.1\|	104788	g11425	i0	86.755	1.91139240506329	151	19	95	1	5	154	43	193	Macrotrachela quadricornifera isolate CR NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	302	167	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
16711606	16711606	PRJEB673_P_NODE_5934_length_361_cov_1.398773_g5585_i0	PRJEB673	5934	361	1.398773	5.04957053	Brachionus angularis	396692	Rotifera	other_Eukaryota	154	9.12e-33	NTclustered	gi\|1999716433\|gb\|MT875425.1\|	396692	g5585	i0	87.786	1.62049861495845	131	16	36	0	6	136	8439	8309	Brachionus angularis chromosome I mitochondrion, complete sequence	blastn	585	154	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
16711608	16711608	PRJEB673_P_NODE_5974_length_359_cov_2.222222_g5625_i0	PRJEB673	5974	359	2.222222	7.97777698	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	213	1.47e-50	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g5625	i0	90.625	20.874651810585	160	15	45	0	200	359	413	254	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	7494	213	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
17573201	17573201	PRJEB673_P_NODE_614_length_1155_cov_4.378571_g468_i0	PRJEB673	614	1155	4.378571	50.57249505	Philodinida	104783	Rotifera	other_Eukaryota	1450	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g468	i0	89.341	46.1402597402597	1154	123	99	0	2	1155	226	1379	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	53292	1461	0.992470910335387	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
19260504	19260504	PRJEB673_P_NODE_316_length_1505_cov_7.187755_g228_i0	PRJEB673	316	1505	7.187755	108.17571275	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	1820	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g228	i0	88.505	48.21926910299	1505	171	99	2	2	1505	1521	18	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	72570	1820	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
21811657	21811657	PRJEB673_P_NODE_1658_length_744_cov_3.442877_g1416_i0	PRJEB673	1658	744	3.442877	25.61500488	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	673	0	NTclustered	gi\|402761809\|gb\|JX184036.1\|	104788	g1416	i0	83.423	17.0013440860215	742	105	99	15	1	734	789	58	Macrotrachela quadricornifera isolate CR NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	12649	673	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
21811691	21811691	PRJEB673_P_NODE_4358_length_457_cov_2.774882_g4014_i0	PRJEB673	4358	457	2.774882	12.68121074	Philodina citrina	468664	Rotifera	other_Eukaryota	383	1.3799999999999995e-101	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g4014	i0	81.957	1.945295404814	460	75	99	7	2	457	3207	3662	Philodina citrina complete mitochondrial genome	blastn	889	383	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
23086759	23086759	PRJEB673_P_NODE_8899_length_226_cov_1.874346_g8550_i0	PRJEB673	8899	226	1.874346	4.23602196	Philodina citrina	468664	Rotifera	other_Eukaryota	217	6.739999999999999e-52	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g8550	i0	84.141	1.66814159292035	227	33	99	3	1	225	4423	4648	Philodina citrina complete mitochondrial genome	blastn	377	217	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
24360684	24360684	PRJEB673_P_NODE_12720_length_152_cov_1.025641_g12371_i0	PRJEB673	12720	152	1.025641	1.55897432	Synchaeta vorax	2576789	Rotifera	other_Eukaryota	121	3.36e-23	NTclustered	gi\|2210476612\|gb\|ON038422.1\|	2576789	g12371	i0	81.046	60.7434210526316	153	27	100	2	1	152	212	363	Synchaeta vorax isolate 4 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	9233	121	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Synchaetidae	Synchaeta	Synchaeta vorax
24360716	24360716	PRJEB673_P_NODE_4520_length_442_cov_1.594595_g4174_i0	PRJEB673	4520	442	1.594595	7.0481099	Philodina citrina	468664	Rotifera	other_Eukaryota	274	8.379999999999998e-69	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g4174	i0	85.938	1.32805429864253	256	36	58	0	173	428	6644	6899	Philodina citrina complete mitochondrial genome	blastn	587	274	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
24360756	24360756	PRJEB673_P_NODE_8680_length_247_cov_1.320755_g8331_i0	PRJEB673	8680	247	1.320755	3.26226485	Lecane inermis	1471631	Rotifera	other_Eukaryota	424	4.1099999999999996e-114	NTclustered	gi\|1886078471\|gb\|MT852959.1\|	1471631	g8331	i0	97.571	100.534412955466	247	6	100	0	1	247	207	453	Lecane inermis isolate Poland_culture cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	24832	424	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane inermis

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