metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJEB76780" and tax

19 rows where analysis = "blastn", bioproject = "PRJEB76780" 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
2688873	2688873	PRJEB76780_P_NODE_63_length_2341_cov_4.320106_g49_i0	PRJEB76780	63	2341	4.320106	101.13368146	Philodina roseola	96448	Rotifera	other_Eukaryota	2167	0	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g49	i0	86.865	67.4087996582657	1949	241	83	10	129	2068	26037	27979	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	157804	2167	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
3964954	3964954	PRJEB76780_P_NODE_764_length_936_cov_4.491309_g688_i0	PRJEB76780	764	936	4.491309	42.03865224	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	811	0	NTclustered	gi\|402761789\|gb\|JX184026.1\|	104786	g688	i0	82.86	19.9647435897436	916	146	97	11	24	934	38	947	Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	18687	811	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
5241339	5241339	PRJEB76780_P_NODE_1365_length_707_cov_7.630915_g1272_i0	PRJEB76780	1365	707	7.630915	53.95056905	Philodina citrina	468664	Rotifera	other_Eukaryota	355	4.81e-93	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1272	i0	77.052	0.930693069306931	658	125	92	20	57	703	3106	3748	Philodina citrina complete mitochondrial genome	blastn	658	355	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
5241379	5241379	PRJEB76780_P_NODE_6665_length_312_cov_1.422594_g6565_i0	PRJEB76780	6665	312	1.422594	4.43849328	Philodina roseola	96448	Rotifera	other_Eukaryota	187	7.66e-43	NTclustered	gi\|209867657\|gb\|EU637020.1\|	96448	g6565	i0	78.671	0.916666666666667	286	58	91	3	17	301	19981	19698	Philodina roseola peptidylprolyl isomerase-like 2 isoform a-like protein gene, partial cds; and chitin deacetylase 1-like protein, oxysterol-binding protein-like protein, COMM domain containing 9-like protein, T54 protein-like protein, Hox-5d, unconventional myosin heavy chain-like protein, hypothetical proteins, nuclear membrane protein XMAN1-like protein, conserved hypothetical protein, hypothetical protein, pleckstrin homology domain containing family G-like protein, cell division cycle 42-like protein, and ubiquitin ligase E3 alpha-II-like protein genes, complete cds	blastn	286	187	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
5241420	5241420	PRJEB76780_P_NODE_985_length_841_cov_3.097656_g900_i0	PRJEB76780	985	841	3.097656	26.05128696	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	584	6.749999999999998e-162	NTclustered	gi\|402761805\|gb\|JX184034.1\|	104786	g900	i0	79.738	0.997621878715815	839	144	98	21	7	833	28	852	Habrotrocha constricta NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	839	584	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
9066031	9066031	PRJEB76780_P_NODE_2248_length_552_cov_3.820459_g2148_i0	PRJEB76780	2248	552	3.820459	21.08893368	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	263	2.3100000000000002e-65	NTclustered	gi\|402761851\|gb\|JX184057.1\|	104786	g2148	i0	76.789	3.40398550724638	517	90	91	27	25	526	754	253	Habrotrocha constricta NADH dehydrogenase subunit 4 (ND4) gene, partial cds; mitochondrial	blastn	1879	263	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
9066033	9066033	PRJEB76780_P_NODE_2368_length_537_cov_1.250000_g2268_i0	PRJEB76780	2368	537	1.25	6.7125	Philodina roseola	96448	Rotifera	other_Eukaryota	549	1.5299999999999994e-151	NTclustered	gi\|194500475\|gb\|EU850440.1\|	96448	g2268	i0	90.261	79.1340782122905	421	40	78	1	79	498	3819	3399	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	42495	549	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
9066093	9066093	PRJEB76780_P_NODE_88_length_2141_cov_3.353965_g72_i0	PRJEB76780	88	2141	3.353965	71.80839065	Philodina roseola	96448	Rotifera	other_Eukaryota	845	0	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g72	i0	79.205	0.645025688930406	1308	203	59	37	739	2001	29870	28587	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	1381	845	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
15441176	15441176	PRJEB76780_P_NODE_10793_length_251_cov_1.314607_g10693_i0	PRJEB76780	10793	251	1.314607	3.29966357	Adineta vaga	104782	Rotifera	other_Eukaryota	187	5.98e-43	NTclustered	gi\|194500447\|gb\|EU850438.1\|	104782	g10693	i0	87.654	4.90438247011952	162	19	65	1	90	251	6268	6428	Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds	blastn	1231	187	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
16715487	16715487	PRJEB76780_P_NODE_4994_length_363_cov_1.124138_g4894_i0	PRJEB76780	4994	363	1.124138	4.08062094	Philodina megalotrocha	1234259	Rotifera	other_Eukaryota	656	0	NTclustered	gi\|2537903859\|gb\|KF561101.2\|	1234259	g4894	i0	99.446	99.870523415978	361	2	99	0	3	363	490	850	Philodina megalotrocha isolate A752_PM2 18S ribosomal RNA gene, partial sequence	blastn	36253	656	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina megalotrocha
16715520	16715520	PRJEB76780_P_NODE_9354_length_265_cov_3.208333_g9254_i0	PRJEB76780	9354	265	3.208333	8.50208245	Philodina citrina	468664	Rotifera	other_Eukaryota	305	1.68e-78	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g9254	i0	87.64	2.29056603773585	267	28	100	5	1	265	9715	9452	Philodina citrina complete mitochondrial genome	blastn	607	305	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
17990257	17990257	PRJEB76780_P_NODE_1355_length_712_cov_3.913928_g1262_i0	PRJEB76780	1355	712	3.913928	27.86716736	Adineta ricciae	249248	Rotifera	other_Eukaryota	577	9.499999999999999e-160	NTclustered	gi\|62362195\|gb\|AY942837.1\|	249248	g1262	i0	83.439	0.882022471910112	628	96	88	7	90	712	637	13	Adineta ricciae ribosomal protein S7-like protein mRNA, complete cds	blastn	628	577	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
17990266	17990266	PRJEB76780_P_NODE_215_length_1535_cov_23.638851_g180_i0	PRJEB76780	215	1535	23.638851	362.85636285	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	1600	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g180	i0	85.789	44.7335504885993	1520	204	99	11	2	1515	16	1529	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	68666	1600	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
19264274	19264274	PRJEB76780_P_NODE_13216_length_242_cov_1.384615_g13116_i0	PRJEB76780	13216	242	1.384615	3.3507683	Adineta vaga	104782	Rotifera	other_Eukaryota	76.8	1.29e-9	NTclustered	gi\|187233669\|gb\|EU643501.1\|	104782	g13116	i0	86.765	0.28099173553719	68	9	28	0	3	70	307	374	Adineta vaga unknown mRNA	blastn	68	76.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
19264294	19264294	PRJEB76780_P_NODE_2896_length_484_cov_1.425791_g2796_i0	PRJEB76780	2896	484	1.425791	6.90082844	Philodina roseola	96448	Rotifera	other_Eukaryota	449	1.4299999999999995e-121	NTclustered	gi\|572455658\|gb\|KF159019.1\|	96448	g2796	i0	83.471	4.59710743801653	484	78	99	2	1	483	630	148	Philodina roseola methionine adenosyltransferase mRNA, partial cds	blastn	2225	449	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
21815443	21815443	PRJEB76780_P_NODE_1158_length_771_cov_106.488539_g1068_i0	PRJEB76780	1158	771	106.488539	821.02663569	Philodina citrina	468664	Rotifera	other_Eukaryota	647	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1068	i0	82.338	16.8274967574578	770	112	99	21	3	764	2412	1659	Philodina citrina complete mitochondrial genome	blastn	12974	647	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
22673358	22673358	PRJEB76780_P_NODE_8198_length_283_cov_1.247619_g8098_i0	PRJEB76780	8198	283	1.247619	3.53076177	Metazoa	33208	Rotifera	other_Eukaryota	507	4.64e-139	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g8098	i0	98.944	55.9575971731449	284	2	100	1	1	283	1509	1792	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	15836	507	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
23090692	23090692	PRJEB76780_P_NODE_1699_length_634_cov_9.456328_g1602_i0	PRJEB76780	1699	634	9.456328	59.95311952	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	616	1.7799999999999996e-171	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g1602	i0	84.918	21.6466876971609	610	90	96	2	23	630	624	15	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	13724	616	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
24364527	24364527	PRJEB76780_P_NODE_10820_length_251_cov_0.910112_g10720_i0	PRJEB76780	10820	251	0.910112	2.28438112	Philodina roseola	96448	Rotifera	other_Eukaryota	226	1.2699999999999999e-54	NTclustered	gi\|194500491\|gb\|EU850441.1\|	96448	g10720	i0	87.629	68.5657370517928	194	24	77	0	53	246	7390	7583	Philodina roseola dihydrogenpyrimidine dehydrogenase gene, partial cds; translation initiation factor eIF-4E, rho GTPase activating protein, 7 transmembrane protein 66, histone H4, histone H3, histone H2B, osteopetrosis associated transmembrane protein, cleft lip and palate associated transmembrane, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, filament protein, hypothetical protein 21, and putative GPCR genes, complete cds; and hypothetical protein 22 gene, partial cds	blastn	17210	226	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola

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