metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA980587" 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
956415	956415	PRJNA980587_P_NODE_9981_length_881_cov_2.246287_g9313_i0	PRJNA980587	9981	881	2.246287	19.78978847	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	918	0	NTclustered	gi\|402761789\|gb\|JX184026.1\|	104786	g9313	i0	85.471	41.8308740068104	881	128	100	0	1	881	30	910	Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	36853	918	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
2545135	2545135	PRJNA980587_P_NODE_12942_length_750_cov_52.345643_g12205_i0	PRJNA980587	12942	750	52.345643	392.5923225	Philodinidae	44580	Rotifera	other_Eukaryota	828	0	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g12205	i0	86.79	23.888	757	82	99	16	4	750	2423	1675	Rotaria rotatoria mitochondrion, complete genome	blastn	17916	828	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
8608574	8608574	PRJNA980587_P_NODE_47767_length_333_cov_3.542308_g46974_i0	PRJNA980587	47767	333	3.542308	11.79588564	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	411	4.489999999999999e-110	NTclustered	gi\|402761731\|gb\|JX183997.1\|	104788	g46974	i0	88.889	83.3633633633634	333	37	100	0	1	333	433	765	Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	27760	411	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
9883473	9883473	PRJNA980587_P_NODE_20128_length_567_cov_2.028340_g19340_i0	PRJNA980587	20128	567	2.02834	11.5006878	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	398	6.229999999999997e-106	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g19340	i0	79.613	1.36331569664903	569	104	99	11	5	567	3118	3680	Rotaria rotatoria mitochondrion, complete genome	blastn	773	398	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
11473269	11473269	PRJNA980587_P_NODE_38869_length_375_cov_2.337748_g38076_i0	PRJNA980587	38869	375	2.337748	8.766555	Philodinida	104783	Rotifera	other_Eukaryota	420	8.49e-113	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g38076	i0	87.062	89.8773333333333	371	48	99	0	1	371	16	386	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	33704	420	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
14983352	14983352	PRJNA980587_P_NODE_29712_length_443_cov_3.548649_g28919_i0	PRJNA980587	29712	443	3.548649	15.72051507	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	571	2.6599999999999998e-158	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g28919	i0	90.023	48.783295711061	441	44	99	0	1	441	138	578	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	21611	571	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
18807129	18807129	PRJNA980587_P_NODE_13975_length_715_cov_6.048287_g13226_i0	PRJNA980587	13975	715	6.048287	43.24525205	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	931	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g13226	i0	90.196	89.9566433566434	714	70	99	0	1	714	759	1472	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	64319	931	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
23907861	23907861	PRJNA980587_P_NODE_20499_length_561_cov_2.020492_g19711_i0	PRJNA980587	20499	561	2.020492	11.33496012	Adineta vaga	104782	Rotifera	other_Eukaryota	566	1.6e-156	NTclustered	gi\|402761771\|gb\|JX184017.1\|	104782	g19711	i0	85.635	1.32263814616756	543	72	96	6	15	554	575	36	Adineta vaga cytochrome c oxidase subunit 3 (COX3) gene, partial cds; mitochondrial	blastn	742	566	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
23908321	23908321	PRJNA980587_P_NODE_55979_length_305_cov_2.560345_g55186_i0	PRJNA980587	55979	305	2.560345	7.80905225	Adineta ricciae	249248	Rotifera	other_Eukaryota	333	9.069999999999998e-87	NTclustered	gi\|62362191\|gb\|AY942835.1\|	249248	g55186	i0	87.986	0.927868852459016	283	32	92	2	24	305	592	311	Adineta ricciae ribosomal protein L18a-like protein mRNA, complete cds	blastn	283	333	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae

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