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

21 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_phylum = "Nemertea"

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
13222	13222	PRJEB10140_P_NODE_5381_length_3001_cov_194.468835_g2980_i2	PRJEB10140	5381	3001	194.468835	5836.00973835	Lineus longissimus	88925	Nemertea	other_Eukaryota	1194	0	NTclustered	gi\|2724594305\|ref\|XM_064776138.1\|	88925	g2980	i2	81.555	46.5674775074975	1453	263	48	5	1252	2701	1560	110	PREDICTED: Lineus longissimus protein transport protein Sec61 subunit alpha (LOC135490728), mRNA	blastn	139749	1194	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
13241	13241	PRJEB10140_P_NODE_5701_length_2928_cov_7.853769_g3167_i0	PRJEB10140	5701	2928	7.853769	229.95835632	Lineus longissimus	88925	Nemertea	other_Eukaryota	937	0	NTclustered	gi\|2724538349\|ref\|XM_064782171.1\|	88925	g3167	i0	78.616	25.8070355191257	1445	288	49	15	162	1600	319	1748	PREDICTED: Lineus longissimus F-box-like/WD repeat-containing protein TBL1XR1 (LOC135494266), mRNA	blastn	75563	937	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
3837700	3837700	PRJEB10140_P_NODE_11984_length_2051_cov_8.480020_g3167_i1	PRJEB10140	11984	2051	8.48002	173.9252102	Lineus longissimus	88925	Nemertea	other_Eukaryota	937	0	NTclustered	gi\|2724538349\|ref\|XM_064782171.1\|	88925	g3167	i1	78.616	36.8420282788883	1445	288	70	15	452	1890	1748	319	PREDICTED: Lineus longissimus F-box-like/WD repeat-containing protein TBL1XR1 (LOC135494266), mRNA	blastn	75563	937	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
3839560	3839560	PRJEB10140_P_NODE_8104_length_2507_cov_40.068755_g4473_i1	PRJEB10140	8104	2507	40.068755	1004.52368785	Lineus longissimus	88925	Nemertea	other_Eukaryota	549	7.559999999999997e-151	NTclustered	gi\|2724545095\|ref\|XM_064785797.1\|	88925	g4473	i1	78.052	10.6892700438771	893	180	35	13	2	883	513	1400	PREDICTED: Lineus longissimus AP-2 complex subunit mu (LOC135496464), transcript variant X4, mRNA	blastn	26798	549	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
5115601	5115601	PRJEB10140_P_NODE_5825_length_2904_cov_14.461646_g3163_i1	PRJEB10140	5825	2904	14.461646	419.96619984	Lineus longissimus	88925	Nemertea	other_Eukaryota	449	9.16e-121	NTclustered	gi\|2724545786\|ref\|XM_064786163.1\|	88925	g3163	i1	79.148	3.65358126721763	657	131	23	6	15	668	4	657	PREDICTED: Lineus longissimus splicing factor 3B subunit 4-like (LOC135496696), mRNA	blastn	10610	449	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
6390476	6390476	PRJEB10140_P_NODE_238106_length_172_cov_1.691057_g220797_i0	PRJEB10140	238106	172	1.691057	2.90861804	Lineus longissimus	88925	Nemertea	other_Eukaryota	56.5	0.001	NTclustered	gi\|2724581402\|ref\|XM_064769438.1\|	88925	g220797	i0	100	0.511627906976744	30	0	17	0	8	37	1189	1160	PREDICTED: Lineus longissimus dual specificity protein phosphatase 23-like (LOC135486563), mRNA	blastn	88	56.5	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
6390934	6390934	PRJEB10140_P_NODE_273046_length_164_cov_2.434783_g255737_i0	PRJEB10140	273046	164	2.434783	3.99304412	Lineus longissimus	88925	Nemertea	other_Eukaryota	99	1.73e-16	NTclustered	gi\|2724537864\|ref\|XM_064788429.1\|	88925	g255737	i0	80.741	6.01829268292683	135	18	80	5	17	147	21	151	PREDICTED: Lineus longissimus small ribosomal subunit protein uS5 (LOC135498218), mRNA	blastn	987	99	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
6391456	6391456	PRJEB10140_P_NODE_68206_length_538_cov_1453.378323_g51137_i0	PRJEB10140	68206	538	1453.378323	7819.17537774	Lineus longissimus	88925	Nemertea	other_Eukaryota	285	4.79e-72	NTclustered	gi\|2724590468\|ref\|XM_064774296.1\|	88925	g51137	i0	78.886	21.8940520446097	431	84	80	5	58	486	493	68	PREDICTED: Lineus longissimus large ribosomal subunit protein uL24-like (LOC135489112), mRNA	blastn	11779	285	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
11491255	11491255	PRJEB10140_P_NODE_65590_length_560_cov_1.393346_g48613_i0	PRJEB10140	65590	560	1.393346	7.8027376	Lineus ruber	88926	Nemertea	other_Eukaryota	228	8.539999999999998e-55	NTclustered	gi\|1321613146\|gb\|KY809747.1\|	88926	g48613	i0	84.188	3.45892857142857	234	37	42	0	232	465	887	654	Lineus ruber DBX mRNA, complete cds	blastn	1937	228	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus ruber
12766783	12766783	PRJEB10140_P_NODE_5371_length_3003_cov_210.536899_g2980_i1	PRJEB10140	5371	3003	210.536899	6322.42307697	Lineus longissimus	88925	Nemertea	other_Eukaryota	1194	0	NTclustered	gi\|2724594305\|ref\|XM_064776138.1\|	88925	g2980	i1	81.555	46.5364635364635	1453	263	48	5	301	1750	110	1560	PREDICTED: Lineus longissimus protein transport protein Sec61 subunit alpha (LOC135490728), mRNA	blastn	139749	1194	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
12766955	12766955	PRJEB10140_P_NODE_8091_length_2508_cov_41.790972_g4473_i0	PRJEB10140	8091	2508	41.790972	1048.11757776	Lineus longissimus	88925	Nemertea	other_Eukaryota	549	7.559999999999997e-151	NTclustered	gi\|2724545095\|ref\|XM_064785797.1\|	88925	g4473	i0	78.052	10.6850079744817	893	180	35	13	2	883	513	1400	PREDICTED: Lineus longissimus AP-2 complex subunit mu (LOC135496464), transcript variant X4, mRNA	blastn	26798	549	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
14041491	14041491	PRJEB10140_P_NODE_86452_length_423_cov_7.446524_g69175_i0	PRJEB10140	86452	423	7.446524	31.49879652	Lineus longissimus	88925	Nemertea	other_Eukaryota	54.7	0.011	NTclustered	gi\|2724558159\|ref\|XR_010449526.1\|	88925	g69175	i0	92.308	0.0921985815602837	39	2	9	1	120	157	674	712	PREDICTED: Lineus longissimus uncharacterized LOC135500869 (LOC135500869), ncRNA	blastn	39	54.7	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
15315435	15315435	PRJEB10140_P_NODE_5693_length_2929_cov_14.507986_g3163_i0	PRJEB10140	5693	2929	14.507986	424.93890994	Lineus longissimus	88925	Nemertea	other_Eukaryota	449	9.239999999999998e-121	NTclustered	gi\|2724545786\|ref\|XM_064786163.1\|	88925	g3163	i0	79.148	3.62239672243086	657	131	22	6	2262	2915	657	4	PREDICTED: Lineus longissimus splicing factor 3B subunit 4-like (LOC135496696), mRNA	blastn	10610	449	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
17864150	17864150	PRJEB10140_P_NODE_24475_length_1318_cov_16.122931_g14505_i0	PRJEB10140	24475	1318	16.122931	212.50023058	Lineus longissimus	88925	Nemertea	other_Eukaryota	464	1.46e-125	NTclustered	gi\|2724599251\|ref\|XM_064778757.1\|	88925	g14505	i0	79.781	22.3816388467375	638	129	48	0	593	1230	746	109	PREDICTED: Lineus longissimus splicing factor 3A subunit 2-like (LOC135492345), transcript variant X2, mRNA	blastn	29499	464	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
17864968	17864968	PRJEB10140_P_NODE_5355_length_3006_cov_188.193777_g2980_i0	PRJEB10140	5355	3006	188.193777	5657.10493662	Lineus longissimus	88925	Nemertea	other_Eukaryota	1194	0	NTclustered	gi\|2724594305\|ref\|XM_064776138.1\|	88925	g2980	i0	81.555	46.4900199600798	1453	263	48	5	1257	2706	1560	110	PREDICTED: Lineus longissimus protein transport protein Sec61 subunit alpha (LOC135490728), mRNA	blastn	139749	1194	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
20413829	20413829	PRJEB10140_P_NODE_51697_length_706_cov_1531.035008_g5381_i4	PRJEB10140	51697	706	1531.035008	10809.10715648	Lineus longissimus	88925	Nemertea	other_Eukaryota	196	3.08e-45	NTclustered	gi\|2724587699\|ref\|XM_064772832.1\|	88925	g5381	i4	95.161	17.0779036827195	124	6	18	0	583	706	1396	1273	PREDICTED: Lineus longissimus tubulin beta-4B chain-like (LOC135488287), mRNA	blastn	12057	196	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
21688238	21688238	PRJEB10140_P_NODE_137698_length_267_cov_1.935780_g120391_i0	PRJEB10140	137698	267	1.93578	5.1685326	Lineus longissimus	88925	Nemertea	other_Eukaryota	148	3.0299999999999998e-31	NTclustered	gi\|2724563962\|ref\|XM_064795649.1\|	88925	g120391	i0	79.612	6.9438202247191	206	42	77	0	3	208	2264	2469	PREDICTED: Lineus longissimus kinesin-like protein KIF13A (LOC135502696), transcript variant X8, mRNA	blastn	1854	148	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
21689815	21689815	PRJEB10140_P_NODE_46338_length_781_cov_62.321038_g6364_i1	PRJEB10140	46338	781	62.321038	486.72730678	Lineus longissimus	88925	Nemertea	other_Eukaryota	222	5.64e-53	NTclustered	gi\|2724595921\|ref\|XM_064777031.1\|	88925	g6364	i1	79.257	1.24071702944942	323	63	41	4	224	544	1875	1555	PREDICTED: Lineus longissimus cilia- and flagella-associated protein 100-like (LOC135491278), transcript variant X2, mRNA	blastn	969	222	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
22963548	22963548	PRJEB10140_P_NODE_14719_length_1819_cov_35.309040_g4473_i3	PRJEB10140	14719	1819	35.30904	642.2714376	Lineus longissimus	88925	Nemertea	other_Eukaryota	549	5.449999999999998e-151	NTclustered	gi\|2724545095\|ref\|XM_064785797.1\|	88925	g4473	i3	78.052	14.7322704782848	893	180	48	13	389	1270	513	1400	PREDICTED: Lineus longissimus AP-2 complex subunit mu (LOC135496464), transcript variant X4, mRNA	blastn	26798	549	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
23934839	23934839	PRJEB10140_P_NODE_71919_length_510_cov_691.616052_g54778_i0	PRJEB10140	71919	510	691.616052	3527.2418652	Metazoa	33208	Nemertea	other_Eukaryota	215	6.02e-51	NTclustered	gi\|2724564653\|ref\|XM_064796020.1\|	88925	g54778	i0	80.797	53.5705882352941	276	52	54	1	54	328	432	157	PREDICTED: Lineus longissimus large ribosomal subunit protein eL30-like (LOC135502867), mRNA	blastn	27321	215	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
24239218	24239218	PRJEB10140_P_NODE_66160_length_555_cov_2.328063_g49163_i0	PRJEB10140	66160	555	2.328063	12.92074965	Lineus longissimus	88925	Nemertea	other_Eukaryota	278	8.28e-70	NTclustered	gi\|2724574199\|ref\|XM_064765540.1\|	88925	g49163	i0	79.353	49.7495495495495	402	77	72	6	152	550	586	984	PREDICTED: Lineus longissimus regulator of G-protein signaling 7-like (LOC135484241), transcript variant X9, mRNA	blastn	27611	278	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus

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