metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB75227" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB75227" 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
135612	135612	PRJEB75227_P_NODE_11081_length_244_cov_0.912281_g10910_i0	PRJEB75227	11081	244	0.912281	2.22596564	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	182	2.689999999999999e-41	NTclustered	gi\|469517991\|gb\|JX156075.1\|	104777	g10910	i0	86.957	2.70901639344262	161	21	66	0	3	163	919	1079	Brachionus calyciflorus argonaute A (AGOA) gene, partial cds	blastn	661	182	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
135625	135625	PRJEB75227_P_NODE_1481_length_654_cov_1.841652_g1311_i0	PRJEB75227	1481	654	1.841652	12.04440408	Adineta ricciae	249248	Rotifera	other_Eukaryota	582	1.87e-161	NTclustered	gi\|62362195\|gb\|AY942837.1\|	249248	g1311	i0	83.599	0.960244648318043	628	95	95	7	32	654	637	13	Adineta ricciae ribosomal protein S7-like protein mRNA, complete cds	blastn	628	582	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
135631	135631	PRJEB75227_P_NODE_2641_length_460_cov_3.214470_g2470_i0	PRJEB75227	2641	460	3.21447	14.786562	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	453	1.05e-122	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g2470	i0	84.532	26.65	459	70	99	1	2	460	145	602	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	12259	453	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
135633	135633	PRJEB75227_P_NODE_2941_length_431_cov_0.843575_g2770_i0	PRJEB75227	2941	431	0.843575	3.63580825	Adineta vaga	104782	Rotifera	other_Eukaryota	263	1.76e-65	NTclustered	gi\|194500463\|gb\|EU850439.1\|	104782	g2770	i0	87.446	7.7030162412993	231	25	53	4	194	422	10763	10991	Adineta vaga dihydrogenpyrimidine dehydrogenase gene, partial cds; and 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, and hypothetical protein 20 genes, complete cds	blastn	3320	263	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
2685704	2685704	PRJEB75227_P_NODE_1143_length_752_cov_1.347570_g983_i0	PRJEB75227	1143	752	1.34757	10.1337264	Philodina roseola	96448	Rotifera	other_Eukaryota	527	1.0299999999999999e-144	NTclustered	gi\|572455658\|gb\|KF159019.1\|	96448	g983	i0	84.586	20.2287234042553	532	80	71	2	222	752	806	276	Philodina roseola methionine adenosyltransferase mRNA, partial cds	blastn	15212	527	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
2685729	2685729	PRJEB75227_P_NODE_5703_length_292_cov_1.118721_g5532_i0	PRJEB75227	5703	292	1.118721	3.26666532	Anomopus telphusae	338910	Rotifera	other_Eukaryota	459	1.36e-124	NTclustered	gi\|72153748\|gb\|DQ089741.1\|	338910	g5532	i0	94.898	53.013698630137	294	13	100	1	1	292	2382	2675	Anomopus telphusae 28S ribosomal RNA gene, partial sequence	blastn	15480	459	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Anomopus	Anomopus telphusae
3961750	3961750	PRJEB75227_P_NODE_1064_length_779_cov_82.066572_g905_i0	PRJEB75227	1064	779	82.066572	639.29859588	Philodina citrina	468664	Rotifera	other_Eukaryota	645	2.8199999999999986e-180	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g905	i0	82.254	16.6649550706033	772	113	98	21	7	770	2414	1659	Philodina citrina complete mitochondrial genome	blastn	12982	645	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
3961810	3961810	PRJEB75227_P_NODE_8704_length_251_cov_2.191011_g8533_i0	PRJEB75227	8704	251	2.191011	5.49943761	Philodina roseola	96448	Rotifera	other_Eukaryota	254	5.81e-63	NTclustered	gi\|187936090\|gb\|EU652318.1\|	96448	g8533	i0	88.626	38.0358565737052	211	21	84	3	13	222	5883	6091	Philodina roseola 7TM protein 66, histone H4, histone H3, histone H2B, osteopetrosis associated transmembrane protein, cleft lip and palate associated transmembrane protein, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, filament protein, hypothetical protein 21, putative GPCR, and hypothetical protein 22 genes, complete cds	blastn	9547	254	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
10338708	10338708	PRJEB75227_P_NODE_689_length_977_cov_2.704646_g565_i0	PRJEB75227	689	977	2.704646	26.42439142	Philodina roseola	96448	Rotifera	other_Eukaryota	1081	0	NTclustered	gi\|183178937\|gb\|EU432547.1\|	96448	g565	i0	86.687	51.0399181166837	984	120	100	9	1	977	30900	29921	Philodina roseola TAR protein gene, partial cds; U1-like Zn-finger-containing protein (U1Zn_1), unknown (PruORF0001_1), unknown (PrPCG0001_1), methione sulfide reductase B (MSRB_1), Strabismus, serine-threonin kinase copy 1, plasma membrane calcium-dependent ATPase (CAse_1), myosin essential light chain (MELC_1), and 82 kDa heat shock protein (hsp82_1) genes, complete cds; FBoxLRR_1 gene, complete sequence; and TPRA_1 (TPRA_1) gene, complete cds	blastn	49866	1081	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
12474626	12474626	PRJEB75227_P_NODE_6450_length_280_cov_2.294686_g6279_i0	PRJEB75227	6450	280	2.294686	6.4251208	Metazoa	33208	Rotifera	other_Eukaryota	507	4.58e-139	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g6279	i0	99.288	56.2571428571429	281	1	100	1	1	280	1512	1792	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	15752	507	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
14163982	14163982	PRJEB75227_P_NODE_1072_length_778_cov_3.397163_g913_i0	PRJEB75227	1072	778	3.397163	26.42992814	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	501	6.44e-137	NTclustered	gi\|62362203\|gb\|AY942841.1\|	317012	g913	i0	82.771	0.723650385604113	563	96	72	1	151	712	633	71	Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds	blastn	563	501	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
14164015	14164015	PRJEB75227_P_NODE_5072_length_311_cov_2.256303_g4901_i0	PRJEB75227	5072	311	2.256303	7.01710233	Philodina sp. MR-2009	662521	Rotifera	other_Eukaryota	318	2.6e-82	NTclustered	gi\|256387158\|gb\|FJ555310.1\|	662521	g4901	i0	86.926	1.85852090032154	283	37	91	0	18	300	59	341	Philodina sp. MR-2009 myosin heavy chain type II mRNA, partial cds	blastn	578	318	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. MR-2009
16298315	16298315	PRJEB75227_P_NODE_1313_length_699_cov_1.479233_g1146_i0	PRJEB75227	1313	699	1.479233	10.33983867	Eurotatoria	2816136	Rotifera	other_Eukaryota	1136	0	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g1146	i0	95.994	44.5779685264664	699	28	100	0	1	699	2222	1524	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	31160	1142	0.994746059544658	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
16712320	16712320	PRJEB75227_P_NODE_1354_length_687_cov_5.011401_g1184_i0	PRJEB75227	1354	687	5.011401	34.42832487	Philodina roseola	96448	Rotifera	other_Eukaryota	488	4.409999999999999e-133	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g1184	i0	87.952	4.36972343522562	415	49	60	1	153	566	34879	34465	Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds	blastn	3002	488	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
23087415	23087415	PRJEB75227_P_NODE_1139_length_755_cov_2.810850_g979_i0	PRJEB75227	1139	755	2.81085	21.2219175	Philodina citrina	468664	Rotifera	other_Eukaryota	399	2.349999999999999e-106	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g979	i0	77.557	1.64503311258278	704	131	92	21	57	748	3106	3794	Philodina citrina complete mitochondrial genome	blastn	1242	399	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
23087432	23087432	PRJEB75227_P_NODE_2299_length_500_cov_2.608899_g2128_i0	PRJEB75227	2299	500	2.608899	13.044495	Adineta vaga	104782	Rotifera	other_Eukaryota	375	2.5499999999999995e-99	NTclustered	gi\|189313895\|gb\|EU637017.1\|	104782	g2128	i0	83.541	4.406	401	66	80	0	1	401	30490	30090	Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds	blastn	2203	375	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
23087434	23087434	PRJEB75227_P_NODE_239_length_1523_cov_12.486207_g175_i0	PRJEB75227	239	1523	12.486207	190.16493261	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	1589	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g175	i0	85.809	45.0479317137229	1508	202	99	11	2	1503	28	1529	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	68608	1589	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
23087478	23087478	PRJEB75227_P_NODE_779_length_917_cov_3.640995_g645_i0	PRJEB75227	779	917	3.640995	33.38792415	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	793	0	NTclustered	gi\|402761789\|gb\|JX184026.1\|	104786	g645	i0	82.812	20.1733914940022	896	145	97	9	3	894	928	38	Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	18499	793	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
24361439	24361439	PRJEB75227_P_NODE_2100_length_532_cov_1.270153_g1929_i0	PRJEB75227	2100	532	1.270153	6.75721396	Philodina roseola	96448	Rotifera	other_Eukaryota	544	7.069999999999998e-150	NTclustered	gi\|194500475\|gb\|EU850440.1\|	96448	g1929	i0	90.047	79.7406015037594	422	39	79	3	67	486	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	42422	544	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
24361447	24361447	PRJEB75227_P_NODE_3840_length_365_cov_2.493151_g3669_i0	PRJEB75227	3840	365	2.493151	9.10000115	Philodina megalotrocha	1234259	Rotifera	other_Eukaryota	652	0	NTclustered	gi\|2537903859\|gb\|KF561101.2\|	1234259	g3669	i0	99.443	99.0356164383562	359	2	98	0	4	362	848	490	Philodina megalotrocha isolate A752_PM2 18S ribosomal RNA gene, partial sequence	blastn	36148	652	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina megalotrocha
24361477	24361477	PRJEB75227_P_NODE_9060_length_250_cov_1.322034_g8889_i0	PRJEB75227	9060	250	1.322034	3.305085	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	200	7.639999999999999e-47	NTclustered	gi\|255733361\|gb\|FJ555372.1\|	10195	g8889	i0	81.526	41.352	249	41	99	5	3	250	403	647	Brachionus plicatilis ATP synthase beta subunit mRNA, partial cds	blastn	10338	200	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis

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