metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA280983" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA280983" 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
371637	371637	PRJNA280983_P_NODE_10981_length_162_cov_1.805310_g10866_i0	PRJNA280983	10981	162	1.80531	2.9246022	Philodina citrina	468664	Rotifera	other_Eukaryota	222	9.709999999999999e-54	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g10866	i0	91.358	1	162	14	100	0	1	162	4976	5137	Philodina citrina complete mitochondrial genome	blastn	162	222	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
371649	371649	PRJNA280983_P_NODE_2321_length_466_cov_1.839329_g2208_i0	PRJNA280983	2321	466	1.839329	8.57127314	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	457	8.21e-124	NTclustered	gi\|402761777\|gb\|JX184020.1\|	104788	g2208	i0	84.632	5.51716738197425	462	68	99	3	6	466	256	715	Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	2571	457	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
4198752	4198752	PRJNA280983_P_NODE_1684_length_565_cov_3.978682_g1574_i0	PRJNA280983	1684	565	3.978682	22.4795533	Philodina citrina	468664	Rotifera	other_Eukaryota	747	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1574	i0	90.653	30.1097345132743	567	46	99	7	1	563	2392	1829	Philodina citrina complete mitochondrial genome	blastn	17012	747	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
5475052	5475052	PRJNA280983_P_NODE_6965_length_223_cov_0.873563_g6850_i0	PRJNA280983	6965	223	0.873563	1.94804549	Philodina roseola	96448	Rotifera	other_Eukaryota	213	8.58e-51	NTclustered	gi\|209867673\|gb\|EU637021.1\|	96448	g6850	i0	84.848	1.03587443946188	231	14	95	9	1	212	10526	10754	Philodina roseola hypothetical proteins, CNNOS1-like protein, hypothetical protein, MyoD-like protein, hypothetical protein, YTH domain family member 1-like protein, hypothetical protein, cell division cycle protein 123-like protein, hypothetical protein, Hox-6a, ubiquinol-cytochrome c reductase-like protein, hypothetical protein, G protein-coupled receptor-like protein, hypothetical protein, TPR repeat containing protein-like protein, hypothetical protein, exportin 5-like protein, zinc finger protein Cezanne-like protein, hypothetical protein, StAR-related lipid transfer (START) domain containing protein-like protein, and hypothetical protein genes, complete cds; and unknown gene	blastn	231	213	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
6749337	6749337	PRJNA280983_P_NODE_246_length_1369_cov_5.380303_g200_i0	PRJNA280983	246	1369	5.380303	73.65634807	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	1594	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g200	i0	87.719	44.9795471146822	1368	166	99	2	1	1367	155	1521	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	61577	1594	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
6749363	6749363	PRJNA280983_P_NODE_7226_length_216_cov_0.916168_g7111_i0	PRJNA280983	7226	216	0.916168	1.97892288	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	163	8.44e-36	NTclustered	gi\|260063821\|dbj\|AB492236.1\|	10195	g7111	i0	82.796	37.3425925925926	186	28	85	4	4	187	675	492	Brachionus plicatilis GAPDH mRNA for glyceraldehyde-3-phosphate dehydrogenase, complete cds	blastn	8066	163	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
8024927	8024927	PRJNA280983_P_NODE_11047_length_162_cov_0.902655_g10932_i0	PRJNA280983	11047	162	0.902655	1.4623011	Philodina roseola	96448	Rotifera	other_Eukaryota	67.6	4.81e-7	NTclustered	gi\|194500475\|gb\|EU850440.1\|	96448	g10932	i0	95.349	9.91358024691358	43	1	27	1	48	90	3911	3870	Philodina roseola rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, cleft lip and palate associated transmembrane, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, filament protein, nucleolar complex associated protein, hypothetical protein 21, putative GPCR, and hypothetical protein 22 genes, complete cds	blastn	1606	67.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
8024947	8024947	PRJNA280983_P_NODE_5087_length_282_cov_1.751073_g4972_i0	PRJNA280983	5087	282	1.751073	4.93802586	Adineta vaga	104782	Rotifera	other_Eukaryota	196	1.14e-45	NTclustered	gi\|402761771\|gb\|JX184017.1\|	104782	g4972	i0	80.876	8.1063829787234	251	46	89	2	4	253	252	3	Adineta vaga cytochrome c oxidase subunit 3 (COX3) gene, partial cds; mitochondrial	blastn	2286	196	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
8024955	8024955	PRJNA280983_P_NODE_6827_length_226_cov_1.152542_g6712_i0	PRJNA280983	6827	226	1.152542	2.60474492	Philodina roseola	96448	Rotifera	other_Eukaryota	226	1.12e-54	NTclustered	gi\|146157253\|gb\|EF484997.1\|	96448	g6712	i0	91.358	1.03097345132743	162	14	72	0	65	226	1	162	Philodina roseola clone Pr_TEL_B telomeric repeat and subterminal DNA junction	blastn	233	226	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
13812337	13812337	PRJNA280983_P_NODE_1031_length_732_cov_17.778917_g929_i0	PRJNA280983	1031	732	17.778917	130.14167244	Eurotatoria	2816136	Rotifera	other_Eukaryota	1166	0	NTclustered	gi\|72153762\|gb\|DQ089743.1\|	231624	g929	i0	97.246	38.5628415300546	690	15	94	3	30	715	1501	2190	Rotaria rotatoria 28S ribosomal RNA gene, partial sequence	blastn	28228	1177	0.990654205607477	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
14400647	14400647	PRJNA280983_P_NODE_2272_length_472_cov_1.888889_g2159_i0	PRJNA280983	2272	472	1.888889	8.91555608	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	592	2.19e-164	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g2159	i0	89.507	91.5487288135593	467	49	99	0	6	472	1259	793	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	43211	592	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
14400653	14400653	PRJNA280983_P_NODE_3352_length_372_cov_3.000000_g3237_i0	PRJNA280983	3352	372	3	11.16	Philodina roseola	96448	Rotifera	other_Eukaryota	239	2.53e-58	NTclustered	gi\|183178964\|gb\|EU432549.1\|	96448	g3237	i0	84.49	6.26075268817204	245	34	65	3	76	318	62073	62315	Philodina roseola 7 transmembrane receptor (rhodopsin family) A (7tmrA_3), 7 transmembrane receptor (rhodopsin family) B (7tmrB_3), transmembrane receptor (rhodopsin family) C (7tmrC_3), 7 transmembrane receptor (rhodopsin family) D (7tmrD_3), myosin essential light chain (MELC_3), ArkA_3 (arkA_3), ArkB_3 (arkB_3), ArkC_3 (arkC_3), TRPA_3 (TPRA_3), 82 kDa heat shock protein (hsp82_3), LicD_3 (LicD_3), low density lipoprotein receptor (LDL_3), Zn carboxypeptidase gene (Zncarb_3), phosphoribosylaminoimidazole carboxylase (PAICS_3), unknown (PrPCG0002_3), lung-like 7 transmembrane receptor (lung_3), and phosphoglycerate-bisphosphoglycerate mutase (PGAM_3) genes, complete cds	blastn	2329	239	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
14400673	14400673	PRJNA280983_P_NODE_8052_length_197_cov_1.378378_g7937_i0	PRJNA280983	8052	197	1.378378	2.71540466	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	211	2.66e-50	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g7937	i0	86.528	12.6548223350254	193	24	97	2	6	197	410	219	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	2493	211	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
16361463	16361463	PRJNA280983_P_NODE_3793_length_345_cov_2.662162_g3678_i0	PRJNA280983	3793	345	2.662162	9.1844589	Macrotrachela	104787	Rotifera	other_Eukaryota	449	9.91e-122	NTclustered	gi\|830872253\|gb\|KR133457.1\|	1659203	g3678	i0	90.56	4.92753623188406	339	32	98	0	1	339	15	353	Macrotrachela sp. CR isolate hspA_CR1 myosin light chain alkali and hypothetical protein genes, partial cds	blastn	1700	449	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela sp. CR
18223338	18223338	PRJNA280983_P_NODE_7795_length_202_cov_1.666667_g7680_i0	PRJNA280983	7795	202	1.666667	3.36666734	Philodina roseola	96448	Rotifera	other_Eukaryota	82.4	2.24e-11	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g7680	i0	92.857	1.94059405940594	56	4	28	0	147	202	5949	6004	Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds	blastn	392	82.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
18910403	18910403	PRJNA280983_P_NODE_4655_length_302_cov_0.798419_g4540_i0	PRJNA280983	4655	302	0.798419	2.41122538	Macrotrachela	104787	Rotifera	other_Eukaryota	257	5.55e-64	NTclustered	gi\|830872253\|gb\|KR133457.1\|	1659203	g4540	i0	91.489	4.49337748344371	188	15	62	1	116	302	359	172	Macrotrachela sp. CR isolate hspA_CR1 myosin light chain alkali and hypothetical protein genes, partial cds	blastn	1357	257	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela sp. CR
19497581	19497581	PRJNA280983_P_NODE_3316_length_375_cov_1.095092_g3201_i0	PRJNA280983	3316	375	1.095092	4.106595	Pleuretra lineata	468668	Rotifera	other_Eukaryota	501	2.95e-137	NTclustered	gi\|239584385\|gb\|FJ426454.1\|	468668	g3201	i0	91.257	98.144	366	32	98	0	10	375	1	366	Pleuretra lineata isolate P.line.TU.1.7 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	36804	501	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Pleuretra	Pleuretra lineata
20773134	20773134	PRJNA280983_P_NODE_2917_length_406_cov_1.294118_g2802_i0	PRJNA280983	2917	406	1.294118	5.25411908	Philodina citrina	468664	Rotifera	other_Eukaryota	399	1.2099999999999998e-106	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2802	i0	85.037	23.9113300492611	401	50	98	8	8	403	4244	4639	Philodina citrina complete mitochondrial genome	blastn	9708	399	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina

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