metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA891846" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA891846" 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
3417390	3417390	PRJNA891846_P_NODE_10123_length_469_cov_1.078283_g9906_i0	PRJNA891846	10123	469	1.078283	5.05714727	Philodina citrina	468664	Rotifera	other_Eukaryota	396	1.83e-105	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g9906	i0	82.6	31.8720682302772	477	55	99	25	2	466	2207	1747	Philodina citrina complete mitochondrial genome	blastn	14948	396	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
3418039	3418039	PRJNA891846_P_NODE_37623_length_250_cov_0.870056_g37403_i0	PRJNA891846	37623	250	0.870056	2.17514	Philodina roseola	96448	Rotifera	other_Eukaryota	318	2.02e-82	NTclustered	gi\|183178937\|gb\|EU432547.1\|	96448	g37403	i0	89.6	6.708	250	26	100	0	1	250	30752	31001	Philodina roseola TAR protein gene, partial cds; U1-like Zn-finger-containing protein (U1Zn_1), unknown (PruORF0001_1), unknown (PrPCG0001_1), methione sulfide reductase B (MSRB_1), Strabismus, serine-threonin kinase copy 1, plasma membrane calcium-dependent ATPase (CAse_1), myosin essential light chain (MELC_1), and 82 kDa heat shock protein (hsp82_1) genes, complete cds; FBoxLRR_1 gene, complete sequence; and TPRA_1 (TPRA_1) gene, complete cds	blastn	1677	318	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
9794620	9794620	PRJNA891846_P_NODE_13208_length_416_cov_1.743440_g12989_i0	PRJNA891846	13208	416	1.74344	7.2527104	Adineta vaga	104782	Rotifera	other_Eukaryota	416	1.23e-111	NTclustered	gi\|187233665\|gb\|EU643499.1\|	104782	g12989	i0	85.751	0.944711538461538	393	56	94	0	1	393	393	1	Adineta vaga ribosomal protein L26 mRNA, partial cds	blastn	393	416	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
16169353	16169353	PRJNA891846_P_NODE_10433_length_462_cov_2.632391_g10216_i0	PRJNA891846	10433	462	2.632391	12.16164642	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	516	1.32e-141	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g10216	i0	86.694	73.478354978355	481	45	100	4	1	462	988	508	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	33947	516	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
17445725	17445725	PRJNA891846_P_NODE_46734_length_241_cov_1.702381_g46514_i0	PRJNA891846	46734	241	1.702381	4.10273821	Philodina sp. CWB-2005	338313	Rotifera	other_Eukaryota	440	3.959999999999999e-119	NTclustered	gi\|71840240\|gb\|DQ078567.1\|	338313	g46514	i0	99.585	99.9336099585062	241	1	100	0	1	241	193	433	Philodina sp. CWB-2005 clone SwT1.2 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	24084	440	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. CWB-2005

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