metadata: contig_metadata: 9 rows where bioproject = "PRJNA833575", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA833575", tax_kingdom = "Metazoa" 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
21226119	21226119	PRJNA833575_P_NODE_1377_length_1104_cov_10.665700_g1309_i0	PRJNA833575	1377	1104	10.6657	117.749328	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	425	5.75e-114	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g1309	i0	75.676	14.8650362318841	999	163	87	70	31	990	2372	1415	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	16411	425	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
22501179	22501179	PRJNA833575_P_NODE_33738_length_254_cov_4.643243_g33601_i0	PRJNA833575	33738	254	4.643243	11.79383722	Rotaria socialis	392032	Rotifera	other_Eukaryota	124	3.8199999999999997e-31	NR	CAF4100172.1	392032	g33601	i0	76.2	4.96062992125984	84	20	99.2	0	253	2	389	472	CAF4100172.1 unnamed protein product [Rotaria socialis]	diamond	1260	124	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
26833173	26833173	PRJNA833575_P_NODE_30501_length_269_cov_1.420000_g30364_i0	PRJNA833575	30501	269	1.42	3.8198	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	82.8	2.48e-17	NR	CAF3688229.1	2762511	g30364	i0	51.8	3.85873605947955	85	38	93.7	2	2	253	89	171	CAF3688229.1 unnamed protein product, partial [Rotaria sp. Silwood1]	diamond	1038	82.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
27086301	27086301	PRJNA833575_P_NODE_47062_length_215_cov_2.465753_g46925_i0	PRJNA833575	47062	215	2.465753	5.30136895	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	72.8	5.91e-13	NR	CAF2172787.1	392030	g46925	i0	52.2	2.94418604651163	69	30	94.9	2	4	207	251	317	CAF2172787.1 unnamed protein product [Rotaria magnacalcarata]	diamond	633	72.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
28294817	28294817	PRJNA833575_P_NODE_38606_length_235_cov_0.867470_g38469_i0	PRJNA833575	38606	235	0.86747	2.0385545	Metazoa	33208	Rotifera	other_Eukaryota	83.6	7.28e-17	NR	UJR29697.1	104782	g38469	i0	57.4	3.39574468085106	61	26	77.9	0	43	225	201	261	UJR29697.1 hypothetical protein I4U23_017245 [Adineta vaga]	diamond	798	84.3	0.991696322657177	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29715404	29715404	PRJNA833575_P_NODE_34570_length_251_cov_1.225275_g34433_i0	PRJNA833575	34570	251	1.225275	3.07544025	Rotaria	231623	Rotifera	other_Eukaryota	90.5	5.05e-19	NR	CAF1245201.1	2762511	g34433	i0	55.6	10.4701195219124	72	32	86.1	0	35	250	6	77	CAF1245201.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	2628	90.9	0.995599559955996	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
30939463	30939463	PRJNA833575_P_NODE_45874_length_227_cov_0.911392_g45737_i0	PRJNA833575	45874	227	0.911392	2.06885984	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	109	1.6500000000000002e-26	NR	CAF2902350.1	2762512	g45737	i0	68	9.83259911894273	75	24	99.1	0	227	3	79	153	CAF2902350.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	2232	109	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
31390491	31390491	PRJNA833575_P_NODE_39896_length_233_cov_1.341463_g39759_i0	PRJNA833575	39896	233	1.341463	3.12560879	Rotifera	10190	Rotifera	other_Eukaryota	67.4	6.73e-11	NR	KAI3388800.1	104778	g39759	i0	45.6	3.65665236051502	68	37	87.6	0	212	9	750	817	KAI3388800.1 hypothetical protein SNEBB_010787 [Seison nebaliae]	diamond	852	67.8	0.994100294985251	Eukaryota	Opisthokonta	Metazoa	Rotifera	Pararotatoria	Seisonacea	Seisonidae	Seison	Seison nebaliae
31517056	31517056	PRJNA833575_P_NODE_40036_length_233_cov_0.878049_g39899_i0	PRJNA833575	40036	233	0.878049	2.04585417	Philodinidae	44580	Rotifera	other_Eukaryota	67.4	5.43e-12	NR	CAF1286991.1	1234261	g39899	i0	47.7	4.931330472103	65	34	83.7	0	195	1	38	102	CAF1286991.1 unnamed protein product [Didymodactylos carnosus]	diamond	1149	67.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus

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