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

9 rows where analysis = "blastn", bioproject = "PRJNA667863" 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
634103	634103	PRJNA667863_P_NODE_18481_length_227_cov_5.993506_g18447_i0	PRJNA667863	18481	227	5.993506	13.60525862	Adineta vaga	104782	Rotifera	other_Eukaryota	285	1.83e-72	NTclustered	gi\|402761787\|gb\|JX184025.1\|	104782	g18447	i0	90	0.969162995594714	220	22	97	0	5	224	35	254	Adineta vaga cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	220	285	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
634224	634224	PRJNA667863_P_NODE_9661_length_259_cov_5.768817_g9627_i0	PRJNA667863	9661	259	5.768817	14.94123603	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	307	4.5600000000000005e-79	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g9627	i0	89.669	3.93050193050193	242	24	93	1	9	250	2423	2183	Rotaria rotatoria mitochondrion, complete genome	blastn	1018	307	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
3184822	3184822	PRJNA667863_P_NODE_1303_length_454_cov_2.769029_g1269_i0	PRJNA667863	1303	454	2.769029	12.57139166	Adineta vaga	104782	Rotifera	other_Eukaryota	518	3.61e-142	NTclustered	gi\|2516177894\|gb\|OR121225.1\|	104782	g1269	i0	88.249	93.8898678414097	434	49	95	2	22	454	1	433	Adineta vaga voucher P1SY10 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	42626	518	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
7012549	7012549	PRJNA667863_P_NODE_18906_length_218_cov_4.151724_g18872_i0	PRJNA667863	18906	218	4.151724	9.05075832	Adineta vaga	104782	Rotifera	other_Eukaryota	311	2.8800000000000003e-80	NTclustered	gi\|134141776\|gb\|EF173252.1\|	104782	g18872	i0	92.627	95.4449541284404	217	15	99	1	1	217	411	626	Adineta vaga isolate TZ.1.2 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	20807	311	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
8287264	8287264	PRJNA667863_P_NODE_2187_length_384_cov_14.109325_g2153_i0	PRJNA667863	2187	384	14.109325	54.179808	Adineta vaga	104782	Rotifera	other_Eukaryota	272	2.58e-68	NTclustered	gi\|402761723\|gb\|JX183993.1\|	104782	g2153	i0	82.445	1.48697916666667	319	48	82	7	7	321	345	31	Adineta vaga ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial	blastn	571	272	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
10838138	10838138	PRJNA667863_P_NODE_19009_length_214_cov_6.553191_g18975_i0	PRJNA667863	19009	214	6.553191	14.02382874	Proales similis	360698	Rotifera	other_Eukaryota	193	1.0600000000000001e-44	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g18975	i0	84.694	7.23364485981308	196	27	91	3	1	194	12326	12520	Proales similis mitochondrion, complete genome	blastn	1548	193	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
15936880	15936880	PRJNA667863_P_NODE_1833_length_405_cov_4.436747_g1799_i0	PRJNA667863	1833	405	4.436747	17.96882535	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	460	5.45e-125	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g1799	i0	87.817	2.33086419753086	394	46	97	2	1	393	162	554	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	944	460	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
18486464	18486464	PRJNA667863_P_NODE_795_length_552_cov_2.883090_g763_i0	PRJNA667863	795	552	2.88309	15.9146568	Philodina citrina	468664	Rotifera	other_Eukaryota	479	2.0999999999999992e-130	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g763	i0	82.616	38.4057971014493	558	81	100	13	1	552	2207	1660	Philodina citrina complete mitochondrial genome	blastn	21200	479	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
22311372	22311372	PRJNA667863_P_NODE_5458_length_294_cov_5.031674_g5424_i0	PRJNA667863	5458	294	5.031674	14.79312156	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	361	3.9899999999999996e-95	NTclustered	gi\|402761731\|gb\|JX183997.1\|	104788	g5424	i0	88.776	72.7517006802721	294	33	100	0	1	294	744	1037	Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	21389	361	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera

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