metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA807347" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA807347" 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
806288	806288	PRJNA807347_P_NODE_13981_length_248_cov_0.885714_g13878_i0	PRJNA807347	13981	248	0.885714	2.19657072	Meleagris gallopavo	9103	Chordata	Chordata	392	1.1599999999999999e-104	NTclustered	gi\|2721460824\|emb\|HG999682.4\|	9103	g13878	i0	95.51	0.987903225806452	245	11	99	0	4	248	60268085	60267841	Meleagris gallopavo genome assembly, chromosome: 3	blastn	245	392	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
2082085	2082085	PRJNA807347_P_NODE_8102_length_289_cov_1.268519_g7999_i0	PRJNA807347	8102	289	1.268519	3.66601991	Muntiacus reevesi	9886	Chordata	Chordata	78.7	4.41e-10	NTclustered	gi\|2745986643\|ref\|XM_065928340.1\|	9886	g7999	i0	81.132	0.73356401384083	106	12	35	8	115	216	430	329	PREDICTED: Muntiacus reevesi tRNA-yW synthesizing protein 3 homolog (TYW3), transcript variant X1, mRNA	blastn	212	78.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Muntiacus	Muntiacus reevesi
5909681	5909681	PRJNA807347_P_NODE_14065_length_248_cov_0.880000_g13962_i0	PRJNA807347	14065	248	0.88	2.1824	Bos taurus	9913	Chordata	Chordata	161	3.5699999999999995e-35	NTclustered	gi\|161485014\|gb\|AC213701.3\|	9913	g13962	i0	100	39.7379032258064	87	0	35	0	162	248	86256	86342	Bos taurus Y Chr BAC CH240-1L11 (Children's Hospital Oakland Research Institute Bovine BAC Library (male)) complete sequence	blastn	9855	161	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
7184586	7184586	PRJNA807347_P_NODE_4926_length_371_cov_2.275168_g4823_i0	PRJNA807347	4926	371	2.275168	8.44087328	Mus musculus	10090	Chordata	Chordata	579	1.3099999999999997e-160	NTclustered	gi\|2904934857\|gb\|PQ737780.1\|	10090	g4823	i0	100	87.5956873315364	313	0	84	0	59	371	314	2	Mus musculus lncRNA190 lncRNA, complete sequence	blastn	32498	579	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
8459269	8459269	PRJNA807347_P_NODE_14087_length_248_cov_0.874286_g13984_i0	PRJNA807347	14087	248	0.874286	2.16822928	Meleagris gallopavo	9103	Chordata	Chordata	453	5.2600000000000005e-123	NTclustered	gi\|2721460868\|emb\|HG999686.4\|	9103	g13984	i0	99.597	1	248	1	100	0	1	248	29999358	29999605	Meleagris gallopavo genome assembly, chromosome: 6	blastn	248	453	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
8459321	8459321	PRJNA807347_P_NODE_5107_length_364_cov_1.725086_g5004_i0	PRJNA807347	5107	364	1.725086	6.27931304	Canis lupus	9612	Chordata	Chordata	595	1.2699999999999995e-165	NTclustered	gi\|48526371\|gb\|AY633658.1\|	9615	g5004	i0	96.154	39.1098901098901	364	14	100	0	1	364	731	368	Canis familiaris clone 2 Bsp repeat region	blastn	14236	595	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
8459331	8459331	PRJNA807347_P_NODE_7267_length_303_cov_1.786957_g7164_i0	PRJNA807347	7267	303	1.786957	5.41447971	Canis lupus	9612	Chordata	Chordata	54.7	0.008	NTclustered	gi\|1628757286\|gb\|MK829588.1\|	9615	g7164	i0	100	0.188118811881188	29	0	10	0	1	29	3507	3479	Canis lupus familiaris clone Zoey_170_1884 sequence, complete sequence	blastn	57	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
9734351	9734351	PRJNA807347_P_NODE_5028_length_367_cov_2.574830_g4925_i0	PRJNA807347	5028	367	2.57483	9.4496261	Bos taurus	9913	Chordata	Chordata	52.8	0.035	NTclustered	gi\|2587699584\|ref\|XR_009493505.1\|	9913	g4925	i0	100	0.0762942779291553	28	0	8	0	334	361	2851	2878	PREDICTED: Bos taurus uncharacterized lncRNA (LOC112445042), transcript variant X2, ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
12285721	12285721	PRJNA807347_P_NODE_17050_length_242_cov_0.917160_g16947_i0	PRJNA807347	17050	242	0.91716	2.2195272	Orcinus orca	9733	Chordata	Chordata	196	9.52e-46	NTclustered	gi\|2280678315\|ref\|XM_033435622.2\|	9733	g16947	i0	85.279	90.9214876033058	197	22	79	5	52	241	5542	5346	PREDICTED: Orcinus orca diphosphoinositol pentakisphosphate kinase 1 (PPIP5K1), transcript variant X24, mRNA	blastn	22003	196	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Orcinus	Orcinus orca
12285745	12285745	PRJNA807347_P_NODE_7770_length_293_cov_3060.586364_g7667_i0	PRJNA807347	7770	293	3060.586364	8967.51804652	Mus musculus	10090	Chordata	Chordata	110	1.59e-19	NTclustered	gi\|6561392\|gb\|AF162708.1\|AF162708	57486	g7667	i0	100	31.4948805460751	59	0	20	0	235	293	26	84	Mus musculus molossinus endogenous proviral sequence Mo1	blastn	9228	110	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13559875	13559875	PRJNA807347_P_NODE_13431_length_249_cov_0.880682_g13328_i0	PRJNA807347	13431	249	0.880682	2.19289818	Halichoerus grypus	9711	Chordata	Chordata	165	2.77e-36	NTclustered	gi\|1899969908\|ref\|XM_036074441.1\|	9711	g13328	i0	81.25	5.80722891566265	208	36	82	2	1	205	4237	4030	PREDICTED: Halichoerus grypus death domain-containing protein CRADD-like (LOC118524311), transcript variant X1, mRNA	blastn	1446	165	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Halichoerus	Halichoerus grypus
13976348	13976348	PRJNA807347_P_NODE_11211_length_256_cov_2.349727_g11108_i0	PRJNA807347	11211	256	2.349727	6.01530112	Lampetra	13103	Chordata	Chordata	69.4	2.31e-7	NTclustered	gi\|2815005712\|emb\|OZ078592.2\|	7748	g11108	i0	87.931	9.01953125	58	7	23	0	81	138	7102683	7102626	Lampetra fluviatilis genome assembly, chromosome: 24	blastn	2309	69.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
14834535	14834535	PRJNA807347_P_NODE_16152_length_244_cov_0.871345_g16049_i0	PRJNA807347	16152	244	0.871345	2.1260818	Myxine glutinosa	7769	Chordata	Chordata	276	1.1999999999999998e-69	NTclustered	gi\|2797584620\|ref\|XR_010983200.1\|	7769	g16049	i0	87.967	96.8073770491803	241	20	95	5	12	244	6196	5957	PREDICTED: Myxine glutinosa RNA-binding protein with multiple splicing 2-like (LOC137420812), transcript variant X1, misc_RNA	blastn	23621	276	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
15250564	15250564	PRJNA807347_P_NODE_11272_length_256_cov_1.469945_g11169_i0	PRJNA807347	11272	256	1.469945	3.7630592	Pteropus	9401	Chordata	Chordata	58.4	5e-4	NTclustered	gi\|1387541159\|ref\|XR_003043482.1\|	9402	g11169	i0	97.059	0.6171875	34	1	13	0	214	247	1069	1036	PREDICTED: Pteropus alecto uncharacterized LOC112471938 (LOC112471938), ncRNA	blastn	158	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Pteropodidae	Pteropus	Pteropus alecto
16108705	16108705	PRJNA807347_P_NODE_13653_length_248_cov_2.097143_g13550_i0	PRJNA807347	13653	248	2.097143	5.20091464	Gulo gulo	48420	Chordata	Chordata	219	2.0899999999999994e-52	NTclustered	gi\|2490667951\|gb\|ON667489.1\|	2888765	g13550	i0	90.419	206.979838709677	167	14	67	2	84	248	4882	5048	Gulo gulo luscus CLN6 (CLN6) gene, complete cds	blastn	51331	219	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Gulo	Gulo gulo
16108778	16108778	PRJNA807347_P_NODE_9493_length_273_cov_1.460000_g9390_i0	PRJNA807347	9493	273	1.46	3.9858	Canis lupus	9612	Chordata	Chordata	261	3.83e-65	NTclustered	gi\|1239976092\|ref\|XR_002622131.1\|	9615	g9390	i0	93.258	116.413919413919	178	10	65	2	48	225	1	176	PREDICTED: Canis lupus familiaris uncharacterized LOC102154537 (LOC102154537), transcript variant X1, ncRNA	blastn	31781	261	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
16525275	16525275	PRJNA807347_P_NODE_11093_length_257_cov_2.173913_g10990_i0	PRJNA807347	11093	257	2.173913	5.58695641	Physalaemus	8377	Chordata	Chordata	276	1.27e-69	NTclustered	gi\|2323444364\|gb\|OK634322.1\|	218685	g10990	i0	99.346	3.46303501945525	153	0	60	1	105	257	284	133	Physalaemus cuvieri voucher ZUEC 14699 5S ribosomal RNA and non-transcribed spacer intergenic spacer, partial sequence	blastn	890	276	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Physalaemus	Physalaemus cuvieri
17384638	17384638	PRJNA807347_P_NODE_8714_length_281_cov_2.774038_g8611_i0	PRJNA807347	8714	281	2.774038	7.79504678	Meleagris gallopavo	9103	Chordata	Chordata	501	2.14e-137	NTclustered	gi\|2721460868\|emb\|HG999686.4\|	9103	g8611	i0	98.932	1	281	1	100	1	1	281	29272003	29271725	Meleagris gallopavo genome assembly, chromosome: 6	blastn	281	501	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
22483211	22483211	PRJNA807347_P_NODE_7278_length_303_cov_1.073913_g7175_i0	PRJNA807347	7278	303	1.073913	3.25395639	Lepidochelys kempii	8472	Chordata	Chordata	52.8	0.028	NTclustered	gi\|2911501205\|emb\|OZ223609.1\|	8472	g7175	i0	100	0.36963696369637	28	0	9	0	147	174	6445275	6445302	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 23	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
23758920	23758920	PRJNA807347_P_NODE_15399_length_245_cov_0.906977_g15296_i0	PRJNA807347	15399	245	0.906977	2.22209365	Canis lupus	9612	Chordata	Chordata	448	2.41e-121	NTclustered	gi\|2272577751\|ref\|XR_003139955.3\|	286419	g15296	i0	99.592	1	245	1	100	0	1	245	9302	9546	PREDICTED: Canis lupus dingo uncharacterized LOC112664769 (LOC112664769), ncRNA	blastn	245	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
23758926	23758926	PRJNA807347_P_NODE_16019_length_244_cov_0.906433_g15916_i0	PRJNA807347	16019	244	0.906433	2.21169652	Canis lupus	9612	Chordata	Chordata	368	1.92e-97	NTclustered	gi\|124286928\|gb\|AC187296.11\|	9615	g15916	i0	93.852	15.2704918032787	244	15	100	0	1	244	53027	52784	Canis Familiaris chromosome 37, clone XX-85M13, complete sequence	blastn	3726	368	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
23758958	23758958	PRJNA807347_P_NODE_8859_length_280_cov_1.280193_g8756_i0	PRJNA807347	8859	280	1.280193	3.5845404	Gulo gulo	48420	Chordata	Chordata	217	8.649999999999999e-52	NTclustered	gi\|2240007294\|gb\|OM350512.1\|	2888765	g8756	i0	81.495	39.6571428571429	281	36	99	10	1	278	1917470	1917203	Gulo gulo luscus DMD (DMD) gene, complete cds	blastn	11104	217	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Gulo	Gulo gulo
24174122	24174122	PRJNA807347_P_NODE_12859_length_250_cov_0.881356_g12756_i0	PRJNA807347	12859	250	0.881356	2.20339	Sciuridae	55153	Chordata	Chordata	52.8	0.023	NTclustered	gi\|2262808454\|ref\|XM_015478853.2\|	9994	g12756	i0	100	0.448	28	0	11	0	202	229	1497	1470	PREDICTED: Marmota marmota marmota integrin subunit beta 2 (Itgb2), mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Marmota	Marmota marmota
25032726	25032726	PRJNA807347_P_NODE_14000_length_248_cov_0.885714_g13897_i0	PRJNA807347	14000	248	0.885714	2.19657072	Halichoerus grypus	9711	Chordata	Chordata	189	1.6399999999999996e-43	NTclustered	gi\|1900018745\|ref\|XR_004925078.1\|	9711	g13897	i0	86.782	1.08467741935484	174	17	68	4	2	170	436	608	PREDICTED: Halichoerus grypus uncharacterized LOC118551485 (LOC118551485), ncRNA	blastn	269	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Halichoerus	Halichoerus grypus

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