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

9 rows where analysis = "blastn", bioproject = "PRJNA1240804" 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
4878282	4878282	PRJNA1240804_P_NODE_38944_length_240_cov_1.680628_g38578_i0	PRJNA1240804	38944	240	1.680628	4.0335072	Metazoa	33208	Rotifera	other_Eukaryota	411	3.089999999999999e-110	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g38578	i0	99.556	65.7458333333333	225	1	94	0	15	239	2058	2282	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	15779	411	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
8001840	8001840	PRJNA1240804_P_NODE_54967_length_212_cov_1.055215_g54601_i0	PRJNA1240804	54967	212	1.055215	2.2370558	Adineta vaga	104782	Rotifera	other_Eukaryota	357	3.53e-94	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g54601	i0	97.156	3.38207547169811	211	6	99	0	2	212	10154	10364	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	717	357	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13803329	13803329	PRJNA1240804_P_NODE_123331_length_166_cov_1.666667_g122965_i0	PRJNA1240804	123331	166	1.666667	2.76666722	Ploima	84394	Rotifera	other_Eukaryota	233	4.63e-57	NTclustered	gi\|61200811\|gb\|AY829085.1\|	84397	g122965	i0	94.118	66.2168674698795	153	9	92	0	14	166	2413	2565	Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence	blastn	10992	233	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sieboldii
14377517	14377517	PRJNA1240804_P_NODE_52872_length_215_cov_0.855422_g52506_i0	PRJNA1240804	52872	215	0.855422	1.8391573	Anomopus telphusae	338910	Rotifera	other_Eukaryota	333	6.039999999999999e-87	NTclustered	gi\|72153748\|gb\|DQ089741.1\|	338910	g52506	i0	96.535	10.6418604651163	202	6	93	1	15	215	2400	2601	Anomopus telphusae 28S ribosomal RNA gene, partial sequence	blastn	2288	333	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Anomopus	Anomopus telphusae
15650656	15650656	PRJNA1240804_P_NODE_16293_length_337_cov_5.263889_g15928_i0	PRJNA1240804	16293	337	5.263889	17.73930593	Asplanchna sieboldii	84397	Rotifera	other_Eukaryota	484	2.6499999999999995e-132	NTclustered	gi\|61200811\|gb\|AY829085.1\|	84397	g15928	i0	95.973	86.353115727003	298	12	88	0	2	299	1729	1432	Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence	blastn	29101	484	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sieboldii
16924938	16924938	PRJNA1240804_P_NODE_18554_length_321_cov_1.113971_g18188_i0	PRJNA1240804	18554	321	1.113971	3.57584691	Ploesoma truncatum	2851073	Rotifera	other_Eukaryota	263	1.28e-65	NTclustered	gi\|83285204\|gb\|DQ297751.1\|	2851073	g18188	i0	82.222	55.98753894081	315	46	95	7	17	321	448	762	Ploesoma truncatus 28S ribosomal RNA gene, partial sequence	blastn	17972	263	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Synchaetidae	Ploesoma	Ploesoma truncatum
20176272	20176272	PRJNA1240804_P_NODE_21236_length_304_cov_5.007843_g20870_i0	PRJNA1240804	21236	304	5.007843	15.22384272	Synchaeta	204744	Rotifera	other_Eukaryota	514	3.01e-141	NTclustered	gi\|1635377388\|gb\|MK896813.1\|	2576783	g20870	i0	98.621	95.3881578947368	290	4	95	0	1	290	839	550	Synchaeta baltica isolate 110116_BS_WHV_D1 small subunit ribosomal RNA gene, partial sequence	blastn	28998	514	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Synchaetidae	Synchaeta	Synchaeta baltica
24002300	24002300	PRJNA1240804_P_NODE_57839_length_208_cov_1.125786_g57473_i0	PRJNA1240804	57839	208	1.125786	2.34163488	Opisthokonta	33154	Rotifera	other_Eukaryota	344	2.6799999999999993e-90	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g57473	i0	98.462	80.0384615384615	195	3	94	0	14	208	6789	6983	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	16648	344	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
24574413	24574413	PRJNA1240804_P_NODE_36000_length_247_cov_2.424242_g35634_i0	PRJNA1240804	36000	247	2.424242	5.98787774	Philodina roseola	96448	Rotifera	other_Eukaryota	449	6.78e-122	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g35634	i0	99.593	59.4251012145749	246	1	99	0	2	247	1817	1572	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	14678	449	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola

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