metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1086823" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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
10397207	10397207	PRJNA1086823_P_NODE_4929_length_358_cov_1.385965_g4812_i0	PRJNA1086823	4929	358	1.385965	4.9617547	Philodina citrina	468664	Rotifera	other_Eukaryota	267	1.11e-66	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g4812	i0	80.87	10.1927374301676	345	61	96	5	14	355	3981	4323	Philodina citrina complete mitochondrial genome	blastn	3649	267	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
12947631	12947631	PRJNA1086823_P_NODE_6011_length_330_cov_1.517510_g5894_i0	PRJNA1086823	6011	330	1.51751	5.007783	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	363	1.26e-95	NTclustered	gi\|402761793\|gb\|JX184028.1\|	104788	g5894	i0	86.667	6.18787878787879	330	40	99	4	1	328	292	619	Macrotrachela quadricornifera isolate CR cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	2042	363	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
15496291	15496291	PRJNA1086823_P_NODE_11513_length_257_cov_2.016304_g11396_i0	PRJNA1086823	11513	257	2.016304	5.18190128	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	324	4.49e-84	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g11396	i0	89.453	86.295719844358	256	27	99	0	2	257	569	314	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	22178	324	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
19319395	19319395	PRJNA1086823_P_NODE_1236_length_680_cov_16.892916_g1123_i0	PRJNA1086823	1236	680	16.892916	114.8718288	Philodina citrina	468664	Rotifera	other_Eukaryota	710	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1123	i0	85.839	20.1720588235294	685	78	99	16	1	679	1669	2340	Philodina citrina complete mitochondrial genome	blastn	13717	710	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
20594861	20594861	PRJNA1086823_P_NODE_1857_length_546_cov_2.042283_g1741_i0	PRJNA1086823	1857	546	2.042283	11.15086518	Adineta oculata	338306	Rotifera	other_Eukaryota	887	0	NTclustered	gi\|71840136\|gb\|DQ078515.1\|	338306	g1741	i0	99.588	94.7124542124542	486	2	89	0	1	486	486	1	Adineta oculata clone War1.1 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	51713	887	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta oculata
20594930	20594930	PRJNA1086823_P_NODE_4377_length_375_cov_2.364238_g4260_i0	PRJNA1086823	4377	375	2.364238	8.8658925	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	320	8.86e-83	NTclustered	gi\|402761809\|gb\|JX184036.1\|	104788	g4260	i0	85.577	18.4266666666667	312	38	82	7	4	312	388	695	Macrotrachela quadricornifera isolate CR NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	6910	320	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
21870610	21870610	PRJNA1086823_P_NODE_1838_length_549_cov_3.142857_g1722_i0	PRJNA1086823	1838	549	3.142857	17.25428493	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	575	2.5899999999999995e-159	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g1722	i0	85.74	1.56284153005464	547	74	99	4	5	549	563	19	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	858	575	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
24419780	24419780	PRJNA1086823_P_NODE_8180_length_291_cov_0.912844_g8063_i0	PRJNA1086823	8180	291	0.912844	2.65637604	Adineta vaga	104782	Rotifera	other_Eukaryota	377	3.92e-100	NTclustered	gi\|189313895\|gb\|EU637017.1\|	104782	g8063	i0	90.034	52.4089347079038	291	29	100	0	1	291	34758	34468	Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds	blastn	15251	377	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga

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