metadata: contig_metadata: 12 rows where bioproject = "PRJNA340009" and tax

12 rows where bioproject = "PRJNA340009" 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
9320439	9320439	PRJNA340009_P_NODE_61688_length_167_cov_1.618644_g61381_i0	PRJNA340009	61688	167	1.618644	2.70313548	Asplanchna sieboldii	84397	Rotifera	other_Eukaryota	222	1.01e-53	NTclustered	gi\|61200811\|gb\|AY829085.1\|	84397	g61381	i0	93.878	47.9101796407186	147	9	88	0	11	157	1908	2054	Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence	blastn	8001	222	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sieboldii
14421288	14421288	PRJNA340009_P_NODE_71832_length_163_cov_0.894737_g71525_i0	PRJNA340009	71832	163	0.894737	1.45842131	Adineta vaga	104782	Rotifera	other_Eukaryota	278	2.06e-70	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g71525	i0	99.346	79.8159509202454	153	1	94	0	1	153	6810	6962	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	13010	278	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
18243565	18243565	PRJNA340009_P_NODE_22275_length_258_cov_1.449761_g21968_i0	PRJNA340009	22275	258	1.449761	3.74038338	Keratella quadrata	204742	Rotifera	other_Eukaryota	388	1.58e-103	NTclustered	gi\|83285188\|gb\|DQ297735.1\|	204742	g21968	i0	94.779	5.81782945736434	249	13	97	0	10	258	476	724	Keratella quadrata 28S ribosomal RNA gene, partial sequence	blastn	1501	388	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Keratella	Keratella quadrata
26631592	26631592	PRJNA340009_P_NODE_63281_length_166_cov_9.880342_g62974_i0	PRJNA340009	63281	166	9.880342	16.40136772	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	48.1	1.23e-4	NR	CAF4104338.1	2762512	g62974	i0	67.7	0.560240963855422	31	10	56	0	26	118	179	209	CAF4104338.1 unnamed protein product, partial [Rotaria sp. Silwood2]	diamond	93	48.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
28401161	28401161	PRJNA340009_P_NODE_63666_length_166_cov_1.743590_g63359_i0	PRJNA340009	63666	166	1.74359	2.8943594	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	45.8	0.00108	NR	CAF1588730.1	1234261	g63359	i0	55.3	0.686746987951807	38	17	68.7	0	52	165	288	325	CAF1588730.1 unnamed protein product, partial [Didymodactylos carnosus]	diamond	114	45.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
28765593	28765593	PRJNA340009_P_NODE_42007_length_197_cov_1.939189_g41700_i0	PRJNA340009	42007	197	1.939189	3.82020233	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	54.7	1.2e-6	NR	CAF0788434.1	249248	g41700	i0	46	2.22335025380711	50	27	76.1	0	4	153	256	305	CAF0788434.1 unnamed protein product [Adineta ricciae]	diamond	438	55.1	0.992740471869329	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28923439	28923439	PRJNA340009_P_NODE_6308_length_435_cov_34.924870_g6001_i0	PRJNA340009	6308	435	34.92487	151.9231845	Adineta	104781	Rotifera	other_Eukaryota	62	4.94e-8	NR	UJR19848.1	104782	g6001	i0	56	1.39310344827586	50	22	34.5	0	433	284	375	424	UJR19848.1 hypothetical protein I4U23_022981 [Adineta vaga]	diamond	606	62	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
29695288	29695288	PRJNA340009_P_NODE_15630_length_300_cov_3.278884_g15323_i0	PRJNA340009	15630	300	3.278884	9.836652	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	57.4	5.11e-7	NR	RNA03218.1	10195	g15323	i0	54	2.04	50	23	50	0	1	150	197	246	RNA03218.1 high mobility group 20A [Brachionus plicatilis]	diamond	612	57.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
29790214	29790214	PRJNA340009_P_NODE_41071_length_199_cov_1.360000_g40764_i0	PRJNA340009	41071	199	1.36	2.7064	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	56.2	3.46e-7	NR	CAF1204815.1	1234261	g40764	i0	64.9	1.11557788944724	37	13	55.8	0	1	111	44	80	CAF1204815.1 unnamed protein product [Didymodactylos carnosus]	diamond	222	56.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
29853648	29853648	PRJNA340009_P_NODE_41591_length_198_cov_1.369128_g41284_i0	PRJNA340009	41591	198	1.369128	2.71087344	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	43.1	0.015	NR	CAF0774621.1	104777	g41284	i0	56.3	0.727272727272727	48	14	72.7	1	2	145	183	223	CAF0774621.1 unnamed protein product [Brachionus calyciflorus]	diamond	144	43.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
30485502	30485502	PRJNA340009_P_NODE_59893_length_169_cov_2.516667_g59586_i0	PRJNA340009	59893	169	2.516667	4.25316723	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	59.7	6.58e-9	NR	CAF2047384.1	392030	g59586	i0	62.3	4.70414201183432	53	18	94.1	1	8	166	104	154	CAF2047384.1 unnamed protein product [Rotaria magnacalcarata]	diamond	795	59.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
31022656	31022656	PRJNA340009_P_NODE_64395_length_166_cov_0.871795_g64088_i0	PRJNA340009	64395	166	0.871795	1.4471797	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	51.6	9.49e-6	NR	CAF3620483.1	2762511	g64088	i0	50	4.37349397590361	50	25	90.4	0	3	152	124	173	CAF3620483.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	726	51.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1

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