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

18 rows where analysis = "blastn", bioproject = "PRJNA577580" 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
564054	564054	PRJNA577580_P_NODE_12521_length_262_cov_1.650794_g12443_i0	PRJNA577580	12521	262	1.650794	4.32508028	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	254	6.11e-63	NTclustered	gi\|2006240390\|gb\|MW559989.1\|	667381	g12443	i0	84.291	42.9160305343511	261	39	99	2	1	260	1178	1437	Brachionus manjavacas isolate DE chromosome II mitochondrion, complete sequence	blastn	11244	254	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
564142	564142	PRJNA577580_P_NODE_8041_length_318_cov_4.710204_g7963_i0	PRJNA577580	8041	318	4.710204	14.97844872	Brachionus rubens	392764	Rotifera	other_Eukaryota	270	7.56e-68	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g7963	i0	84.871	3.02830188679245	271	37	85	4	50	318	9560	9828	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	963	270	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
564153	564153	PRJNA577580_P_NODE_9281_length_299_cov_1.380531_g9203_i0	PRJNA577580	9281	299	1.380531	4.12778769	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	459	1.4000000000000002e-124	NTclustered	gi\|254587481\|dbj\|AB513493.1\|	10195	g9203	i0	94.314	98.505016722408	299	17	100	0	1	299	389	687	Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds	blastn	29453	459	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
3114943	3114943	PRJNA577580_P_NODE_2383_length_585_cov_4.410156_g2305_i0	PRJNA577580	2383	585	4.410156	25.7994126	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	525	2.829999999999999e-144	NTclustered	gi\|2006240385\|gb\|MW559988.1\|	667381	g2305	i0	83.979	61.3538461538462	568	70	96	15	23	582	10505	9951	Brachionus manjavacas isolate DE chromosome I mitochondrion, complete sequence	blastn	35892	525	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
6942244	6942244	PRJNA577580_P_NODE_5406_length_384_cov_3.131833_g5328_i0	PRJNA577580	5406	384	3.131833	12.02623872	Plationus patulus	360686	Rotifera	other_Eukaryota	396	1.47e-105	NTclustered	gi\|401880453\|gb\|JX216794.1\|	904060	g5328	i0	86.427	96.1744791666667	361	49	94	0	7	367	654	294	Plationus patulus macracanthus voucher ECOCHZ-AG0712 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial	blastn	36931	396	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Plationus	Plationus patulus
8217178	8217178	PRJNA577580_P_NODE_12447_length_263_cov_1.231579_g12369_i0	PRJNA577580	12447	263	1.231579	3.23905277	Brachionus koreanus	1199090	Rotifera	other_Eukaryota	475	1.2e-129	NTclustered	gi\|1216632192\|gb\|MF360924.1\|	1199090	g12369	i0	99.24	1.98098859315589	263	2	100	0	1	263	1044	1306	Brachionus koreanus clone BkHR78 nuclear receptor gene, complete cds	blastn	521	475	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus koreanus
9492459	9492459	PRJNA577580_P_NODE_3308_length_495_cov_2.390995_g3230_i0	PRJNA577580	3308	495	2.390995	11.83542525	Brachionus rubens	392764	Rotifera	other_Eukaryota	350	1.53e-91	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g3230	i0	80.942	26.4323232323232	467	68	93	18	18	475	5783	6237	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	13084	350	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
10768265	10768265	PRJNA577580_P_NODE_11869_length_268_cov_1.964103_g11791_i0	PRJNA577580	11869	268	1.964103	5.26379604	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	121	6.63e-23	NTclustered	gi\|2047395652\|gb\|MZ326638.1\|	104777	g11791	i0	96.053	28.5746268656716	76	0	28	3	1	76	430	358	Brachionus calyciflorus isolate BcSII-b 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	7658	121	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
10768317	10768317	PRJNA577580_P_NODE_2669_length_553_cov_3.702083_g2591_i0	PRJNA577580	2669	553	3.702083	20.47251899	Adineta vaga complex sp. B JFF-2016	1813165	Rotifera	other_Eukaryota	963	0	NTclustered	gi\|1005055631\|gb\|KU860774.1\|	1813165	g2591	i0	98.022	44.7920433996383	556	8	100	3	1	553	1507	2062	Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence	blastn	24770	963	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. B JFF-2016
13317985	13317985	PRJNA577580_P_NODE_1311_length_789_cov_2.624302_g1242_i0	PRJNA577580	1311	789	2.624302	20.70574278	Brachionus sp. Tiscar	183144	Rotifera	other_Eukaryota	798	0	NTclustered	gi\|307640080\|gb\|GQ894765.1\|	183144	g1242	i0	87.554	46.1685678073511	691	84	87	2	48	737	690	1	Brachionus sp. Tiscar isolate Sm28 cytochrome oxidase c subunit III (cox3) gene, partial cds; mitochondrial	blastn	36427	798	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus sp. Tiscar
15866657	15866657	PRJNA577580_P_NODE_11573_length_271_cov_1.949495_g11495_i0	PRJNA577580	11573	271	1.949495	5.28313145	Brachionus rotundiformis	96890	Rotifera	other_Eukaryota	219	2.32e-52	NTclustered	gi\|1066800230\|gb\|KX364937.1\|	96890	g11495	i0	81.25	1.2029520295203	272	49	100	2	1	271	5873	6143	Brachionus rotundiformis chromosome II mitochondrion, complete sequence	blastn	326	219	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
18415892	18415892	PRJNA577580_P_NODE_11615_length_271_cov_1.257576_g11537_i0	PRJNA577580	11615	271	1.257576	3.40803096	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	189	1.8199999999999998e-43	NTclustered	gi\|2105975276\|gb\|MZ706949.1\|	104777	g11537	i0	80.567	0.911439114391144	247	46	91	2	18	263	250	5	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	247	189	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
18415985	18415985	PRJNA577580_P_NODE_7635_length_326_cov_3.367589_g7557_i0	PRJNA577580	7635	326	3.367589	10.97834014	Brachionus angularis	396692	Rotifera	other_Eukaryota	167	1.05e-36	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g7557	i0	79.184	0.751533742331288	245	47	75	4	43	285	4584	4826	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	245	167	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
19690533	19690533	PRJNA577580_P_NODE_9096_length_301_cov_7.109649_g9018_i0	PRJNA577580	9096	301	7.109649	21.40004349	Brachionus patulus	160652	Rotifera	other_Eukaryota	431	3.08e-116	NTclustered	gi\|61200806\|gb\|AY829084.1\|	160652	g9018	i0	94.326	90.2790697674419	282	15	93	1	1	281	1716	1435	Brachionus patulus 28S ribosomal RNA gene, partial sequence	blastn	27174	431	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus patulus
21540077	21540077	PRJNA577580_P_NODE_7377_length_331_cov_2.678295_g7299_i0	PRJNA577580	7377	331	2.678295	8.86515645	Ploima	84394	Rotifera	other_Eukaryota	601	2.4699999999999994e-167	NTclustered	gi\|2177087\|gb\|U49911.1\|BPU49911	10195	g7299	i0	99.396	100	331	2	100	0	1	331	627	957	Brachionus plicatilis 18S rRNA gene, complete sequence	blastn	33100	601	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
22241090	22241090	PRJNA577580_P_NODE_10038_length_289_cov_1.444444_g9960_i0	PRJNA577580	10038	289	1.444444	4.17444316	Lecane inermis	1471631	Rotifera	other_Eukaryota	331	3.07e-86	NTclustered	gi\|1957982515\|gb\|MW487867.1\|	1471631	g9960	i0	88.645	96.3944636678201	273	29	94	1	1	273	390	660	Lecane inermis voucher NNIBRIV50291 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	27858	331	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane inermis
22241124	22241124	PRJNA577580_P_NODE_15158_length_246_cov_2.658960_g15080_i0	PRJNA577580	15158	246	2.65896	6.5410416	Lecane bulla	96446	Rotifera	other_Eukaryota	392	1.15e-104	NTclustered	gi\|83285189\|gb\|DQ297736.1\|	96446	g15080	i0	97.391	63.7520325203252	230	6	93	0	17	246	1	230	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	15683	392	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
22241133	22241133	PRJNA577580_P_NODE_1698_length_697_cov_14.756410_g1624_i0	PRJNA577580	1698	697	14.75641	102.8521777	Brachionus koreanus	1199090	Rotifera	other_Eukaryota	900	0	NTclustered	gi\|477541870\|gb\|KC603851.1\|	1199090	g1624	i0	90.115	57.7144906743185	698	62	99	6	1	695	9508	10201	Brachionus sp. 'koreanus' chromosome I mitochondrion, complete sequence	blastn	40227	900	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus koreanus

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