metadata: contig_metadata: 3 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax

3 rows where analysis = "blastn", bioproject = "PRJNA716463" 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
1984436	1984436	PRJNA716463_P_NODE_74262_length_273_cov_1.965000_g73845_i0	PRJNA716463	74262	273	1.965	5.36445	Philodina citrina	468664	Rotifera	other_Eukaryota	348	2.85e-91	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g73845	i0	89.744	46.3113553113553	273	27	100	1	1	273	10106	9835	Philodina citrina complete mitochondrial genome	blastn	12643	348	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
5810829	5810829	PRJNA716463_P_NODE_108065_length_244_cov_3.134503_g107647_i0	PRJNA716463	108065	244	3.134503	7.64818732	Philodina roseola	96448	Rotifera	other_Eukaryota	302	1.98e-77	NTclustered	gi\|183178964\|gb\|EU432549.1\|	96448	g107647	i0	88.98	2.00819672131148	245	25	100	2	1	244	19804	20047	Philodina roseola 7 transmembrane receptor (rhodopsin family) A (7tmrA_3), 7 transmembrane receptor (rhodopsin family) B (7tmrB_3), transmembrane receptor (rhodopsin family) C (7tmrC_3), 7 transmembrane receptor (rhodopsin family) D (7tmrD_3), myosin essential light chain (MELC_3), ArkA_3 (arkA_3), ArkB_3 (arkB_3), ArkC_3 (arkC_3), TRPA_3 (TPRA_3), 82 kDa heat shock protein (hsp82_3), LicD_3 (LicD_3), low density lipoprotein receptor (LDL_3), Zn carboxypeptidase gene (Zncarb_3), phosphoribosylaminoimidazole carboxylase (PAICS_3), unknown (PrPCG0002_3), lung-like 7 transmembrane receptor (lung_3), and phosphoglycerate-bisphosphoglycerate mutase (PGAM_3) genes, complete cds	blastn	490	302	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
7570778	7570778	PRJNA716463_P_NODE_47306_length_292_cov_3.086758_g46889_i0	PRJNA716463	47306	292	3.086758	9.01333336	Philodinidae	44580	Rotifera	other_Eukaryota	379	1.09e-100	NTclustered	gi\|239584535\|gb\|FJ426529.1\|	231624	g46889	i0	90.068	99.7979452054795	292	29	100	0	1	292	135	426	Rotaria rotatoria isolate R.rota.UK.12.20 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	29141	379	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria

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