metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA944406" 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
925070	925070	PRJNA944406_P_NODE_92981_length_244_cov_2.304094_g92022_i0	PRJNA944406	92981	244	2.304094	5.62198936	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	207	4.44e-49	NTclustered	gi\|402761779\|gb\|JX184021.1\|	104788	g92022	i0	81.967	37.172131147541	244	44	100	0	1	244	799	1042	Macrotrachela quadricornifera isolate HR cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	9070	207	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
2199559	2199559	PRJNA944406_P_NODE_11962_length_363_cov_5.100000_g11003_i0	PRJNA944406	11962	363	5.1	18.513	Adineta vaga	104782	Rotifera	other_Eukaryota	610	4.529999999999999e-170	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g11003	i0	98.551	4.28099173553719	345	5	95	0	1	345	10054	10398	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	1554	610	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
3474986	3474986	PRJNA944406_P_NODE_15003_length_331_cov_2.922481_g14044_i0	PRJNA944406	15003	331	2.922481	9.67341211	Adineta vaga complex sp. F JFF-2016	1813169	Rotifera	other_Eukaryota	599	8.879999999999997e-167	NTclustered	gi\|1005055536\|gb\|KU860679.1\|	1813169	g14044	i0	99.396	50.7794561933535	331	1	100	1	1	331	1117	1446	Adineta vaga complex sp. F JFF-2016 isolate C210 28S ribosomal RNA gene, partial sequence	blastn	16808	599	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. F JFF-2016
4753284	4753284	PRJNA944406_P_NODE_724_length_1514_cov_4.095767_g404_i0	PRJNA944406	724	1514	4.095767	62.00991238	Brachionus rubens	392764	Rotifera	other_Eukaryota	1341	0	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g404	i0	82.727	53.4861294583884	1511	257	99	4	1	1509	17	1525	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	80978	1341	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
6028111	6028111	PRJNA944406_P_NODE_765_length_1480_cov_5.317697_g430_i0	PRJNA944406	765	1480	5.317697	78.7019156	Brachionus rubens	392764	Rotifera	other_Eukaryota	673	0	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g430	i0	75.408	13.9033783783784	1472	319	98	37	13	1460	5618	7070	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	20577	673	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
7302312	7302312	PRJNA944406_P_NODE_1586_length_1108_cov_5.449275_g1007_i0	PRJNA944406	1586	1108	5.449275	60.377967	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	392	5.849999999999999e-104	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g1007	i0	75.05	18.543321299639	1006	169	88	73	96	1065	1413	2372	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	20546	392	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
8577104	8577104	PRJNA944406_P_NODE_11147_length_374_cov_1.378738_g10188_i0	PRJNA944406	11147	374	1.378738	5.15648012	Encentrum tectipes	360662	Rotifera	other_Eukaryota	520	8.119999999999998e-143	NTclustered	gi\|83285187\|gb\|DQ297734.1\|	360662	g10188	i0	91.733	35.6149732620321	375	29	99	2	1	373	721	347	Encentrum tectipes 28S ribosomal RNA gene, partial sequence	blastn	13320	520	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Dicranophoridae	Encentrum	Encentrum tectipes
8577150	8577150	PRJNA944406_P_NODE_13107_length_350_cov_4.361011_g12148_i0	PRJNA944406	13107	350	4.361011	15.2635385	Lecane bulla	96446	Rotifera	other_Eukaryota	579	1.2299999999999996e-160	NTclustered	gi\|61200802\|gb\|AY829083.1\|	96446	g12148	i0	96.338	86.0914285714286	355	8	100	2	1	350	1716	1362	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	30132	579	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
9852654	9852654	PRJNA944406_P_NODE_50268_length_263_cov_1.363158_g49309_i0	PRJNA944406	50268	263	1.363158	3.58510554	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	327	3.56e-85	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g49309	i0	89.272	1.53231939163498	261	28	99	0	1	261	441	181	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	403	327	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
10188068	10188068	PRJNA944406_P_NODE_16468_length_318_cov_2.922449_g15509_i0	PRJNA944406	16468	318	2.922449	9.29338782	Lecane	96445	Rotifera	other_Eukaryota	484	2.4799999999999998e-132	NTclustered	gi\|61200802\|gb\|AY829083.1\|	96446	g15509	i0	94.099	72.5660377358491	322	14	100	5	1	318	1759	2079	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	23076	484	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
12404184	12404184	PRJNA944406_P_NODE_91490_length_245_cov_0.895349_g90531_i0	PRJNA944406	91490	245	0.895349	2.19360505	Philodina citrina	468664	Rotifera	other_Eukaryota	331	2.5400000000000002e-86	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g90531	i0	91.02	1	245	22	100	0	1	245	4967	5211	Philodina citrina complete mitochondrial genome	blastn	245	331	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
12738752	12738752	PRJNA944406_P_NODE_19050_length_301_cov_1.350877_g18091_i0	PRJNA944406	19050	301	1.350877	4.06613977	Eurotatoria	2816136	Rotifera	other_Eukaryota	302	2.5200000000000006e-77	NTclustered	gi\|402761755\|gb\|JX184009.1\|	104782	g18091	i0	84.868	23.3953488372093	304	40	100	6	1	301	471	171	Adineta vaga cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	7042	302	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13678161	13678161	PRJNA944406_P_NODE_3651_length_701_cov_4.482484_g2774_i0	PRJNA944406	3651	701	4.482484	31.42221284	Philodina citrina	468664	Rotifera	other_Eukaryota	726	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2774	i0	85.552	22.7617689015692	706	89	99	12	2	701	2393	1695	Philodina citrina complete mitochondrial genome	blastn	15956	726	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
13678306	13678306	PRJNA944406_P_NODE_4871_length_591_cov_3.434363_g3935_i0	PRJNA944406	4871	591	3.434363	20.29708533	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	243	3.230000000000001e-59	NTclustered	gi\|1800329609\|gb\|MN417951.1\|	104777	g3935	i0	77.831	5.94416243654822	415	76	69	14	177	584	9835	10240	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	3513	243	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
14952412	14952412	PRJNA944406_P_NODE_3672_length_699_cov_5.043131_g2792_i0	PRJNA944406	3672	699	5.043131	35.25148569	Philodina citrina	468664	Rotifera	other_Eukaryota	878	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2792	i0	89.474	26.7653791130186	703	62	99	12	3	699	2391	1695	Philodina citrina complete mitochondrial genome	blastn	18709	878	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
16227203	16227203	PRJNA944406_P_NODE_17553_length_310_cov_3.097046_g16594_i0	PRJNA944406	17553	310	3.097046	9.6008426	Adineta vaga complex sp. B JFF-2016	1813165	Rotifera	other_Eukaryota	573	4.999999999999998e-159	NTclustered	gi\|1005055632\|gb\|KU860775.1\|	1813165	g16594	i0	100	99.1935483870968	310	0	100	0	1	310	133	442	Adineta vaga complex sp. B JFF-2016 isolate H158b 28S ribosomal RNA gene, partial sequence	blastn	30750	573	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. B JFF-2016
16227507	16227507	PRJNA944406_P_NODE_4433_length_628_cov_1.376577_g3512_i0	PRJNA944406	4433	628	1.376577	8.64490356	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	756	0	NTclustered	gi\|402761731\|gb\|JX183997.1\|	104788	g3512	i0	88.376	76.9331210191083	628	73	100	0	1	628	231	858	Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	48314	756	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
17502477	17502477	PRJNA944406_P_NODE_18074_length_308_cov_2.936170_g17115_i0	PRJNA944406	18074	308	2.93617	9.0434036	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	339	1.97e-88	NTclustered	gi\|402761761\|gb\|JX184012.1\|	104788	g17115	i0	86.645	13.4383116883117	307	39	99	2	3	308	624	319	Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	4139	339	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
18776635	18776635	PRJNA944406_P_NODE_7015_length_477_cov_2.138614_g6059_i0	PRJNA944406	7015	477	2.138614	10.20118878	Brachionus rubens	392764	Rotifera	other_Eukaryota	224	9.3e-54	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g6059	i0	85.581	29.9035639412998	215	29	45	2	11	224	653	866	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	14264	224	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
19110796	19110796	PRJNA944406_P_NODE_3195_length_758_cov_6.132847_g2347_i0	PRJNA944406	3195	758	6.132847	46.48698026	Eurotatoria	2816136	Rotifera	other_Eukaryota	1288	0	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g2347	i0	97.361	43.179419525066	758	18	100	2	1	758	2222	1467	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	32730	1293	0.996133023975251	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
20050871	20050871	PRJNA944406_P_NODE_15096_length_330_cov_7.143969_g14137_i0	PRJNA944406	15096	330	7.143969	23.5750977	Adineta vaga	104782	Rotifera	other_Eukaryota	588	1.9099999999999998e-163	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g14137	i0	98.788	43.7848484848485	330	4	100	0	1	330	2712	2383	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	14449	588	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
21326372	21326372	PRJNA944406_P_NODE_1657_length_1090_cov_2.650934_g1062_i0	PRJNA944406	1657	1090	2.650934	28.8951806	Brachionus rubens	392764	Rotifera	other_Eukaryota	667	0	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g1062	i0	80.359	27.3853211009174	891	165	81	10	2	887	18	903	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	29850	667	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
22601994	22601994	PRJNA944406_P_NODE_7578_length_456_cov_1.900783_g6622_i0	PRJNA944406	7578	456	1.900783	8.66757048	Brachionus rubens	392764	Rotifera	other_Eukaryota	211	6.89e-50	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g6622	i0	75.599	2.81140350877193	459	94	99	16	1	450	8788	9237	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	1282	211	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
22937274	22937274	PRJNA944406_P_NODE_71318_length_249_cov_1.750000_g70359_i0	PRJNA944406	71318	249	1.75	4.3575	Philodina	44581	Rotifera	other_Eukaryota	350	7.14e-92	NTclustered	gi\|71840344\|gb\|DQ078619.1\|	338313	g70359	i0	92.593	98.995983935743	243	18	98	0	1	243	149	391	Philodina sp. CWB-2005 clone Bear1.2 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	24650	350	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. CWB-2005

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