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

5 rows where analysis = "blastn", bioproject = "PRJNA485080" 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
8102020	8102020	PRJNA485080_P_NODE_12747_length_310_cov_1.637131_g12653_i0	PRJNA485080	12747	310	1.637131	5.0751061	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	76.8	1.72e-9	NTclustered	gi\|403082243\|gb\|JX463646.1\|	104777	g12653	i0	85.333	2.52258064516129	75	10	24	1	55	128	849	775	Brachionus calyciflorus NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	782	76.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
9376899	9376899	PRJNA485080_P_NODE_228_length_1444_cov_3.401167_g194_i0	PRJNA485080	228	1444	3.401167	49.11285148	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	571	9.2e-158	NTclustered	gi\|2006240390\|gb\|MW559989.1\|	667381	g194	i0	74.419	32.6668975069252	1462	313	99	50	4	1431	5677	7111	Brachionus manjavacas isolate DE chromosome II mitochondrion, complete sequence	blastn	47171	571	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
13202701	13202701	PRJNA485080_P_NODE_2271_length_601_cov_4.435606_g2179_i0	PRJNA485080	2271	601	4.435606	26.65799206	Brachionus koreanus	1199090	Rotifera	other_Eukaryota	220	1.5399999999999996e-52	NTclustered	gi\|477541870\|gb\|KC603851.1\|	1199090	g2179	i0	76.147	0.725457570715474	436	94	72	9	6	436	9020	8590	Brachionus sp. 'koreanus' chromosome I mitochondrion, complete sequence	blastn	436	220	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus koreanus
15751677	15751677	PRJNA485080_P_NODE_1613_length_693_cov_4.075806_g1527_i0	PRJNA485080	1613	693	4.075806	28.24533558	Lecane inermis	1471631	Rotifera	other_Eukaryota	909	0	NTclustered	gi\|1957982515\|gb\|MW487867.1\|	1471631	g1527	i0	91.515	93.5743145743146	660	56	95	0	2	661	660	1	Lecane inermis voucher NNIBRIV50291 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	64847	909	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lecanidae	Lecane	Lecane inermis
17026673	17026673	PRJNA485080_P_NODE_634_length_990_cov_2.880044_g576_i0	PRJNA485080	634	990	2.880044	28.5124356	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	562	3.75e-155	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g576	i0	79.023	35.0838383838384	839	162	84	12	2	833	38	869	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	34733	562	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.

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