metadata: contig_metadata: 9 rows where bioproject = "PRJEB65099", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJEB65099", tax_clade = "Opisthokonta" and tax_phylum = "Chordata"

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
2680042	2680042	PRJEB65099_P_NODE_3643_length_292_cov_1.068493_g3538_i0	PRJEB65099	3643	292	1.068493	3.11999956	Rattus norvegicus	10116	Chordata	Chordata	540	4.74e-149	NTclustered	gi\|298882625\|emb\|FQ211010.1\|	10116	g3538	i0	100	97.4280821917808	292	0	100	0	1	292	183	474	Rattus norvegicus TL0ABA18YP20 mRNA sequence	blastn	28449	540	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
6097041	6097041	PRJEB65099_P_NODE_5245_length_251_cov_0.876404_g5140_i0	PRJEB65099	5245	251	0.876404	2.19977404	Lampetra	13103	Chordata	Chordata	287	5.73e-73	NTclustered	gi\|2815010089\|emb\|OZ078632.2\|	7748	g5140	i0	93.782	93.0159362549801	193	8	76	2	1	190	4105374	4105183	Lampetra fluviatilis genome assembly, chromosome: 64	blastn	23347	287	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
6508174	6508174	PRJEB65099_P_NODE_5866_length_247_cov_1.551724_g5761_i0	PRJEB65099	5866	247	1.551724	3.83275828	Mus musculus	10090	Chordata	Chordata	56.5	0.002	NTclustered	gi\|47551370\|gb\|AC026233.4\|	10090	g5761	i0	94.444	0.291497975708502	36	2	15	0	112	147	129429	129464	Mus musculus strain C57BL6/J chromosome 5 clone RP23-407F12, complete sequence	blastn	72	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9057218	9057218	PRJEB65099_P_NODE_6148_length_246_cov_0.901734_g6043_i0	PRJEB65099	6148	246	0.901734	2.21826564	Sus scrofa	9823	Chordata	Chordata	67.6	7.94e-7	NTclustered	gi\|168149178\|emb\|CT797459.5\|	9823	g6043	i0	86.885	0.463414634146341	61	7	24	1	162	221	69063	69123	Pig DNA sequence from clone CH242-214A4 on chromosome 7, complete sequence	blastn	114	67.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
15021770	15021770	PRJEB65099_P_NODE_6592_length_243_cov_1.811765_g6487_i0	PRJEB65099	6592	243	1.811765	4.40258895	Bos	9903	Chordata	Chordata	420	5.21e-113	NTclustered	gi\|1068294018\|gb\|KX592814.1\|	9913	g6487	i0	97.942	249.938271604938	243	4	100	1	1	243	5676253	5676494	Bos taurus isolate Dominette_000065F genomic sequence	blastn	60735	422	0.995260663507109	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
16706619	16706619	PRJEB65099_P_NODE_5314_length_251_cov_0.876404_g5209_i0	PRJEB65099	5314	251	0.876404	2.19977404	Rattus norvegicus	10116	Chordata	Chordata	449	6.899999999999999e-122	NTclustered	gi\|229220814\|gb\|AC115369.5\|	10116	g5209	i0	99.2	4.54183266932271	250	1	99	1	1	250	67102	66854	Rattus norvegicus CH230-89H17 (Children's Hospital Oakland Research Institute Rat (BN/SsNHsd/MCW) BAC library) complete sequence	blastn	1140	449	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
17981489	17981489	PRJEB65099_P_NODE_5315_length_251_cov_0.876404_g5210_i0	PRJEB65099	5315	251	0.876404	2.19977404	Sus scrofa	9823	Chordata	Chordata	346	9.32e-91	NTclustered	gi\|1191804880\|ref\|XM_005659135.3\|	9823	g5210	i0	97.525	4.0398406374502	202	5	90	0	27	228	6404	6203	PREDICTED: Sus scrofa coiled-coil domain containing 170 (CCDC170), transcript variant X1, mRNA	blastn	1014	346	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
20530936	20530936	PRJEB65099_P_NODE_6677_length_243_cov_0.917647_g6572_i0	PRJEB65099	6677	243	0.917647	2.22988221	Sus scrofa	9823	Chordata	Chordata	95.3	3.59e-15	NTclustered	gi\|116636932\|emb\|CT737289.9\|	9823	g6572	i0	90.411	0.860082304526749	73	6	30	1	172	243	158367	158439	Pig DNA sequence from clone CH242-133B3 on chromosome 14, complete sequence	blastn	209	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
31392879	31392879	PRJEB65099_P_NODE_6916_length_242_cov_0.923077_g6811_i0	PRJEB65099	6916	242	0.923077	2.23384634	Leucoraja erinaceus	7782	Chordata	Chordata	45.8	0.0029	NR	XP_055511116.1	7782	g6811	i0	40.9	4.09090909090909	66	39	81.8	0	202	5	189	254	XP_055511116.1 uncharacterized protein LOC129709027 [Leucoraja erinaceus]	diamond	990	45.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Leucoraja	Leucoraja erinaceus

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