metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1012699" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1012699" 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
157990	157990	PRJNA1012699_P_NODE_1481_length_311_cov_1.121849_g1449_i0	PRJNA1012699	1481	311	1.121849	3.48895039	Adineta vaga	104782	Rotifera	other_Eukaryota	556	5.05e-154	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g1449	i0	99.032	4.53376205787781	310	3	99	0	1	310	10371	10062	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	1410	556	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
3984564	3984564	PRJNA1012699_P_NODE_324_length_593_cov_3.240385_g294_i0	PRJNA1012699	324	593	3.240385	19.21548305	Philodina citrina	468664	Rotifera	other_Eukaryota	797	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g294	i0	91.062	32.1399662731872	593	48	99	4	3	593	2260	1671	Philodina citrina complete mitochondrial genome	blastn	19059	797	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
6536202	6536202	PRJNA1012699_P_NODE_1966_length_281_cov_1.740385_g1934_i0	PRJNA1012699	1966	281	1.740385	4.89048185	Philodina roseola	96448	Rotifera	other_Eukaryota	507	4.599999999999999e-139	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g1934	i0	99.286	55.8113879003559	280	2	99	0	1	280	1525	1804	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	15683	507	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
7380067	7380067	PRJNA1012699_P_NODE_1246_length_334_cov_1.762452_g1214_i0	PRJNA1012699	1246	334	1.762452	5.88658968	Philodina	44581	Rotifera	other_Eukaryota	584	2.509999999999999e-162	NTclustered	gi\|296011587\|gb\|HM032972.1\|	96448	g1214	i0	98.78	97.0568862275449	328	4	98	0	1	328	489	162	Philodina roseola isolate WPr1.1a cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	32417	584	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
15460665	15460665	PRJNA1012699_P_NODE_2333_length_264_cov_2.434555_g2301_i0	PRJNA1012699	2333	264	2.434555	6.4272252	Philodina roseola	96448	Rotifera	other_Eukaryota	479	9.33e-131	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g2301	i0	99.618	26.094696969697	262	1	99	0	2	263	1862	2123	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	6889	479	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
16734973	16734973	PRJNA1012699_P_NODE_2574_length_255_cov_1.269231_g2542_i0	PRJNA1012699	2574	255	1.269231	3.23653905	Philodina roseola	96448	Rotifera	other_Eukaryota	472	1.5e-128	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g2542	i0	100	8.4078431372549	255	0	100	0	1	255	40183	40437	Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds	blastn	2144	472	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola

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