metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA849822" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA849822" 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
838483	838483	PRJNA849822_P_NODE_1301_length_1417_cov_3.645089_g1211_i0	PRJNA849822	1301	1417	3.645089	51.65091113	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	1002	0	NTclustered	gi\|170319457\|ref\|NC_010484.1\|	10195	g1211	i0	79.395	13	1422	278	99	12	3	1417	7081	5668	Brachionus plicatilis mitochondrion part II, complete genome	blastn	18421	1002	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
838644	838644	PRJNA849822_P_NODE_33581_length_253_cov_0.866667_g33407_i0	PRJNA849822	33581	253	0.866667	2.19266751	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	398	2.5599999999999996e-106	NTclustered	gi\|1893867562\|gb\|MT524866.1\|	10195	g33407	i0	95.219	0.992094861660079	251	12	99	0	3	253	3631	3881	Brachionus plicatilis ATP-binding cassette transporter subfamily A member 3-like protein X2 mRNA, complete cds	blastn	251	398	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
838781	838781	PRJNA849822_P_NODE_8121_length_533_cov_3.000000_g7949_i0	PRJNA849822	8121	533	3	15.99	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	331	6e-86	NTclustered	gi\|170016231\|ref\|NC_010472.1\|	10195	g7949	i0	78.189	1.01500938086304	541	102	100	16	1	533	9122	9654	Brachionus plicatilis mitochondrion part I, complete genome	blastn	541	331	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
2113941	2113941	PRJNA849822_P_NODE_1402_length_1364_cov_3.821844_g1307_i0	PRJNA849822	1402	1364	3.821844	52.12995216	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	1345	0	NTclustered	gi\|1800329609\|gb\|MN417951.1\|	104777	g1307	i0	84.514	44.0161290322581	1369	202	100	9	1	1364	27549	26186	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	60038	1345	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
2113984	2113984	PRJNA849822_P_NODE_19362_length_329_cov_1.187500_g19188_i0	PRJNA849822	19362	329	1.1875	3.906875	Brachionus angularis	396692	Rotifera	other_Eukaryota	52.8	0.031	NTclustered	gi\|2029759110\|gb\|MW026559.1\|	396692	g19188	i0	100	0.0851063829787234	28	0	9	0	116	143	4392	4419	Brachionus angularis ATP-binding cassette transporter Abca3-like1 mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
2114015	2114015	PRJNA849822_P_NODE_24362_length_293_cov_1.977273_g24188_i0	PRJNA849822	24362	293	1.977273	5.79340989	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	182	3.32e-41	NTclustered	gi\|1800329618\|gb\|MN417952.1\|	104777	g24188	i0	79.842	3.10921501706485	253	48	86	3	37	287	2637	2888	Brachionus calyciflorus chromosome II mitochondrion, complete sequence	blastn	911	182	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
2114057	2114057	PRJNA849822_P_NODE_30122_length_266_cov_1.616580_g29948_i0	PRJNA849822	30122	266	1.61658	4.3001028	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	429	9.62e-116	NTclustered	gi\|1033208568\|gb\|KU361817.1\|	10195	g29948	i0	95.849	0.996240601503759	265	11	99	0	2	266	34	298	Brachionus plicatilis cathepsin L mRNA, complete cds	blastn	265	429	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
8491498	8491498	PRJNA849822_P_NODE_30207_length_266_cov_1.331606_g30033_i0	PRJNA849822	30207	266	1.331606	3.54207196	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	486	5.629999999999999e-133	NTclustered	gi\|37788165\|gb\|AY218118.1\|	10195	g30033	i0	99.624	100.015037593985	266	1	100	0	1	266	865	600	Brachionus plicatilis strain L 18S ribosomal RNA gene, partial sequence	blastn	26604	486	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
12317864	12317864	PRJNA849822_P_NODE_37990_length_248_cov_0.891429_g37816_i0	PRJNA849822	37990	248	0.891429	2.21074392	Brachionus paranguensis	2599771	Rotifera	other_Eukaryota	427	3.1899999999999998e-115	NTclustered	gi\|2040501338\|gb\|MW521300.1\|	2599771	g37816	i0	97.967	2.98387096774194	246	5	99	0	3	248	97	342	Brachionus paranguensis isolate Bpa_CYP3047A1 cytochrome P450 mRNA, complete cds	blastn	740	427	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus paranguensis
13592279	13592279	PRJNA849822_P_NODE_2251_length_1096_cov_2.580645_g2129_i0	PRJNA849822	2251	1096	2.580645	28.2838692	Brachionus rubens	392764	Rotifera	other_Eukaryota	850	0	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g2129	i0	80.762	32.8558394160584	1102	200	100	12	1	1096	15	1110	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	36010	850	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
16141360	16141360	PRJNA849822_P_NODE_28453_length_274_cov_1.124378_g28279_i0	PRJNA849822	28453	274	1.124378	3.08079572	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	394	3.63e-105	NTclustered	gi\|1191947222\|gb\|KY686294.1\|	10195	g28279	i0	92.674	0.996350364963504	273	20	99	0	1	273	508	780	Brachionus plicatilis clone 01657 cytochrome P450 mRNA, complete cds	blastn	273	394	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
17416815	17416815	PRJNA849822_P_NODE_25314_length_288_cov_4.404651_g25140_i0	PRJNA849822	25314	288	4.404651	12.68539488	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	464	2.8899999999999994e-126	NTclustered	gi\|1033208566\|gb\|KU361816.1\|	10195	g25140	i0	95.819	0.996527777777778	287	12	99	0	2	288	303	17	Brachionus plicatilis cystatin B mRNA, complete cds	blastn	287	464	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
18690044	18690044	PRJNA849822_P_NODE_4155_length_785_cov_1.751404_g3992_i0	PRJNA849822	4155	785	1.751404	13.7485214	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	1406	0	NTclustered	gi\|254587481\|dbj\|AB513493.1\|	10195	g3992	i0	98.981	74.1821656050955	785	8	100	0	1	785	537	1321	Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds	blastn	58233	1406	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
19965003	19965003	PRJNA849822_P_NODE_2076_length_1142_cov_66.998129_g1962_i0	PRJNA849822	2076	1142	66.998129	765.11863318	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	1397	0	NTclustered	gi\|170016231\|ref\|NC_010472.1\|	10195	g1962	i0	88.967	40.0980735551664	1142	111	99	14	8	1142	10955	9822	Brachionus plicatilis mitochondrion part I, complete genome	blastn	45792	1397	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
19965063	19965063	PRJNA849822_P_NODE_27956_length_276_cov_1.344828_g27782_i0	PRJNA849822	27956	276	1.344828	3.71172528	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	460	3.5599999999999997e-125	NTclustered	gi\|1216632118\|gb\|MF360887.1\|	10195	g27782	i0	96.751	2.96014492753623	277	8	100	1	1	276	558	834	Brachionus plicatilis clone BpHNF4 nuclear receptor gene, complete cds	blastn	817	460	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
19965082	19965082	PRJNA849822_P_NODE_30376_length_265_cov_1.625000_g30202_i0	PRJNA849822	30376	265	1.625	4.30625	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	446	9.51e-121	NTclustered	gi\|1033208568\|gb\|KU361817.1\|	10195	g30202	i0	96.981	1	265	8	100	0	1	265	308	572	Brachionus plicatilis cathepsin L mRNA, complete cds	blastn	265	446	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
21240557	21240557	PRJNA849822_P_NODE_13917_length_391_cov_2.330189_g13743_i0	PRJNA849822	13917	391	2.330189	9.11103899	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	595	1.3799999999999994e-165	NTclustered	gi\|308156989\|gb\|GQ890454.1\|	10195	g13743	i0	94.885	22.5933503836317	391	3	100	7	1	391	53	426	Brachionus plicatilis isolate DNA16 large subunit ribosomal RNA gene, partial sequence	blastn	8834	595	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
21240708	21240708	PRJNA849822_P_NODE_32877_length_255_cov_1.164835_g32703_i0	PRJNA849822	32877	255	1.164835	2.97032925	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	185	2.19e-42	NTclustered	gi\|259479155\|dbj\|AB491780.1\|	10195	g32703	i0	90.647	0.545098039215686	139	13	55	0	1	139	92	230	Brachionus plicatilis MT-EB1 mRNA for microtubule-associated protein EB1, partial cds	blastn	139	185	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
22515458	22515458	PRJNA849822_P_NODE_39038_length_247_cov_0.896552_g38864_i0	PRJNA849822	39038	247	0.896552	2.21448344	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	364	2.519999999999999e-96	NTclustered	gi\|567315825\|dbj\|AB775785.1\|	10195	g38864	i0	93.469	1.98380566801619	245	16	99	0	3	247	1920	1676	Brachionus plicatilis hsp70-2 mRNA for heat shock 70 kDa protein 2, complete cds	blastn	490	364	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
23790845	23790845	PRJNA849822_P_NODE_24919_length_291_cov_0.816514_g24745_i0	PRJNA849822	24919	291	0.816514	2.37605574	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	505	1.7199999999999995e-138	NTclustered	gi\|527316639\|dbj\|AB778814.1\|	10195	g24745	i0	97.938	2.81443298969072	291	6	100	0	1	291	317	27	Brachionus plicatilis gabarap mRNA for GABA receptor type A-associated protein, complete cds	blastn	819	505	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
23790948	23790948	PRJNA849822_P_NODE_38599_length_247_cov_0.896552_g38425_i0	PRJNA849822	38599	247	0.896552	2.21448344	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	457	4.05e-124	NTclustered	gi\|308229596\|gb\|HM024714.1\|	10195	g38425	i0	100	5.99595141700405	247	0	100	0	1	247	380	134	Brachionus plicatilis membrane-associated progesterone receptor gene, exons 1, 2 and partial cds	blastn	1481	457	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
25064704	25064704	PRJNA849822_P_NODE_17160_length_350_cov_1.602888_g16986_i0	PRJNA849822	17160	350	1.602888	5.610108	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	525	1.6199999999999995e-144	NTclustered	gi\|1405682241\|gb\|MH231852.1\|	10195	g16986	i0	93.714	1	350	22	100	0	1	350	2023	1674	Brachionus plicatilis autophagy-related protein 9 mRNA, complete cds	blastn	350	525	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
25064740	25064740	PRJNA849822_P_NODE_21700_length_311_cov_1.310924_g21526_i0	PRJNA849822	21700	311	1.310924	4.07697364	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	484	2.4199999999999994e-132	NTclustered	gi\|22506756\|gb\|AF486264.1\|	10195	g21526	i0	94.839	0.996784565916399	310	16	99	0	1	310	505	196	Brachionus plicatilis myosin heavy chain type II mRNA, partial cds	blastn	310	484	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);;