metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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
3589300	3589300	PRJNA1160211_S_NODE_299023_length_206_cov_20.060150_g297790_i0	PRJNA1160211	299023	206	20.06015	41.323909	Ploima	84394	Rotifera	other_Eukaryota	331	2.0700000000000002e-86	NTclustered	gi\|259090060\|gb\|GQ503608.1\|	204738	g297790	i0	98.919	89.7621359223301	185	2	90	0	1	185	373	189	Keratella cochlearis 18S ribosomal RNA gene, partial sequence	blastn	18491	331	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Keratella	Keratella cochlearis
4137151	4137151	PRJNA1160211_S_NODE_285124_length_238_cov_8.412121_g283891_i0	PRJNA1160211	285124	238	8.412121	20.02084798	Philodina roseola	96448	Rotifera	other_Eukaryota	222	1.54e-53	NTclustered	gi\|187936070\|gb\|EU652317.1\|	96448	g283891	i0	84.348	25.6176470588235	230	32	96	4	11	238	19620	19847	Philodina roseola GTP binding protein, beta prime coatomer protein complex subunit, GPCR, beta-transducin repeat containing protein, speckle-type POZ protein, adenosine kinase, prefoldin subunit 1, translation initiation factor eIF-4E, Rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, cleft lip and palate associated transmembrane protein, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, and filament protein genes, complete cds	blastn	6097	222	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
5412664	5412664	PRJNA1160211_S_NODE_194165_length_317_cov_6.094262_g192932_i0	PRJNA1160211	194165	317	6.094262	19.31881054	Philodina roseola	96448	Rotifera	other_Eukaryota	494	4.1099999999999997e-135	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g192932	i0	96.939	42.6403785488959	294	9	93	0	24	317	2194	2487	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	13517	494	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
6687298	6687298	PRJNA1160211_S_NODE_157246_length_364_cov_16.563574_g156013_i0	PRJNA1160211	157246	364	16.563574	60.29140936	Adineta vaga	104782	Rotifera	other_Eukaryota	582	9.9e-162	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g156013	i0	99.686	4.7032967032967	318	1	87	0	1	318	9989	10306	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	1712	582	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13791742	13791742	PRJNA1160211_S_NODE_193511_length_318_cov_3.567347_g192278_i0	PRJNA1160211	193511	318	3.567347	11.34416346	Asplanchna	84396	Rotifera	other_Eukaryota	246	1.2699999999999999e-60	NTclustered	gi\|2899343712\|gb\|PQ788833.1\|	2005548	g192278	i0	84.462	31.4874213836478	251	37	79	1	47	297	2123	2371	Asplanchna brightwellii chromosome I mitochondrion, complete sequence	blastn	10013	246	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna brightwellii
19436804	19436804	PRJNA1160211_S_NODE_86656_length_484_cov_4.301703_g85436_i0	PRJNA1160211	86656	484	4.301703	20.82024252	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	560	6.34e-155	NTclustered	gi\|402761731\|gb\|JX183997.1\|	104788	g85436	i0	88	83.3367768595041	475	55	98	1	11	483	305	779	Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	40335	560	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
21440342	21440342	PRJNA1160211_S_NODE_195877_length_315_cov_5.847107_g194644_i0	PRJNA1160211	195877	315	5.847107	18.41838705	Eurotatoria	2816136	Rotifera	other_Eukaryota	529	1.1199999999999997e-145	NTclustered	gi\|72153672\|gb\|DQ089733.1\|	104782	g194644	i0	99.315	91.4857142857143	292	2	93	0	1	292	388	97	Adineta vaga 18S ribosomal RNA gene, complete sequence	blastn	28818	529	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
21985952	21985952	PRJNA1160211_S_NODE_136638_length_394_cov_9.408100_g135406_i0	PRJNA1160211	136638	394	9.4081	37.067914	Adineta vaga	104782	Rotifera	other_Eukaryota	206	2.7299999999999994e-48	NTclustered	gi\|187233667\|gb\|EU643500.1\|	104782	g135406	i0	83.333	10.005076142132	222	37	56	0	22	243	403	624	Adineta vaga ribosomal protein L11 mRNA, partial cds	blastn	3942	206	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga

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