contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA608660" and tax_phylum = "Verrucomicrobiota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3135561 | 3135561 | PRJNA608660_P_NODE_29003_length_241_cov_3.666667_g28647_i0 | PRJNA608660 | 29003 | 241 | 3.666667 | 8.83666747 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 366 | 6.82e-97 | NTclustered | gi|2874254040|emb|OY970364.1| | 412056 | g28647 | i0 | 96.413 | 111.755186721992 | 223 | 7 | 92 | 1 | 10 | 231 | 2168001 | 2167779 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1 | blastn | 26933 | 366 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 4975086 | 4975086 | PRJNA608660_P_NODE_37884_length_196_cov_2.476190_g37528_i0 | PRJNA608660 | 37884 | 196 | 2.47619 | 4.8533324 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 327 | 2.52e-85 | NTclustered | gi|2022020957|gb|CP059069.1| | 2562705 | g37528 | i0 | 96.939 | 576.765306122449 | 196 | 4 | 100 | 2 | 1 | 196 | 3411587 | 3411394 | Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome | blastn | 113046 | 327 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 8237739 | 8237739 | PRJNA608660_P_NODE_26087_length_261_cov_1.641509_g25731_i0 | PRJNA608660 | 26087 | 261 | 1.641509 | 4.28433849 | Prosthecobacter fusiformis | 48464 | Bacteria | Bacteria | 259 | 1.31e-64 | NTclustered | gi|12583974|gb|AF245378.1|AF245378 | 48464 | g25731 | i0 | 86.364 | 124.766283524904 | 242 | 28 | 92 | 5 | 16 | 255 | 489 | 251 | Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence | blastn | 32564 | 259 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fusiformis | |
| 10788804 | 10788804 | PRJNA608660_P_NODE_15889_length_365_cov_2.234177_g15535_i0 | PRJNA608660 | 15889 | 365 | 2.234177 | 8.15474605 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 501 | 2.86e-137 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g15535 | i0 | 93.023 | 228.057534246575 | 344 | 23 | 94 | 1 | 14 | 357 | 1074 | 732 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 83241 | 501 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 10789051 | 10789051 | PRJNA608660_P_NODE_43529_length_175_cov_2.238095_g43172_i0 | PRJNA608660 | 43529 | 175 | 2.238095 | 3.91666625 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 265 | 1.74e-66 | NTclustered | gi|781846438|emb|LN807658.1| | 156588 | g43172 | i0 | 96.835 | 89.5371428571429 | 158 | 5 | 90 | 0 | 8 | 165 | 260 | 103 | Uncultured Verrucomicrobia bacterium partial 16S rRNA gene, clone denovo5009 | blastn | 15669 | 265 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 12064312 | 12064312 | PRJNA608660_P_NODE_9570_length_482_cov_3.115473_g9227_i0 | PRJNA608660 | 9570 | 482 | 3.115473 | 15.01657986 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 553 | 1.0599999999999995e-152 | NTclustered | gi|2874254040|emb|OY970364.1| | 412056 | g9227 | i0 | 98.714 | 153.653526970954 | 311 | 4 | 98 | 0 | 6 | 316 | 2168484 | 2168174 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1 | blastn | 74061 | 553 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 12625994 | 12625994 | PRJNA608660_P_NODE_48230_length_164_cov_2.713043_g47873_i0 | PRJNA608660 | 48230 | 164 | 2.713043 | 4.44939052 | root | 1 | Root_unresolved | Root_unresolved | 303 | 3.42e-78 | NTclustered | gi|1774728408|gb|MN684281.1| | 2736 | g47873 | i0 | 100 | 99.8780487804878 | 164 | 0 | 100 | 0 | 1 | 164 | 561 | 724 | Verrucomicrobium spinosum strain MT_SG_E_24_27F.27F 16S ribosomal RNA gene, partial sequence | blastn | 16380 | 303 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 14613454 | 14613454 | PRJNA608660_P_NODE_10152_length_468_cov_3.677804_g9807_i0 | PRJNA608660 | 10152 | 468 | 3.677804 | 17.21212272 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 780 | 0 | NTclustered | gi|109727764|gb|DQ648945.1| | 156588 | g9807 | i0 | 99.304 | 91.1965811965812 | 431 | 3 | 92 | 0 | 37 | 467 | 700 | 270 | Uncultured Verrucomicrobia bacterium clone lhac19 16S ribosomal RNA gene, partial sequence | blastn | 42680 | 780 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 15887637 | 15887637 | PRJNA608660_P_NODE_33933_length_214_cov_2.139394_g33577_i0 | PRJNA608660 | 33933 | 214 | 2.139394 | 4.57830316 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 357 | 3.5699999999999996e-94 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g33577 | i0 | 96.729 | 285.915887850467 | 214 | 7 | 100 | 0 | 1 | 214 | 2106 | 2319 | Luteolibacter sp. SL250 chromosome | blastn | 61186 | 357 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 16449679 | 16449679 | PRJNA608660_P_NODE_48193_length_164_cov_6.330435_g47836_i0 | PRJNA608660 | 48193 | 164 | 6.330435 | 10.3819134 | Luteolibacter | 518753 | Bacteria | Bacteria | 100 | 4.82e-17 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g47836 | i0 | 89.744 | 29.6341463414634 | 78 | 8 | 48 | 0 | 12 | 89 | 3804938 | 3805015 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 4860 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 17162311 | 17162311 | PRJNA608660_P_NODE_19654_length_319_cov_3.425926_g19298_i0 | PRJNA608660 | 19654 | 319 | 3.425926 | 10.92870394 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 448 | 3.2599999999999995e-121 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g19298 | i0 | 93.377 | 275.391849529781 | 302 | 20 | 95 | 0 | 18 | 319 | 1693 | 1392 | Luteolibacter sp. SL250 chromosome | blastn | 87850 | 448 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 19711194 | 19711194 | PRJNA608660_P_NODE_22336_length_293_cov_1.274590_g21980_i0 | PRJNA608660 | 22336 | 293 | 1.27459 | 3.7345487 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 470 | 6.33e-128 | NTclustered | gi|300679520|gb|HM238178.1| | 156588 | g21980 | i0 | 98.141 | 92.7133105802048 | 269 | 5 | 92 | 0 | 10 | 278 | 670 | 938 | Uncultured Verrucomicrobia bacterium clone BF_178 16S ribosomal RNA gene, partial sequence | blastn | 27165 | 470 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 20986914 | 20986914 | PRJNA608660_P_NODE_19177_length_325_cov_1.688406_g18821_i0 | PRJNA608660 | 19177 | 325 | 1.688406 | 5.4873195 | Candidatus Xiphinematobacter sp. | 1903058 | Bacteria | Bacteria | 388 | 2.05e-103 | NTclustered | gi|1966854496|gb|CP068475.1| | 1903058 | g18821 | i0 | 88.379 | 89.3907692307692 | 327 | 32 | 99 | 6 | 2 | 324 | 915387 | 915063 | MAG: Candidatus Xiphinematobacter sp. isolate P21 chromosome, complete genome | blastn | 29052 | 388 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Candidatus Xiphinematobacter | Candidatus Xiphinematobacter sp. | |||
| 22261817 | 22261817 | PRJNA608660_P_NODE_3198_length_772_cov_10.845090_g2958_i0 | PRJNA608660 | 3198 | 772 | 10.84509 | 83.7240948 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 826 | 0 | NTclustered | gi|164510704|emb|AJ966883.1| | 48466 | g2958 | i0 | 86.667 | 275.414507772021 | 750 | 95 | 97 | 5 | 13 | 760 | 4113 | 4859 | Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252 | blastn | 212620 | 826 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 22261852 | 22261852 | PRJNA608660_P_NODE_35578_length_206_cov_2.974522_g35222_i0 | PRJNA608660 | 35578 | 206 | 2.974522 | 6.12751532 | Verrucomicrobia bacterium IMCC26134 | 1637999 | Bacteria | Bacteria | 196 | 7.86e-46 | NTclustered | gi|807238858|gb|CP011265.1| | 1637999 | g35222 | i0 | 90.196 | 171.834951456311 | 153 | 12 | 74 | 3 | 44 | 195 | 1902810 | 1902660 | Verrucomicrobia bacterium IMCC26134, complete genome | blastn | 35398 | 196 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium IMCC26134 |
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);;