metadata: contig_metadata: 5 rows where bioproject = "PRJNA999747", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA999747", tax_kingdom = "Metazoa" 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
6083756	6083756	PRJNA999747_S_NODE_1045_length_288_cov_29.700389_g1013_i0	PRJNA999747	1045	288	29.700389	85.53712032	Brachionus urceolaris	204736	Rotifera	other_Eukaryota	335	2.359999999999999e-87	NTclustered	gi\|72153738\|gb\|DQ089740.1\|	204736	g1013	i0	89.091	46.6006944444444	275	22	93	6	17	285	2091	1819	Brachionus urceolaris 28S ribosomal RNA gene, partial sequence	blastn	13421	335	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus urceolaris
11183896	11183896	PRJNA999747_S_NODE_2909_length_182_cov_6.311258_g2877_i0	PRJNA999747	2909	182	6.311258	11.48648956	Brachionus urceolaris	204736	Rotifera	other_Eukaryota	268	1.4099999999999999e-67	NTclustered	gi\|72153738\|gb\|DQ089740.1\|	204736	g2877	i0	94.318	16.4450549450549	176	9	96	1	6	180	1530	1705	Brachionus urceolaris 28S ribosomal RNA gene, partial sequence	blastn	2993	268	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus urceolaris
12459754	12459754	PRJNA999747_S_NODE_2690_length_189_cov_6.094937_g2658_i0	PRJNA999747	2690	189	6.094937	11.51943093	Ascomorpha ovalis	360655	Rotifera	other_Eukaryota	254	4.14e-63	NTclustered	gi\|83285183\|gb\|DQ297730.1\|	360655	g2658	i0	91.398	83.7777777777778	186	14	98	2	1	186	933	750	Ascomorpha ovalis 28S ribosomal RNA gene, partial sequence	blastn	15834	254	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Gastropidae	Ascomorpha	Ascomorpha ovalis
23932980	23932980	PRJNA999747_S_NODE_1139_length_279_cov_5.842742_g1107_i0	PRJNA999747	1139	279	5.842742	16.30125018	Lepadella patella	231622	Rotifera	other_Eukaryota	309	1.3800000000000002e-79	NTclustered	gi\|83285192\|gb\|DQ297739.1\|	231622	g1107	i0	87.273	68.1182795698925	275	29	97	4	6	276	585	313	Lepadella patella 28S ribosomal RNA gene, partial sequence	blastn	19005	309	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lepadellidae	Lepadella	Lepadella patella
29363490	29363490	PRJNA999747_S_NODE_2309_length_202_cov_2.602339_g2277_i0	PRJNA999747	2309	202	2.602339	5.25672478	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	114	1.3800000000000002e-27	NR	CAF1039794.1	104777	g2277	i0	75.8	0.98019801980198	66	16	98	0	199	2	348	413	CAF1039794.1 unnamed protein product [Brachionus calyciflorus]	diamond	198	114	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus

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