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

19 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
287234	287234	PRJNA1144090_P_NODE_37161_length_425_cov_2.477273_g36626_i0	PRJNA1144090	37161	425	2.477273	10.52841025	Brachionus fernandoi	2498032	Rotifera	other_Eukaryota	207	8.26e-49	NTclustered	gi\|2105975303\|gb\|MZ768799.1\|	2498032	g36626	i0	76.296	59.0682352941176	405	86	94	9	26	425	1521	1122	Brachionus fernandoi cytochrome c oxidase subunit I (COX1) gene, complete cds; mitochondrial	blastn	25104	207	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus fernandoi
2837934	2837934	PRJNA1144090_P_NODE_27243_length_508_cov_1.862069_g26710_i0	PRJNA1144090	27243	508	1.862069	9.45931052	Lecane bulla	96446	Rotifera	other_Eukaryota	665	0	NTclustered	gi\|167842618\|gb\|EU188935.1\|	96446	g26710	i0	95.047	88.3425196850394	424	20	83	1	85	508	720	298	Lecane bulla isolate Rio Grande Village cytochrome oxidase subunit I-like (cox1) gene, partial sequence; mitochondrial	blastn	44878	665	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
3583511	3583511	PRJNA1144090_P_NODE_65123_length_314_cov_1.307054_g64588_i0	PRJNA1144090	65123	314	1.307054	4.10414956	Adineta	104781	Rotifera	other_Eukaryota	569	6.559999999999998e-158	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g64588	i0	99.363	52.2738853503185	314	2	100	0	1	314	1867	2180	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	16414	569	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
3583543	3583543	PRJNA1144090_P_NODE_82223_length_278_cov_0.848780_g81688_i0	PRJNA1144090	82223	278	0.84878	2.3596084	Eurotatoria	2816136	Rotifera	other_Eukaryota	399	7.929999999999999e-107	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g81688	i0	98.253	42.0971223021583	229	3	82	1	49	276	1714	1486	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	11703	401	0.99501246882793	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
5390075	5390075	PRJNA1144090_P_NODE_110065_length_244_cov_2.631579_g109530_i0	PRJNA1144090	110065	244	2.631579	6.42105276	Adineta ricciae	249248	Rotifera	other_Eukaryota	418	1.8799999999999994e-112	NTclustered	gi\|62362189\|gb\|AY942834.1\|	249248	g109530	i0	97.551	1.00409836065574	245	5	100	1	1	244	257	13	Adineta ricciae amphiHMG1/2-like protein mRNA, partial cds	blastn	245	418	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
5390987	5390987	PRJNA1144090_P_NODE_86705_length_270_cov_1.563452_g86170_i0	PRJNA1144090	86705	270	1.563452	4.2213204	Asplanchna brightwellii	2005548	Rotifera	other_Eukaryota	122	1.86e-23	NTclustered	gi\|2899343712\|gb\|PQ788833.1\|	2005548	g86170	i0	78.571	24.337037037037	196	35	72	6	75	269	5996	6185	Asplanchna brightwellii chromosome I mitochondrion, complete sequence	blastn	6571	122	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna brightwellii
6665030	6665030	PRJNA1144090_P_NODE_26486_length_516_cov_3.203160_g25953_i0	PRJNA1144090	26486	516	3.20316	16.5283056	Brachionus rubens	392764	Rotifera	other_Eukaryota	462	1.97e-125	NTclustered	gi\|1802791203\|gb\|MN256532.1\|	392764	g25953	i0	83.466	70.1414728682171	502	77	97	6	17	515	575	1073	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	36193	462	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
9215110	9215110	PRJNA1144090_P_NODE_20608_length_597_cov_6.469466_g20083_i0	PRJNA1144090	20608	597	6.469466	38.62271202	Proales similis	360698	Rotifera	other_Eukaryota	562	2.21e-155	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g20083	i0	84.859	63.2696817420436	568	74	94	10	1	561	12515	11953	Proales similis mitochondrion, complete genome	blastn	37772	562	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
9215413	9215413	PRJNA1144090_P_NODE_46228_length_376_cov_2.504950_g45693_i0	PRJNA1144090	46228	376	2.50495	9.418612	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	374	6.729999999999998e-99	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g45693	i0	88.673	4.18882978723404	309	31	82	4	2	308	2117	2423	Rotaria rotatoria mitochondrion, complete genome	blastn	1575	374	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
10490720	10490720	PRJNA1144090_P_NODE_22629_length_566_cov_4.494929_g22102_i0	PRJNA1144090	22629	566	4.494929	25.44129814	Brachionus rubens	392764	Rotifera	other_Eukaryota	464	6.05e-126	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g22102	i0	82.482	49.3727915194346	548	78	95	14	3	541	11253	11791	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	27945	464	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
11766491	11766491	PRJNA1144090_P_NODE_90930_length_263_cov_1.621053_g90395_i0	PRJNA1144090	90930	263	1.621053	4.26336939	Philodina roseola	96448	Rotifera	other_Eukaryota	399	7.439999999999999e-107	NTclustered	gi\|183178937\|gb\|EU432547.1\|	96448	g90395	i0	94.253	43.3231939163498	261	15	99	0	3	263	29729	29989	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	11394	399	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
16335416	16335416	PRJNA1144090_P_NODE_23733_length_551_cov_2.096234_g23203_i0	PRJNA1144090	23733	551	2.096234	11.55024934	Lecane	96445	Rotifera	other_Eukaryota	436	1.28e-117	NTclustered	gi\|2713411621\|gb\|PP594094.1\|	96446	g23203	i0	81.977	89.8656987295826	516	91	93	2	22	536	1	515	Lecane bulla isolate L.bullaPC030 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	49516	436	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
16864823	16864823	PRJNA1144090_P_NODE_7754_length_1021_cov_31.285865_g7390_i0	PRJNA1144090	7754	1021	31.285865	319.42868165	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	433	3.17e-116	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g7390	i0	75.556	16.1498530852106	1035	170	97	72	18	1012	2406	1415	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	16489	433	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
16864857	16864857	PRJNA1144090_P_NODE_80594_length_280_cov_4.396135_g80059_i0	PRJNA1144090	80594	280	4.396135	12.309178	Philodina citrina	468664	Rotifera	other_Eukaryota	339	1.77e-88	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g80059	i0	91.498	63.4892857142857	247	20	88	1	1	247	2126	1881	Philodina citrina complete mitochondrial genome	blastn	17777	339	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
19412964	19412964	PRJNA1144090_P_NODE_118236_length_235_cov_3.271605_g117701_i0	PRJNA1144090	118236	235	3.271605	7.68827175	Brachionus angularis	396692	Rotifera	other_Eukaryota	272	1.4899999999999996e-68	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g117701	i0	87.66	75.6340425531915	235	27	99	2	1	234	1000	767	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	17774	272	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
24513343	24513343	PRJNA1144090_P_NODE_56000_length_339_cov_3.304511_g55465_i0	PRJNA1144090	56000	339	3.304511	11.20229229	Brachionus rotundiformis	96890	Rotifera	other_Eukaryota	172	2.36e-38	NTclustered	gi\|1066800225\|gb\|KX364936.1\|	96890	g55465	i0	79.545	34.0058997050147	264	37	76	13	82	339	9473	9725	Brachionus rotundiformis chromosome I mitochondrion, complete sequence	blastn	11528	172	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
24513692	24513692	PRJNA1144090_P_NODE_87940_length_268_cov_1.579487_g87405_i0	PRJNA1144090	87940	268	1.579487	4.23302516	Proales similis	360698	Rotifera	other_Eukaryota	159	1.41e-34	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g87405	i0	81.373	2.51492537313433	204	30	75	5	3	202	5835	6034	Proales similis mitochondrion, complete genome	blastn	674	159	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
24513723	24513723	PRJNA1144090_P_NODE_90540_length_264_cov_1.094241_g90005_i0	PRJNA1144090	90540	264	1.094241	2.88879624	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	244	3.71e-60	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g90005	i0	90.155	1.50378787878788	193	11	71	7	76	262	9659	9469	Rotaria rotatoria mitochondrion, complete genome	blastn	397	244	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
25259283	25259283	PRJNA1144090_P_NODE_104140_length_248_cov_0.880000_g103605_i0	PRJNA1144090	104140	248	0.88	2.1824	Adineta	104781	Rotifera	other_Eukaryota	257	4.43e-64	NTclustered	gi\|71840136\|gb\|DQ078515.1\|	338306	g103605	i0	91.053	72.9717741935484	190	17	77	0	3	192	252	441	Adineta oculata clone War1.1 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	18097	257	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta oculata

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