metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA690234" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA690234" 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
3221162	3221162	PRJNA690234_P_NODE_28703_length_247_cov_0.896552_g28336_i0	PRJNA690234	28703	247	0.896552	2.21448344	Philodina roseola	96448	Rotifera	other_Eukaryota	165	2.75e-36	NTclustered	gi\|194500491\|gb\|EU850441.1\|	96448	g28336	i0	87.857	3.9919028340081	140	17	57	0	40	179	13654	13793	Philodina roseola dihydrogenpyrimidine dehydrogenase gene, partial cds; translation initiation factor eIF-4E, rho GTPase activating protein, 7 transmembrane protein 66, histone H4, histone H3, histone H2B, osteopetrosis associated transmembrane protein, cleft lip and palate associated transmembrane, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, filament protein, hypothetical protein 21, and putative GPCR genes, complete cds; and hypothetical protein 22 gene, partial cds	blastn	986	165	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
3221271	3221271	PRJNA690234_P_NODE_4463_length_620_cov_2.389397_g4104_i0	PRJNA690234	4463	620	2.389397	14.8142614	Adineta ricciae	249248	Rotifera	other_Eukaryota	556	1.0699999999999997e-153	NTclustered	gi\|62362195\|gb\|AY942837.1\|	249248	g4104	i0	83.117	0.993548387096774	616	98	99	6	9	620	632	19	Adineta ricciae ribosomal protein S7-like protein mRNA, complete cds	blastn	616	556	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
4498526	4498526	PRJNA690234_P_NODE_7684_length_464_cov_2.306905_g7318_i0	PRJNA690234	7684	464	2.306905	10.7040392	Adineta ricciae	249248	Rotifera	other_Eukaryota	440	8.229999999999997e-119	NTclustered	gi\|62362191\|gb\|AY942835.1\|	249248	g7318	i0	85.116	0.926724137931034	430	64	93	0	34	463	49	478	Adineta ricciae ribosomal protein L18a-like protein mRNA, complete cds	blastn	430	440	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
5773771	5773771	PRJNA690234_P_NODE_24925_length_253_cov_1.711111_g24558_i0	PRJNA690234	24925	253	1.711111	4.32911083	Philodina citrina	468664	Rotifera	other_Eukaryota	313	9.539999999999999e-81	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g24558	i0	88.976	68.2529644268775	254	26	100	2	1	253	5390	5138	Philodina citrina complete mitochondrial genome	blastn	17268	313	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
7048944	7048944	PRJNA690234_P_NODE_3166_length_740_cov_20.007496_g2828_i0	PRJNA690234	3166	740	20.007496	148.0554704	Philodina citrina	468664	Rotifera	other_Eukaryota	645	2.669999999999999e-180	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2828	i0	82.846	22.3486486486486	752	98	99	28	1	739	1660	2393	Philodina citrina complete mitochondrial genome	blastn	16538	645	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
14699442	14699442	PRJNA690234_P_NODE_9152_length_423_cov_1.114286_g8786_i0	PRJNA690234	9152	423	1.114286	4.71342978	Philodina roseola	96448	Rotifera	other_Eukaryota	492	2.03e-134	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g8786	i0	87.828	76.7328605200946	419	51	99	0	4	422	26872	26454	Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds	blastn	32458	492	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
22347630	22347630	PRJNA690234_P_NODE_2798_length_788_cov_2.562238_g2472_i0	PRJNA690234	2798	788	2.562238	20.19043544	Philodina megalotrocha	1234259	Rotifera	other_Eukaryota	1144	0	NTclustered	gi\|1976325703\|gb\|MW577596.1\|	1234259	g2472	i0	99.522	82.0736040609137	628	3	80	0	35	662	1	628	Philodina megalotrocha isolate RiGrAm.2.1 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	64674	1144	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina megalotrocha

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