metadata: contig_metadata: 10 rows where bioproject = "PRJNA758088" and tax

10 rows where bioproject = "PRJNA758088" 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
18587151	18587151	PRJNA758088_P_NODE_185175_length_312_cov_1.288703_g178204_i0	PRJNA758088	185175	312	1.288703	4.02075336	Eurotatoria	2816136	Rotifera	other_Eukaryota	102	1.87e-24	NR	CAF1495866.1	249248	g178204	i0	62.2	16.3653846153846	74	28	71.2	0	312	91	9	82	CAF1495866.1 unnamed protein product [Adineta ricciae]	diamond	5106	102	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
26831495	26831495	PRJNA758088_P_NODE_167421_length_327_cov_1.362205_g160450_i0	PRJNA758088	167421	327	1.362205	4.45441035	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	115	8.87e-29	NR	CAF2068370.1	392030	g160450	i0	51.4	1.99082568807339	109	53	100	0	1	327	95	203	CAF2068370.1 unnamed protein product [Rotaria magnacalcarata]	diamond	651	115	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
27379087	27379087	PRJNA758088_P_NODE_349983_length_243_cov_0.905882_g343012_i0	PRJNA758088	349983	243	0.905882	2.20129326	Metazoa	33208	Rotifera	other_Eukaryota	64.3	9.27e-10	NR	CAF0774281.1	1234261	g343012	i0	40.3	7.35802469135802	72	43	88.9	0	241	26	539	610	CAF0774281.1 unnamed protein product [Didymodactylos carnosus]	diamond	1788	64.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
27779682	27779682	PRJNA758088_P_NODE_323924_length_246_cov_0.890173_g316953_i0	PRJNA758088	323924	246	0.890173	2.18982558	Adineta vaga	104782	Rotifera	other_Eukaryota	69.7	1.23e-11	NR	UJR17604.1	104782	g316953	i0	47.1	5.18292682926829	70	35	85.4	1	244	35	1662	1729	UJR17604.1 hypothetical protein I4U23_004500 [Adineta vaga]	diamond	1275	69.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29295075	29295075	PRJNA758088_P_NODE_259809_length_263_cov_1.100000_g252838_i0	PRJNA758088	259809	263	1.1	2.893	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	100	2.84e-23	NR	CAF1143966.1	104777	g252838	i0	56.6	19.0266159695817	83	34	92.4	1	21	263	62	144	CAF1143966.1 unnamed protein product [Brachionus calyciflorus]	diamond	5004	100	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
30653118	30653118	PRJNA758088_P_NODE_211133_length_293_cov_1.318182_g204162_i0	PRJNA758088	211133	293	1.318182	3.86227326	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	54.3	5.54e-6	NR	CAF1455392.1	2762511	g204162	i0	30.2	4.13651877133106	86	48	75.8	1	70	291	176	261	CAF1455392.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	1212	54.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
31443397	31443397	PRJNA758088_P_NODE_204396_length_298_cov_0.991111_g197425_i0	PRJNA758088	204396	298	0.991111	2.95351078	Adineta steineri	433720	Rotifera	other_Eukaryota	67.4	5.97e-11	NR	CAF1146830.1	433720	g197425	i0	76.9	4.5503355704698	39	9	39.3	0	2	118	94	132	CAF1146830.1 unnamed protein product [Adineta steineri]	diamond	1356	67.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
31664737	31664737	PRJNA758088_P_NODE_68377_length_520_cov_1.221477_g61427_i0	PRJNA758088	68377	520	1.221477	6.3516804	Adineta ricciae	249248	Rotifera	other_Eukaryota	65.9	1.64e-9	NR	CAF1065956.1	249248	g61427	i0	31.9	0.813461538461538	141	76	69.8	3	420	58	83	223	CAF1065956.1 unnamed protein product [Adineta ricciae]	diamond	423	65.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32613784	32613784	PRJNA758088_P_NODE_305260_length_248_cov_0.880000_g298289_i0	PRJNA758088	305260	248	0.88	2.1824	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	72.8	3.26e-14	NR	RNA20753.1	10195	g298289	i0	40.6	0.834677419354839	69	41	83.5	0	27	233	50	118	RNA20753.1 kDa in NOF-FB transposable element, partial [Brachionus plicatilis]	diamond	207	72.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
32906797	32906797	PRJNA758088_P_NODE_276860_length_253_cov_1.027778_g269889_i0	PRJNA758088	276860	253	1.027778	2.60027834	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.1	0.0311	NR	CAF1035577.1	104777	g269889	i0	40	1.43478260869565	50	29	59.3	1	156	7	223	271	CAF1035577.1 unnamed protein product [Brachionus calyciflorus]	diamond	363	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus

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