metadata: contig_metadata: 29 rows where bioproject = "PRJNA330616" and tax

29 rows where bioproject = "PRJNA330616" 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
1069336	1069336	PRJNA330616_P_NODE_20821_length_185_cov_1.500000_g20412_i0	PRJNA330616	20821	185	1.5	2.775	Metazoa	33208	Rotifera	other_Eukaryota	337	3.89e-88	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g20412	i0	99.459	24.1297297297297	185	1	100	0	1	185	2965	3149	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	4464	337	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
2940361	2940361	PRJNA330616_P_NODE_24643_length_170_cov_1.264463_g24234_i0	PRJNA330616	24643	170	1.264463	2.1495871	Adineta oculata	338306	Rotifera	other_Eukaryota	315	1.64e-81	NTclustered	gi\|71840136\|gb\|DQ078515.1\|	338306	g24234	i0	100	95.3470588235294	170	0	100	0	1	170	123	292	Adineta oculata clone War1.1 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	16209	315	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta oculata
3620050	3620050	PRJNA330616_P_NODE_25103_length_168_cov_1.714286_g24694_i0	PRJNA330616	25103	168	1.714286	2.88000048	Philodinidae	44580	Rotifera	other_Eukaryota	311	2.11e-80	NTclustered	gi\|1399047\|gb\|U41281.1\|PAU41281	44582	g24694	i0	100	99.9940476190476	168	0	100	0	1	168	1423	1256	Philodina acuticornis 18S rRNA gene	blastn	16799	311	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina acuticornis
5493172	5493172	PRJNA330616_P_NODE_18765_length_194_cov_1.896552_g18356_i0	PRJNA330616	18765	194	1.896552	3.67931088	Adineta vaga	104782	Rotifera	other_Eukaryota	359	8.809999999999999e-95	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g18356	i0	100	5.58762886597938	194	0	100	0	1	194	10243	10050	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	1084	359	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
6172411	6172411	PRJNA330616_P_NODE_7365_length_306_cov_6.665370_g6956_i0	PRJNA330616	7365	306	6.66537	20.3960322	Adineta	104781	Rotifera	other_Eukaryota	566	8.239999999999998e-157	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g6956	i0	100	26.5947712418301	306	0	100	0	1	306	1513	1818	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	8138	566	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
8043128	8043128	PRJNA330616_P_NODE_4947_length_380_cov_3.477341_g4538_i0	PRJNA330616	4947	380	3.477341	13.2138958	Philodina citrina	468664	Rotifera	other_Eukaryota	411	5.189999999999999e-110	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g4538	i0	87.027	33.8131578947368	370	41	97	6	13	380	1834	2198	Philodina citrina complete mitochondrial genome	blastn	12849	411	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
9317788	9317788	PRJNA330616_P_NODE_29168_length_164_cov_0.886957_g28759_i0	PRJNA330616	29168	164	0.886957	1.45460948	Adineta ricciae	249248	Rotifera	other_Eukaryota	106	5.42e-25	NR	CAF1403046.1	249248	g28759	i0	96.2	0.969512195121951	53	2	97	0	3	161	1600	1652	CAF1403046.1 unnamed protein product [Adineta ricciae]	diamond	159	106	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
11868393	11868393	PRJNA330616_P_NODE_2790_length_528_cov_5.012526_g2386_i0	PRJNA330616	2790	528	5.012526	26.46613728	Adineta vaga	104782	Rotifera	other_Eukaryota	832	0	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g2386	i0	95.085	96.4375	529	24	100	2	1	528	6975	7502	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	50919	832	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13143420	13143420	PRJNA330616_P_NODE_6651_length_324_cov_1.665455_g6242_i0	PRJNA330616	6651	324	1.665455	5.3960742	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	405	2.03e-108	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g6242	i0	89.198	75.2962962962963	324	35	100	0	1	324	565	242	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	24396	405	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
15692363	15692363	PRJNA330616_P_NODE_24153_length_172_cov_1.243902_g23744_i0	PRJNA330616	24153	172	1.243902	2.13951144	Adineta steineri	433720	Rotifera	other_Eukaryota	73.6	8e-15	NR	CAF3790859.1	433720	g23744	i0	89.3	0.976744186046512	56	6	97.7	0	170	3	4	59	CAF3790859.1 unnamed protein product [Adineta steineri]	diamond	168	73.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
16967233	16967233	PRJNA330616_P_NODE_7114_length_312_cov_3.703422_g6705_i0	PRJNA330616	7114	312	3.703422	11.55467664	Adineta vaga	104782	Rotifera	other_Eukaryota	577	3.89e-160	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g6705	i0	100	89.7147435897436	312	0	100	0	1	312	503	814	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	27991	577	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
18241133	18241133	PRJNA330616_P_NODE_11495_length_244_cov_1.138462_g11086_i0	PRJNA330616	11495	244	1.138462	2.77784728	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	237	5.6600000000000005e-58	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g11086	i0	85.246	2.15573770491803	244	21	97	10	8	244	9424	9189	Rotaria rotatoria mitochondrion, complete genome	blastn	526	237	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
18920934	18920934	PRJNA330616_P_NODE_5415_length_361_cov_19.400641_g5006_i0	PRJNA330616	5415	361	19.400641	70.03631401	Opisthokonta	33154	Rotifera	other_Eukaryota	634	2.6699999999999993e-177	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g5006	i0	98.338	78.4930747922438	361	6	100	0	1	361	7010	6650	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	28336	640	0.990625	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
24615784	24615784	PRJNA330616_P_NODE_22960_length_176_cov_2.007874_g22551_i0	PRJNA330616	22960	176	2.007874	3.53385824	Adineta vaga	104782	Rotifera	other_Eukaryota	206	1.08e-48	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g22551	i0	87.778	101.909090909091	180	17	100	3	1	176	6498	6320	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	17936	206	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
26726027	26726027	PRJNA330616_P_NODE_18801_length_194_cov_1.406897_g18392_i0	PRJNA330616	18801	194	1.406897	2.72938018	Adineta ricciae	249248	Rotifera	other_Eukaryota	121	6.0299999999999986e-34	NR	CAF1572320.1	249248	g18392	i0	93.7	1.94845360824742	63	4	97.4	0	193	5	24	86	CAF1572320.1 unnamed protein product [Adineta ricciae]	diamond	378	121	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
26821613	26821613	PRJNA330616_P_NODE_32021_length_161_cov_0.910714_g31612_i0	PRJNA330616	32021	161	0.910714	1.46624954	Adineta vaga	104782	Rotifera	other_Eukaryota	102	8.53e-24	NR	UJR35326.1	104782	g31612	i0	88.7	0.987577639751553	53	6	98.8	0	1	159	58	110	UJR35326.1 hypothetical protein I4U23_028087 [Adineta vaga]	diamond	159	102	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29064232	29064232	PRJNA330616_P_NODE_25868_length_167_cov_0.864407_g25459_i0	PRJNA330616	25868	167	0.864407	1.44355969	Adineta ricciae	249248	Rotifera	other_Eukaryota	98.6	5.3e-25	NR	CAF0905598.1	249248	g25459	i0	86.7	1.07784431137725	60	3	98.8	1	167	3	50	109	CAF0905598.1 unnamed protein product [Adineta ricciae]	diamond	180	98.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
29853564	29853564	PRJNA330616_P_NODE_31271_length_162_cov_0.902655_g30862_i0	PRJNA330616	31271	162	0.902655	1.4623011	Adineta ricciae	249248	Rotifera	other_Eukaryota	107	9.58e-28	NR	CAF0858604.1	249248	g30862	i0	94.4	1	54	3	100	0	162	1	129	182	CAF0858604.1 unnamed protein product [Adineta ricciae]	diamond	162	107	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30232576	30232576	PRJNA330616_P_NODE_28872_length_164_cov_0.886957_g28463_i0	PRJNA330616	28872	164	0.886957	1.45460948	Adineta ricciae	249248	Rotifera	other_Eukaryota	102	1.53e-23	NR	CAF1102793.1	249248	g28463	i0	92.5	0.969512195121951	53	4	97	0	163	5	219	271	CAF1102793.1 unnamed protein product [Adineta ricciae]	diamond	159	102	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30296221	30296221	PRJNA330616_P_NODE_27772_length_165_cov_0.879310_g27363_i0	PRJNA330616	27772	165	0.87931	1.4508615	Adineta vaga	104782	Rotifera	other_Eukaryota	52	9.36e-7	NR	UJR19227.1	104782	g27363	i0	41.8	1	55	31	98.2	1	163	2	4	58	UJR19227.1 hypothetical protein I4U23_022356 [Adineta vaga]	diamond	165	52	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
30327873	30327873	PRJNA330616_P_NODE_28932_length_164_cov_0.886957_g28523_i0	PRJNA330616	28932	164	0.886957	1.45460948	Adineta ricciae	249248	Rotifera	other_Eukaryota	110	5.17e-27	NR	CAF1646830.1	249248	g28523	i0	100	1.97560975609756	54	0	98.8	0	163	2	200	253	CAF1646830.1 unnamed protein product [Adineta ricciae]	diamond	324	110	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31370443	31370443	PRJNA330616_P_NODE_28216_length_165_cov_0.879310_g27807_i0	PRJNA330616	28216	165	0.87931	1.4508615	Adineta ricciae	249248	Rotifera	other_Eukaryota	94	2.73e-21	NR	CAF1245671.1	249248	g27807	i0	96.3	0.981818181818182	54	2	98.2	0	2	163	245	298	CAF1245671.1 unnamed protein product, partial [Adineta ricciae]	diamond	162	94	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31465317	31465317	PRJNA330616_P_NODE_30056_length_163_cov_0.894737_g29647_i0	PRJNA330616	30056	163	0.894737	1.45842131	Adineta ricciae	249248	Rotifera	other_Eukaryota	63.2	3.65e-10	NR	CAF1386108.1	249248	g29647	i0	100	0.588957055214724	32	0	58.9	0	67	162	1	32	CAF1386108.1 unnamed protein product [Adineta ricciae]	diamond	96	63.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31735266	31735266	PRJNA330616_P_NODE_18057_length_198_cov_1.026846_g17648_i0	PRJNA330616	18057	198	1.026846	2.03315508	Rotaria	231623	Rotifera	other_Eukaryota	42	0.0389	NR	CAF0775847.1	392033	g17648	i0	42.2	2.90909090909091	64	26	80.3	2	27	185	652	715	CAF0775847.1 unnamed protein product [Rotaria sordida]	diamond	576	42	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
31893577	31893577	PRJNA330616_P_NODE_31037_length_162_cov_0.902655_g30628_i0	PRJNA330616	31037	162	0.902655	1.4623011	Eurotatoria	2816136	Rotifera	other_Eukaryota	100	1.26e-24	NR	CAF1213046.1	249248	g30628	i0	92.5	6.98148148148148	53	4	98.1	0	4	162	64	116	CAF1213046.1 unnamed protein product [Adineta ricciae]	diamond	1131	100	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32161238	32161238	PRJNA330616_P_NODE_29658_length_163_cov_1.333333_g29249_i0	PRJNA330616	29658	163	1.333333	2.17333279	Adineta ricciae	249248	Rotifera	other_Eukaryota	84.3	2.98e-18	NR	CAF0807537.1	249248	g29249	i0	79.2	0.975460122699387	53	11	97.5	0	1	159	35	87	CAF0807537.1 unnamed protein product [Adineta ricciae]	diamond	159	84.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32526742	32526742	PRJNA330616_P_NODE_9899_length_263_cov_2.892523_g9490_i0	PRJNA330616	9899	263	2.892523	7.60733549	Metazoa	33208	Rotifera	other_Eukaryota	155	6.68e-47	NR	RNA36257.1	10195	g9490	i0	80.5	44.6577946768061	87	17	99.2	0	261	1	43	129	RNA36257.1 40S ribosomal S15Aa [Brachionus plicatilis]	diamond	11745	155	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
32747006	32747006	PRJNA330616_P_NODE_32180_length_161_cov_0.910714_g31771_i0	PRJNA330616	32180	161	0.910714	1.46624954	Eurotatoria	2816136	Rotifera	other_Eukaryota	53.9	1.1e-6	NR	CAF2047328.1	392030	g31771	i0	96	4.19254658385093	25	1	46.6	0	161	87	231	255	CAF2047328.1 unnamed protein product [Rotaria magnacalcarata]	diamond	675	54.3	0.992633517495396	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
32809950	32809950	PRJNA330616_P_NODE_31760_length_161_cov_1.580357_g31351_i0	PRJNA330616	31760	161	1.580357	2.54437477	Eurotatoria	2816136	Rotifera	other_Eukaryota	114	4.97e-29	NR	CAF1668492.1	249248	g31351	i0	96.2	4.93788819875776	53	2	98.8	0	161	3	169	221	CAF1668492.1 unnamed protein product, partial [Adineta ricciae]	diamond	795	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae

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