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

5 rows where analysis = "blastn", bioproject = "PRJNA773247" 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
3758742	3758742	PRJNA773247_P_NODE_1703_length_1517_cov_7.157202_g1670_i0	PRJNA773247	1703	1517	7.157202	108.57475434	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	1709	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g1670	i0	87.088	44.4515491100857	1518	187	99	9	1	1514	18	1530	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	67433	1709	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
14777943	14777943	PRJNA773247_P_NODE_7152_length_623_cov_5.341818_g7069_i0	PRJNA773247	7152	623	5.341818	33.27952614	Philodina citrina	468664	Rotifera	other_Eukaryota	745	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g7069	i0	88.413	19.4991974317817	630	58	100	15	1	623	2390	1769	Philodina citrina complete mitochondrial genome	blastn	12148	745	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
16051335	16051335	PRJNA773247_P_NODE_1653_length_1539_cov_8.330832_g1620_i0	PRJNA773247	1653	1539	8.330832	128.21150448	Brachionus rubens	392764	Rotifera	other_Eukaryota	1358	0	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g1620	i0	82.64	51.8291098115659	1538	263	99	4	1	1536	26	1561	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	79765	1358	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
18600637	18600637	PRJNA773247_P_NODE_24355_length_285_cov_1.740566_g24271_i0	PRJNA773247	24355	285	1.740566	4.9606131	Brachionus rubens	392764	Rotifera	other_Eukaryota	182	3.2199999999999987e-41	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g24271	i0	78.369	3.18245614035088	282	59	99	2	2	282	5902	6182	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	907	182	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
21151675	21151675	PRJNA773247_P_NODE_5617_length_737_cov_6.403614_g5538_i0	PRJNA773247	5617	737	6.403614	47.19463518	Philodina citrina	468664	Rotifera	other_Eukaryota	608	3.489999999999998e-169	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g5538	i0	81.696	7.57259158751696	743	124	100	9	1	737	11123	10387	Philodina citrina complete mitochondrial genome	blastn	5581	608	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina

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