metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA1264536" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA1264536" 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
363915	363915	PRJNA1264536_P_NODE_881_length_620_cov_1.857404_g809_i0	PRJNA1264536	881	620	1.857404	11.5159048	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	658	0	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g809	i0	86.949	24.674193548387105	590	71	95	6	7	592	2423	1836	Rotaria rotatoria mitochondrion, complete genome	blastn	15298	658	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
4191051	4191051	PRJNA1264536_P_NODE_544_length_781_cov_2.269774_g477_i0	PRJNA1264536	544	781	2.269774	17.72693494	Dicranophorus sp. MEG-2012	1225242	Rotifera	other_Eukaryota	632	2.2e-176	NTclustered	gi\|401880055\|gb\|JX216595.1\|	1225242	g477	i0	84.17	86.7554417413572	657	98	84	6	86	739	655	2	Dicranophorus sp. MEG-2012 voucher ECOCHZ-AG0580 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial	blastn	67756	632	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Dicranophoridae	Dicranophorus	Dicranophorus sp. MEG-2012
5467243	5467243	PRJNA1264536_P_NODE_3625_length_289_cov_1.083333_g3551_i0	PRJNA1264536	3625	289	1.083333	3.13083237	Philodina roseola	96448	Rotifera	other_Eukaryota	252	2.46e-62	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g3551	i0	82.534	9.51557093425606	292	45	100	6	1	289	39948	39660	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	2750	252	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
14393040	14393040	PRJNA1264536_P_NODE_1652_length_447_cov_1.090909_g1578_i0	PRJNA1264536	1652	447	1.090909	4.87636323	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	250	1.4299999999999998e-61	NTclustered	gi\|218117267\|emb\|AM980961.1\|	10195	g1578	i0	79.33	3.87919463087248	358	72	80	2	7	363	366	10	Brachionus plicatilis partial mRNA for 40S ribosomal protein S24, (RPS24 gene)	blastn	1734	250	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis

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