metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA695140" 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
676124	676124	PRJNA695140_S_NODE_4721_length_241_cov_3.838235_g4540_i0	PRJNA695140	4721	241	3.838235	9.25014635	Lecane bulla	96446	Rotifera	other_Eukaryota	374	4.079999999999998e-99	NTclustered	gi\|83285189\|gb\|DQ297736.1\|	96446	g4540	i0	95.339	81.6431535269709	236	9	98	2	7	241	1	235	Lecane bulla 28S ribosomal RNA gene, partial sequence	blastn	19676	374	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane bulla
2456788	2456788	PRJNA695140_S_NODE_4482_length_247_cov_7.900000_g4301_i0	PRJNA695140	4482	247	7.9	19.513	Opisthokonta	33154	Rotifera	other_Eukaryota	383	6.97e-102	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g4301	i0	94.737	93.7611336032389	247	12	100	1	1	247	7009	7254	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	23159	383	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
2456825	2456825	PRJNA695140_S_NODE_9502_length_172_cov_2.666667_g9321_i0	PRJNA695140	9502	172	2.666667	4.58666724	Adinetidae	104780	Rotifera	other_Eukaryota	318	1.2899999999999999e-82	NTclustered	gi\|2537903787\|gb\|KM043252.2\|	104782	g9321	i0	100	97.4651162790698	172	0	100	0	1	172	918	747	Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence	blastn	16764	318	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
9604564	9604564	PRJNA695140_S_NODE_2728_length_316_cov_4.050179_g2547_i0	PRJNA695140	2728	316	4.050179	12.79856564	Brachionus sessilis	1552236	Rotifera	other_Eukaryota	305	2.06e-78	NTclustered	gi\|694191711\|gb\|KM051971.1\|	1552236	g2547	i0	85.113	83.3892405063291	309	34	96	11	1	303	76	378	Brachionus sessilis voucher BSD7SES 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	26351	305	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus sessilis
10110189	10110189	PRJNA695140_S_NODE_1448_length_444_cov_5.941032_g1269_i0	PRJNA695140	1448	444	5.941032	26.37818208	Adineta	104781	Rotifera	other_Eukaryota	800	0	NTclustered	gi\|1005055512\|gb\|KU860655.1\|	1813164	g1269	i0	99.321	48.740990990991	442	3	99	0	3	444	1448	1889	Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence	blastn	21641	800	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. A JFF-2016
10880105	10880105	PRJNA695140_S_NODE_1669_length_409_cov_4.629032_g1488_i0	PRJNA695140	1669	409	4.629032	18.93274088	Lecane elsa	360663	Rotifera	other_Eukaryota	475	1.9699999999999998e-129	NTclustered	gi\|83285190\|gb\|DQ297737.1\|	360663	g1488	i0	87.775	63.281173594132	409	46	99	4	1	405	924	516	Lecane elsa 28S ribosomal RNA gene, partial sequence	blastn	25882	475	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane elsa
10880174	10880174	PRJNA695140_S_NODE_8149_length_185_cov_2.608108_g7968_i0	PRJNA695140	8149	185	2.608108	4.8249998	Adineta vaga	104782	Rotifera	other_Eukaryota	270	4.01e-68	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g7968	i0	95.808	2.82702702702703	167	7	90	0	19	185	10398	10232	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	523	270	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13935491	13935491	PRJNA695140_S_NODE_1551_length_427_cov_5.797436_g1370_i0	PRJNA695140	1551	427	5.797436	24.75505172	Adineta	104781	Rotifera	other_Eukaryota	761	0	NTclustered	gi\|1005055542\|gb\|KU860685.1\|	1813166	g1370	i0	98.829	90.7259953161593	427	5	100	0	1	427	730	304	Adineta vaga complex sp. C JFF-2016 isolate H004a 28S ribosomal RNA gene, partial sequence	blastn	38740	761	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. C JFF-2016
24902425	24902425	PRJNA695140_S_NODE_4380_length_250_cov_3.342723_g4199_i0	PRJNA695140	4380	250	3.342723	8.3568075	Brachionus rubens	392764	Rotifera	other_Eukaryota	135	2.1900000000000003e-27	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g4199	i0	77.075	8.576	253	46	99	12	1	247	6706	6952	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	2144	135	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens

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